int intRowNumber = this.datagrid1.CurrentCell.RowNumber; myDataSet.Tables[0].Rows[intRowNumber].Delete();//这句话已经成功修改了DataSet数据集 SqlConnection conn = LinkDataBase.createconnection(); SqlDataAdapter da = new SqlDataAdapter("select * from 商品清单",conn); SqlCommandBuilder sqlCmdBld = new SqlCommandBuilder(da); da.Update(myDataSet,"商品清单");//执行到该句就出错
yourDataTable.Columns[yourFieldName].ColumnMapping = MappingType.Hidden;如果是删除选中的一行,可以如下
BindingManagerBase bm = yourGrid.BindingContext[yourGrid.DataSource];
DataRowView drv = bm.Current as DataRowView;
if( drv != null )
drv.Row.Delete();
myDataSet.Tables[0].Rows[intRowNumber].Delete();//这句话已经成功修改了DataSet数据集
SqlConnection conn = LinkDataBase.createconnection();
SqlDataAdapter da = new SqlDataAdapter("select * from 商品清单",conn);
SqlCommandBuilder sqlCmdBld = new SqlCommandBuilder(da);
da.Update(myDataSet,"商品清单");//执行到该句就出错