Question

在ASP.NET里怎么把里面网页的用户信息添加到数据库中

Answer 1

string sql;
sql = "insert into Users(Name,Pwd) values(";
sql += "'"+ txt用户名.Text + "',";
sql += "'"+ txt密码.Text + "')";
SqlConnection sqlConnection1= new SqlConnection();
sqlConnection1.ConnectionString = "server=localhost;user id=sa;password=;initial catalog=BookStore";
sqlConnection1.Open();
SqlCommand sqlCommand1 = new SqlCommand();
sqlCommand1.Connection = sqlConnection1;
sqlCommand1.CommandText = sql;
sqlCommand1.ExecuteNonQuery();
sqlConnection1.Close();
Response.Write("<script language='javascript'> window.alert('数据已保存！');</script >");

Answer 2

先连接数据库，然后在按钮的后台事件里面写相关的添加语句代码

Answer 3

连接数据库然后写一个插入的方法