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); 
}