//读取数据库连接字符串 string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]); //创建数据库连接对象 SqlConnection myconn = new SqlConnection(settings); myconn.Open(); string strsql = "select * from table"; DataSet ds = new DataSet(); SqlDataAdapter MyAdapter = new SqlDataAdapter(strsql, myconn); MyAdapter.Fill(ds, "list"); dataGrid1.DataSource = ds.Tables["list"].DefaultView; dataGrid1.DataBind(); myconn.Close();