我正在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而不更新数据库