近几天对DataSet的新认识

DataGridViewCellStyle style = new DataGridViewCellStyle(); //自定义一种单元格样式. 
style.BackColor = Color.LightCyan; //其实就是换种颜色. 
dataGridView1.RowHeadersVisible = false; //觉得显示在行头的那个方块不好看,去掉~ 
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //单击某个单元格,选中其所在的行,这样看数据蛮方便. 
dataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //用户不能调整列标题栏的大小. 
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; //列宽度样式,最长的数据能全部显示,这样就不会出现"....."了. 
dataGridView1.AlternatingRowsDefaultCellStyle = style; //奇数行的样式设置为先前定义的样式,让相邻行有颜色反差. 

DataSet ds = null; 
SqlDataAdapter adapter = null; 
SqlCommandBuilder sqlbuilder = null; 

//该按钮读取数据,并绑定数据 
private void button1_Click(object sender, EventArgs e) 
...{ 
ds = new DataSet(); 
SqlConnection cn = new SqlConnection("Data Source=.;User ID=sa;Password=0;Initial Catalog=BMIS"); 
SqlCommand cm = new SqlCommand(); 
adapter = new SqlDataAdapter(cm); 
sqlbuilder = new SqlCommandBuilder(adapter); 
cm.Connection = cn; 
cm.CommandType = CommandType.Text; 
cm.CommandText = "select * from [providerInfo]"; 
adapter.Fill(ds); //该方法把得到的数据放入一个DataTable中 
dataGridView1.DataSource = ds.Tables[0]; 把数据绑定到DataGridView 
} 

//向数据库返回修改的数据. 
private void button2_Click(object sender, EventArgs e) 
...{ 
adapter.Update(ds); 
}