大虾们帮忙看看问题出在哪。
DialogResult result = MessageBox.Show("确定要保存吗?", "请确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
ocnn = new OleDbConnection(connections);
ocnn.Open(); try
{
if (result == DialogResult.Yes)
{
for (int i = 0; i < dgv_Data.Rows.Count; i++)
{
string value1 = this.dgv_Data.Rows[i].Cells[0].Value.ToString();//已经有4条数据,好像这样写就不行了,但不知道怎么改
string value2 = this.dgv_Data.Rows[i].Cells[1].Value.ToString();
string value3 = this.dgv_Data.Rows[i].Cells[2].Value.ToString();
string value4 = this.dgv_Data.Rows[i].Cells[3].Value.ToString(); string sql = "insert into MIS_MaterielRegiser(MaterielRegiser_Number,MaterielRegiser_Name,MaterielRegiser_Model,MaterielRegiser_Unit) values('" + value1 + "','" + value2 + "','" + value3 + "','" + value4 + "')";
ocmd = new OleDbCommand(sql, ocnn);
// ocmd.ExecuteNonQuery();
DataSet ds = new DataSet();
oda = new OleDbDataAdapter(ocmd);
dgv_Data.DataSource = null;
dgv_Data.DataSource = ds.Tables[0];
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
DialogResult result = MessageBox.Show("确定要保存吗?", "请确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
ocnn = new OleDbConnection(connections);
ocnn.Open(); try
{
if (result == DialogResult.Yes)
{
for (int i = 0; i < dgv_Data.Rows.Count; i++)
{
string value1 = this.dgv_Data.Rows[i].Cells[0].Value.ToString();//已经有4条数据,好像这样写就不行了,但不知道怎么改
string value2 = this.dgv_Data.Rows[i].Cells[1].Value.ToString();
string value3 = this.dgv_Data.Rows[i].Cells[2].Value.ToString();
string value4 = this.dgv_Data.Rows[i].Cells[3].Value.ToString(); string sql = "insert into MIS_MaterielRegiser(MaterielRegiser_Number,MaterielRegiser_Name,MaterielRegiser_Model,MaterielRegiser_Unit) values('" + value1 + "','" + value2 + "','" + value3 + "','" + value4 + "')";
ocmd = new OleDbCommand(sql, ocnn);
// ocmd.ExecuteNonQuery();
DataSet ds = new DataSet();
oda = new OleDbDataAdapter(ocmd);
dgv_Data.DataSource = null;
dgv_Data.DataSource = ds.Tables[0];
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
解决方案 »
- 怎么把自定义空间放到panel中
- 求助求助!谁能帮我做出这道题?
- 关于WPF中读取和修改配置文件的问题
- 新手问一个asp和c#程序的通信问题
- 超级难问题,我费了很大劲画好的,DATAGRID的这个问题有人做过吗!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 001写入csv文件,变成了1,如果在前面加"'"也无效。
- [请关注]请问在Console程序中如何实现输入的密码是掩码形式?
- c# Chart 动态曲线更新
- C#WinForm DatagridView嵌套一个DatagridView控件
- 简单问题,怎么在一个web页面中点击事件中使另一个web页面show。
- 求助各位高手sql连接问题
- 用串口控件遇到了一个几天还解决不了的问题,求各位大佬
2、string value1 = (this.dgv_Data.Rows[i].Cells[0].Value!=null)?this.dgv_Data.Rows[i].Cells[0].Value.ToString():string.Empty;
确定不为null
3、ocnn.Open();尽量放到,command执行前,并且尽快关闭
DialogResult result = MessageBox.Show("确定要保存吗?", "请确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
ocnn = new OleDbConnection(connections);
ocnn.Open(); //try
//{
if (result == DialogResult.Yes)
{
for (int i = 0; i < dgv_Data.Rows.Count; i++)
{
string number = Convert.ToString(this.dgv_Data.Rows[i].Cells[0].Value);
string name = Convert.ToString(this.dgv_Data.Rows[i].Cells[1].Value);
string model =Convert.ToString(this.dgv_Data.Rows[i].Cells[1].Value);
string unit = Convert.ToString(this.dgv_Data.Rows[i].Cells[1].Value); ocmd.CommandText = "insert into MIS_MaterielRegiser(MaterielRegiser_Number,MaterielRegiser_Name,MaterielRegiser_Model,MaterielRegiser_Unit) values('" + number + "','" + name + "','" + model + "','" + unit + "')";
OleDbDataAdapter oda = new OleDbDataAdapter(ocmd);
DataSet ds = new DataSet();
OleDbCommandBuilder ocb = new OleDbCommandBuilder(oda);
oda.Update(ds);//Update 无法找到 TableMapping['Table'] 或 DataTable“Table”。
dgv_Data.Update();
}
}