datagridview不更新数据库 [英] datagridview not updating database
本文介绍了datagridview不更新数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
先生,我正在使用datagridview进行更新,删除和插入,但只有删除才有效。不知道为什么。对于更新和插入,我使用data_adpter.update(data_table),类似地使用它进行删除,但在此之前还有一行,从datagridview中删除所选行。 plzz帮助我..
解决方案
首先,更新不是一个单词。这只是更新。
我们需要看到你编写的代码来创建DataAdapter并为它提供SqlCommand对象来做删除,插入和更新。
Ok。
OracleConnection con = new OracleConnection(连接字符串);
Con.open();
OracleDataAdapter da = new OracleDataAdapter(select ddate,capital_amount,due,debit,daily_expenses,from remark from daily_detailcon);
DataTable dt = new DataTable();
Da.fill(dt);
DataGridview1.datasource = dt;
Con.close();
// update_insert按钮编码
OracleCommandBuilder cmb = new OracleCommandBuilder(da);
da.update(dt);
//删除按钮
OracleCommandBuilder cmb = new OracleCommandBuilder(da);
Datagridview1.rows.removeAt(datagridview1.selected Rows(0).Index);
da.update(dt );
sir i am using datagridview for updation,deletion and insertion but only deletion is working. dont know why. for updation and insertion i am using data_adpter.update(data_table) similarly using this for deletion but have one more line before this, to delete selected row from datagridview. plzz help me..
解决方案
First, "updation" isn't a word. It's just "update".
We'd need to see the code you wrote to create the DataAdapter and supply it with the SqlCommand objects to do Delete, Insert and Update.
Ok.
OracleConnection con=new OracleConnection("connection string");
Con.open();
OracleDataAdapter da=new OracleDataAdapter("select ddate,capital_amount,due,debit,daily_expenses,remarks from daily_detail"con);
DataTable dt=new DataTable();
Da.fill(dt);
DataGridview1.datasource=dt;
Con.close();
//update_insert button coding
OracleCommandBuilder cmb=new OracleCommandBuilder(da);
da.update(dt);
// delete button
OracleCommandBuilder cmb=new OracleCommandBuilder(da);
Datagridview1.rows.removeAt(datagridview1.selected Rows(0).Index);
da.update(dt);
这篇关于datagridview不更新数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文