DataSet ds = new DataSet(); ds.Table[0] = this.dataGridView1.DataScorus as DataTable; //将datagridview的表写入内存表SqlDataAdapter da = new SqlDataAdapter(sql,connection); //用于传输数据SqlCommandBuilder buder = new SqlCommandBuilder (da); //用于生成SQL语句 da.Update(ds); 更新dataset中的数据
ds.Table[0] = this.dataGridView1.DataScorus as DataTable; //将datagridview的表写入内存表SqlDataAdapter da = new SqlDataAdapter(sql,connection); //用于传输数据SqlCommandBuilder buder = new SqlCommandBuilder (da); //用于生成SQL语句
da.Update(ds); 更新dataset中的数据