C#SqlParameter使用

2023年6月21日发(作者：)

C#SqlParameter使⽤ //ameter[] sqlParameters = new ameter[]{ }; ameter[] sqlParameters = new ameter[] { null, null }; //sqlParameters[0] = new ameter("@name","123"); ameter sp = new ameter("@name", "Pudding"); eScalar(, "select count(*) from xx where 姓名='@Name' and 电话='@tel'", sp); --不能带引号

object select_count = eScalar(, "select count(*) from xx where 姓名=@Name and 电话=@Tel ", sqlParameters); --这是正确的ameter[] sqlParameters = new ameter[] {new ameter("@Name", Name),new ameter("@Tel", Tel)}; 通过遍历ht 返回⼀个数组ameter[] sqlParameters private static SqlParameter[] GetParameter(Hashtable ht) { SqlParameter[] parameters = new SqlParameter[]; int i = 0; foreach (string key in ) { parameters[i] = new SqlParameter("@" + key, ht[key]); i++; } return parameters; }

2023年6月21日发(作者：)

C#SqlParameter使⽤ //ameter[] sqlParameters = new ameter[]{ }; ameter[] sqlParameters = new ameter[] { null, null }; //sqlParameters[0] = new ameter("@name","123"); ameter sp = new ameter("@name", "Pudding"); eScalar(, "select count(*) from xx where 姓名='@Name' and 电话='@tel'", sp); --不能带引号

object select_count = eScalar(, "select count(*) from xx where 姓名=@Name and 电话=@Tel ", sqlParameters); --这是正确的ameter[] sqlParameters = new ameter[] {new ameter("@Name", Name),new ameter("@Tel", Tel)}; 通过遍历ht 返回⼀个数组ameter[] sqlParameters private static SqlParameter[] GetParameter(Hashtable ht) { SqlParameter[] parameters = new SqlParameter[]; int i = 0; foreach (string key in ) { parameters[i] = new SqlParameter("@" + key, ht[key]); i++; } return parameters; }