用 datagridview 控件怎么把写入的数据保存到数据库中去?
解决方案 »
- C#实现mpeg2(mpeg2编码的视频后缀是什么)关键帧(I帧)的提取
- 引用WSDL文件生成类型的问题
- 当DataSet存入Session之后引发的问题!
- 本地的程序,连接数据库字符串写在本地程序中,可以访问网络上的sql数据库吗?有人说只限于局域网,是吗?
- 请问如何知道点击的是哪一个控件?
- 如何加總Datagridview中某個字段的值到主表的TextBox中?
- **有没有高手了!请进!!!急!!!
- ~~~~如何在WinForm 中按ID定位DataGrid 行
- 急!有人在C#中利用SharpZipLib进行文件的压缩的吗?
- 那位大侠可以帮忙用C#实现对PictureBox中的Image进行框选操作,多些代码提供!!
- radioButton 取值
- DataGridView 多种排序: 字符串排序和数字排序
private void SubmitChanges()
{
if (dsOneToMany.HasChanges())
{
conn.Open();
SqlTransaction txn = conn.BeginTransaction();
adpOrders.UpdateCommand.Transaction = txn;
adpOrders.InsertCommand.Transaction = txn;
adpOrders.DeleteCommand.Transaction = txn;
adpDetails.UpdateCommand.Transaction = txn;
adpDetails.InsertCommand.Transaction = txn;
adpDetails.DeleteCommand.Transaction = txn;
try
{
int intOrdersModified, intDetailsModified;
intOrdersModified = adpOrders.Update(dsOneToMany.Orders.Select("", "", DataViewRowState.Added | DataViewRowState.ModifiedCurrent));
intDetailsModified = adpDetails.Update(dsOneToMany.Order_Details); intOrdersModified += adpOrders.Update(dsOneToMany.Orders.Select("", "", DataViewRowState.Deleted)); txn.Commit();
MoveFirst(); string strOutput = "已修改 " + intOrdersModified + " 条订单信息\r\n" +
"已修改 " + intDetailsModified + " 条订单明细信息";
MessageBox.Show(strOutput, "更新成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "更新失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
txn.Rollback();
}
finally
{
conn.Close();
}
}
}
是这样的!
{
DataTable newdt = new DataTable();
try
{
DataTable dt2 = (DataTable)dgList.DataSource;
int colCount = dgList.Columns.GetColumnCount(DataGridViewElementStates.Visible);
string[] ColumnNames = new string[colCount];
int j = 0;
for (int i = 0; i < dgList.Columns.Count; i++)
{
if (dgList.Columns[i].Visible)
{
ColumnNames[j] = dgList.Columns[i].Name.ToString();
j++;
}
}
foreach (string ColumnName in ColumnNames)
{
newdt.Columns.Add(ColumnName);
} for (int i = 0; i < dt2.Rows.Count; i++)
{
DataRow drNew = newdt.NewRow();
foreach (string ColumnName in ColumnNames)
{
drNew[ColumnName] = dt2.Rows[i][ColumnName];
}
newdt.Rows.Add(drNew);
newdt.AcceptChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return newdt;
} DataTable dt = this.DataGridToDataTable(dgList);
SqlDataAdapter + SqlCommandBuilder ..调用SqlDataAdapter.Update(DataTable);
在 DATAGRIDVIEW 中写入数据后,点BUTTON 保存数据.
怎么写BUTTON CLICK 事件??