62,046
社区成员
发帖
与我相关
我的任务
分享
public void Insert()
{
string str_insert = "";
SqlConnection conn = new SqlConnection("数据库连接字符,这里我不写了");
SqlCommand cmd = new SqlCommand("insert into 表名(某字段名) values(@str_insert)", conn);
SqlParameter str = new SqlParameter("@str_insert", SqlDbType.VarChar, 50);
str.Value = str_insert;
cmd.Parameters.Add(str);
conn.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
str_insert=dbnull.value;
String str_insert = "";
SqlParameter str = new SqlParameter("@str_insert", SqlDbType.VarChar, 50);
str.Value = str_insert == "" ? null : str_insert;