一个数据连接例子c#

 private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
           SqlConnection db =new  SqlConnection("server=(local);uid=sa;pwd=;database=mycount");
        SqlDataAdapter dp =new SqlDataAdapter("select * from subject", db);
       DataSet ds=new DataSet();
        dp.Fill(ds, "table0");

        DataGrid1.DataSource = ds;
        DataGrid1.DataBind();

  }