C#基础题目:如何把文本框的数据传到一个数据库空表中,关键的连接和传送代码是谢谢,

来源:百度知道 编辑:UC知道 时间:2024/07/04 12:01:36

刚写的一段代码,你看看吧。
protected void btnSubmit_Click(object sender, EventArgs e)
{
string connString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection conn=new SqlConnection (connString);
string cmd = @"insert into AddressLists(userId,frdName,frdPhone,frdMobilePhone,frdAddress,frdEmail,frdQQ) values(@userId,@Name,@Phone,@MobilePhone,@Address,@Email,@QQ)";
SqlCommand insertCmd = new SqlCommand(cmd, conn);
insertCmd.Parameters.Add("@userId", SqlDbType.VarChar, 15);
insertCmd.Parameters.Add("@Name", SqlDbType.VarChar, 10);
insertCmd.Parameters.Add("@Phone", SqlDbType.VarChar, 15);
insertCmd.Parameters.Add("@MobilePhone", SqlDbType.VarChar, 11);
insertCmd.Parameters.Add("@Address", SqlDbType.VarChar, 200);
insertCmd.Parameters.Add("