.net中web连接数据库以及读取数据

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