通过datagridview编辑数据库中的条目按钮单击C＃ [英] Editing entries in database through datagridview on button click C#

问题描述

在搜索stackoverflow几个小时之后，我能够找到一个很好的答案来解决我遇到的问题。通过datagridview更新访问数据库中的现有条目。使用我在那里学到的东西，我能够成功地提交数据库更新。但是我发现了问题。我只能为每个应用程序会话进行一次更新。我成功完成一个后，所有后续更新都不保存到数据库。我希望网站上的某个人可以查看我的代码并帮助确定我的问题所在。我已经看了几天无济于事。



//编辑代码

After searching stackoverflow for hours I was able to find a great answer to an issue I was having. Updating existing entries in an access database through the datagridview. Using what I learned there I was able to commit an update to database successfully. However I have found issue. I can only make one update per application session. After I make one successfully, all subsequent updates to not save to database. I am hoping someone on the site can take a look at my code and help pin point where my issue is. I have looked at it for a couple days to no avail.

//Code for editing

private void AssetForm_Load(object sender, EventArgs e)
        {
            //ACCESSORIES DATA GRID VIEW
            this.accessoriesTableAdapter.Fill(this.fAMDatabaseDataSet.Accessories);
            con.Open();
            string accCommandText = "SELECT * from Accessories";
            accAdapter = new OleDbDataAdapter(accCommandText, con);
            OleDbCommandBuilder accCB = new OleDbCommandBuilder(accAdapter);
            accView.AutoGenerateColumns = true;
            accDT = new System.Data.DataTable();
            accAdapter.Fill(accDT);
            BindingSource accBS = new BindingSource();
            accBS.DataSource = accDT;
            accView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
            accView.DataSource = accBS;
            con.Close();
        }

//提交回数据库的按钮

//Button that commits back to database

private void accEditButton_Click(object sender, EventArgs e)
        {
            accAdapter.Update(accDT);
            accView.Refresh();
            MessageBox.Show("Asset Updated Successfully.");
        }

推荐答案

请参阅此示例，这将对您有所帮助。



使用DataGrid控件 [ ^ ]

Please see this Example, This will help you.

Using the DataGrid Control[^]

这篇关于通过datagridview编辑数据库中的条目按钮单击C＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！