数据适配器

private void dgvBind(string _myDate1,string _myDate2)
{
SqlConnection mycon = GetConnection();
try
{
mycon.Open();
string str = "SELECT reservation_id,code,name from[hf_zw].[dbo].[t_reservation] left join [hf_zw].[dbo].[t_pub_staff] on[hf_zw].[dbo].[t_reservation].identity_id=[hf_zw].[dbo].[t_pub_staff].is_code WHERE [reservation_time]>=‘" + _myDate1 + "‘ and [reservation_time]<=‘" + _myDate2 + "‘";

SqlDataAdapter sda = new SqlDataAdapter(str,mycon);//主键不可缺,不然跟新dataGridView1_CellValueChanged会出错.
DataTable table = new DataTable();
sda.Fill(table);
this.dataGridView1.AutoGenerateColumns = true;
this.dataGridView1.DataSource = table;
this.dataGridView1.EditMode = DataGridViewEditMode.EditOnEnter;
dataGridView1.Columns["query_window"].ReadOnly = true;//主键不可编辑
dataGridView1.Columns["reservation_id"].ReadOnly = true;

} catch (Exception ex) { MessageBox.Show(ex.Message); } finally { mycon.Close(); } }