--测试数据if OBJECT_ID(tb) is not null drop table tb goCREATE TABLE tb(ID char(3),PID char(3),Name nvarchar(10))INSERT tb SELECT 001,NULL ,山东省UNION ALL SELECT 002,001,烟台市UNION ALL SELECT 004,002,招远市UNION ALL SELECT 003,001,青岛市UNION ALL SELECT 005,NULL ,四会市UNION ALL SELECT 006,005,清远市…

/// <summary> /// 过滤不安全的字符串 /// </summary> /// <param name="Str"></param> /// <returns></returns> public static string FilteSQLStr(string Str) { Str = Str.Replace("", ""); Str = Str.Replace(&quo…