GridView菜鸟级使用总结

简单级别

web.config
</configSections>
  <appSettings>
    <add key ="connect" value ="server=.;database=FCMIS;uid=sa;pwd=111"/>
  </appSettings >
<connectionStrings/>


调用web.config
       //string str = "server=.;database=FCMIS;uid=sa;pwd=111";
        string str = ConfigurationSettings.AppSettings["connect"];
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(str );
            conn.Open();

            SqlCommand comm = new SqlCommand("table_ab",conn);
            comm.CommandType = CommandType.StoredProcedure;

            SqlDataAdapter sda = new SqlDataAdapter();
            sda.SelectCommand = comm;
            DataSet ds = new DataSet();
            //DataTable dt = new DataTable();
            sda.Fill(ds);

            this.GridView1.DataSource =ds;
            this.GridView1.DataBind();