62,046
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
//数据库中只有这个字段的情况下。
string sql = "insert into table values('" + DropDownList1.SelectedValue + "')";
int value = ExecuteNonQuery(sql);
}
public static int ExecuteNonQuery(string cmdtext)
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "链接字符串";
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = cmdtext;
cn.Open();
int value;
try
{
value = cmd.ExecuteNonQuery() > 0 ? 1 : 0;
}
catch (Exception ex)
{
throw ex;
}
finally
{
cn.Close();
}
return value;
}