DataGridView控件

 SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=MyBookShop;User ID=sa;pwd=123456");
 DataSet ds = new DataSet();
 SqlDataAdapter dataAdapter = new SqlDataAdapter("select * from UserRoles",conn);
 dataAdapter.Fill(ds,"student");
 dataGridView1.DataSource = ds.Tables["student"];

 

保存

  SqlCommandBuilder builder = new SqlCommandBuilder(dataAdapter);
  dataAdapter.Update(ds,"student");

 

------------------
dataAdapter.SelectCommand.CommandText=sql;