DataSet data = db.Query(sql);//获取数据库里的表格数据
DataTable datat1 = new DataTable();//新建一个dateTable
DataColumn dc1 = null;
dc1 = datat1.Columns.Add("ID", Type.GetType("System.Int32"));
dc1.AutoIncrement = true;//自动增加
dc1.AutoIncrementSeed = 1;//起始为1
dc1.AutoIncrementStep = 1;//步长为1
dc1.AllowDBNull = false;//
datat1.Merge(data.Tables[0]);//将新建的表格跟已有的表格合并
dataGridView2.DataSource = datat1;//添加到dataGridView里面