使用泛型参数传递对数据库进行增删改查
string sql = "insert into WisdomInformation(title,contents,type)values('@title','@contents','@type')";//一定需要加单引号,我曾经在这上面犯过错
Dictionary<string, string> dic = new Dictionary<string, string>();
dic.Add("@type",option);
dic.Add("@title", title);
int rows = SqlHelper.ExecuteNonQuey1(sql, dic);//自己写的方法
方法1
public static int ExecuteNonQuey1(string sql, Dictionary<string ,string> dic )
{
SqlParameter[] ps = new SqlParameter[dic.Count];
int index = 0;
foreach (var item in dic)
{
ps[index++] = new SqlParameter(item.Key, item.Value);
}
return ExecuteNonQuery2(sql,CommandType.Text, ps);//方法2
}
方法2
public static int ExecuteNonQuery2(string sql,CommandType type, SqlParameter []ps)
{
int rows=0;
using (SqlConnection con = Getcon())
{
con.Open();
foreach (SqlParameter var in ps)
{
sql = sql.Replace(var.ParameterName, var.Value.ToString());
}
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = type;
cmd.Parameters.AddRange(ps);
rows = cmd.ExecuteNonQuery();
}
return rows;
}