adapter.Update(dataset.Tables [0])Dn在数据库oracle中不更新

我正在ODP.net中以断开连接模式工作,我从表中选择了一些数据,并将其显示在dataGridview中,如下所示:

private void searchBtn_Click(object sender,EventArgs e)
            {
                Queue<string> parametersList = new Queue<string>();
                string cmd = @"select paper.paper_id,paper_title,paper_content,category_name,author.author_id,author_fname,reviewer_fname,reviewer_sname,rev_state 
                                                              from paper
                                                              INNER JOIN  review ON paper.paper_id = review.paper_id
                                                              INNER JOIN  reviewer ON  review.reviewer_id = reviewer.reviewer_id
                                                              INNER JOIN  research_categoryfield ON paper.research_id = research_categoryfield.category_id
                                                              INNER JOIN  author ON author.author_id = paper.author_id
                                                              WHERE paper.paper_title = :t
                                                              ";

                parametersList.Enqueue("t");
                parametersList.Enqueue(searchTxt.Text);
                set = con.DisconnectedExcuteQuery(cmd,parametersList);

                GridView1.AutoGenerateColumns = true;
                GridView1.DataSource = set.Tables[0];

            }

现在,我想将值更新为列,但是我编写了以下代码: '''

internal void Update(DataSet dataSet)
        {
            builder = new OracleCommandBuilder(adapter);
            dataSet.acceptChanges();
            adapter.Update(dataSet.Tables[0]);
        }

但是它仅更新dataGridView而不更新数据库

ooxiaoping 回答:adapter.Update(dataset.Tables [0])Dn在数据库oracle中不更新

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/2449609.html

大家都在问