UC知道C#中，如何实现利用GATAGRID实现对数据库的修改
来源：百度知道 编辑：UC知道 时间：2024/06/17 06:05:54
我创建了个按钮，用于实现在GATAGRID中显示要查询的数据，一下是代码
string member = ""; //用于存储要读取的表名
switch (comboBoxTerm.SelectedIndex)
{
case 0: member = "score1"; break;
case 1: member = "score2"; break;
case 2: member = "score3"; break;
case 3: member = "score4"; break;
case 4: member = "score5"; break;
case 5: member = "score6"; break;
case 6: member = "score7"; break;
case 7: member = "score8"; break;
}
OleDbConnection thisConnection = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0;
Data Source = C:\Users\hp\Desktop\TEMP\论文\
string member = ""; //用于存储要读取的表名
switch (comboBoxTerm.SelectedIndex)
{
case 0: member = "score1"; break;
case 1: member = "score2"; break;
case 2: member = "score3"; break;
case 3: member = "score4"; break;
case 4: member = "score5"; break;
case 5: member = "score6"; break;
case 6: member = "score7"; break;
case 7: member = "score8"; break;
}
OleDbConnection thisConnection = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0;
Data Source = C:\Users\hp\Desktop\TEMP\论文\
是DataGridView吗？可以这样，你先修改一个CELL，然后在CELLENDEDIT事件(或者CELLBEGINEDIT好像也行)中将这个CELL的ROWINDEX和COLUMNINDEX记下来，然后点击按钮的时候，根据ROWINDEX获取CELL那行的ID，然后根据COLUMNINDEX得出这个CELL是哪一列的，然后更新数据库
OleDbDataAdapter可以更新数据库，你将dataGridTea的数据放进一个table，然后；用adpter，upda（“”；“”）方法就可以更新数据了，不过我建议你用datagridview这个控件，这个更容易实现楼主你所要的功能
thisAdapter.Update(thisDataSet)
双击按钮，在事件里面写：thisAdapter.Update(thisDataSet) ；