Question

VS2005 C# ASP.NET 插入数据库代码 检查下

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["cuiweiConnectionString7"].ConnectionString);
string bookBarcode1 = TextBox1.Text;
string sql = "insert into yonghu(id)values('" + bookBarcode1 + "')";
SqlDataReader dr;
SqlCommand cmd = new SqlCommand(sql, conn);
Response.Write("<script>alert('插入成功!')</script>");
那里错了 帮忙改下谢了
代码没问题 就是查不进去... 大概是没连上数据库 帮忙改下 我是本地 数据库叫cuiwei 帐号是windows默认的

Answer 1

//SqlDataReader dr;
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandText=sql;
cmd.ExecuteNonQuery();
Response.Write("<script>alert('插入成功!')</script>");