1.在web.config中配置连接字符串
<appSettings>
<add key="pub" value="Data Source=(local);Initial Catalog=BookSample;User ID=sa;Password=123"/>
</appSettings>
注意Initial Catalog是数据库名 User ID是用户名 Password密码
2.执行修改操作
protected void Button1_Click(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["pub"].ToString();
SqlConnection myconn = new SqlConnection(constr);
myconn.Open();
string mysql = "insert into students values('***','123456','****','****','****')";
SqlCommand mycommand = new SqlCommand(mysql,myconn);
int i = mycommand.ExecuteNonQu