.net2.0下数据库连接字符串的使用

webconfig中添加:
                    <connectionStrings>
                    <add name="sqlstr" connectionString="Data Source=(local);Initial Catalog=book;Persist Security Info=True;User ID=sa;Password="
  providerName="System.Data.SqlClient" />
                  </connectionStrings>
程序中:
            System.Configuration.ConnectionStringSettings s = System.Configuration.ConfigurationManager.ConnectionStrings["sqlstr"];
        SqlConnection con = new SqlConnection();
        con.ConnectionString = s.ConnectionString;
        con.Open();
        SqlDataAdapter sdr = new SqlDataAdapter();
        sdr.SelectCommand = new SqlCommand("select * from users", con);
        DataSet ds = new DataSet();
        sdr.Fill(ds,"users");
        this.GridView1.DataSource = ds;
        GridView1.DataBind();
        con.Close();