protected void Button1_Click(object sender, EventArgs e)
{
try
{ SqlConnection cnn = new SqlConnection();
string strcnn = " server=CI88WES5ZKFIEIN;uid=sa;pwd=SQL2005;database=Libary";
cnn.ConnectionString = strcnn;
string kh = LX.Text;
string bbz = BZ.Text;
string ist = "INSERT INTO [Libary].[dbo].[adminConfig]([adminID],[adminName],[identityName]) values('" + kh + " ','" + bbz + "' ) ";
SqlCommand cmd = new SqlCommand(ist,cnn);
cnn.Open();
cnn.Close();
}
catch (Exception ex)
{ Console.WriteLine(ex.Message);
}
}
}
请问我这样为什么不能将TEXTBOX里面的内容提交到数据库呢。点了按钮以后没有反映,请问应该如何修改啊,谢谢
{
try
{ SqlConnection cnn = new SqlConnection();
string strcnn = " server=CI88WES5ZKFIEIN;uid=sa;pwd=SQL2005;database=Libary";
cnn.ConnectionString = strcnn;
string kh = LX.Text;
string bbz = BZ.Text;
string ist = "INSERT INTO [Libary].[dbo].[adminConfig]([adminID],[adminName],[identityName]) values('" + kh + " ','" + bbz + "' ) ";
SqlCommand cmd = new SqlCommand(ist,cnn);
cnn.Open();
cnn.Close();
}
catch (Exception ex)
{ Console.WriteLine(ex.Message);
}
}
}
请问我这样为什么不能将TEXTBOX里面的内容提交到数据库呢。点了按钮以后没有反映,请问应该如何修改啊,谢谢
SqlCommand cmd = new SqlCommand(ist,cnn);
cnn.Open();
cnn.Close();改成cnn.Open(); SqlCommand cmd = new SqlCommand(ist,cnn);
cnn.Close();
try
{ SqlConnection cnn = new SqlConnection();
string strcnn = " server=CI88WES5ZKFIEIN;uid=sa;pwd=SQL2005;database=Libary";
cnn.ConnectionString = strcnn;
string kh = LX.Text;
string bbz = BZ.Text;
string ist = "INSERT INTO [Libary].[dbo].[adminConfig]([adminID],[adminName],[identityName]) values('" + kh + " ','" + bbz + "' ) ";
SqlCommand cmd = new SqlCommand(ist,cnn);
cnn.Open();
cmd.ExecuteNonQuery(); cnn.Close();
}
catch (Exception ex)
{ Console.WriteLine(ex.Message);
}
}
谢谢你
但是这个一调用就出错啊,说为有此参数的构造函数