使用数据集和dataAdapter编辑数据库中的数据 [英] Editing data in the database using dataset and dataAdapter

问题描述

我想使用dataset和dataadapter更新数据.用于将数据编辑到数据库中的代码如下..但是它不起作用.

I want to update data using dataset and dataadapter.. code for editing data to the database is as follows.. but it is not working.

try
            {
                MAconn = new OleDbConnection();
                MAconn.ConnectionString = connectionString;
                MAconn.Open();
                DataSet oDS = new DataSet();
                string query = "SELECT * FROM info";
 
                OleDbDataAdapter oOrdersDataAdapter = new OleDbDataAdapter(query, connectionString);
 
                OleDbCommandBuilder oOrdersCmdBuilder = new OleDbCommandBuilder(oOrdersDataAdapter);
 
                oOrdersDataAdapter.Fill(oDS);
 
                DataTable pTable = oDS.Tables["Table"];
                pTable.TableName = "info";
 
                // edit data ( main code goes from here)
                
                DataRow oOrderRow = oDS.Tables["info"].Rows.Find("textbox1.Text"); 
                oOrderRow["cell"]= "txtcell.Text";
                
               
                oOrdersDataAdapter.Update(oDS, "info");
                MessageBox.Show("deleted");
            }
            catch (Exception ex)
            { MessageBox.Show("some prob" + ex); }

[edit]已添加代码块-OriginalGriff [/edit]

[edit]Code block added - OriginalGriff[/edit]

推荐答案

使用dataadapter中的命令对象.我想你做得相反

use command object in dataadapter. i think you had done opposite

这篇关于使用数据集和dataAdapter编辑数据库中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！