且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在 C# 中使用 Datagrid 更新数据库

更新时间:2023-02-25 20:53:54

Well Abeer.确实有很多方法可以处理数据,而且在很多时候,开发人员倾向于以一种或另一种方式工作.从您的问题中,我可以看到使用 ADO.NET 可能是新手,因此我建议您阅读有关在 .NET 中使用数据的一些内容(DataTables、DataSets、DataGrids、DataAdapters、Data Binding 等)

Well Abeer. there are really many ways to work with data and in a lot of times it is a developer preference to work one way or another. From your question, I can see that might be new to working with ADO.NET so I would suggest you do some reading on working with data in .NET (DataTables, DataSets, DataGrids, DataAdapters, Data Binding, ... etc)

我认为(根据我的短暂经验)从数据源读取数据和向数据源写入数据的最简单方法是使用 DataAdapter 将数据读入数据集,然后将数据集设置为 gridview 的数据源,其中用户可编辑.要写回更改,只需使用适配器中的更新方法.这是一个示例代码

I think (from my short experience) the simplest way to read and write data from and to data source is to use a DataAdapter to read the data into a dataset and then set the dataset as the datasource for a gridview where a user can edit. to write back the changes, just use the update method in the adapter. here is a sample code

DataSet ds;
OleDbDataAdapter dataAdapter;
void ReadData()
    {
        this.ds = new DataSet();
        string connString = "CONNICTION STRING GOES HERE";
        this.dataAdapter = new OleDbDataAdapter("QUERY GOES HERE", connString);
        this.dataAdapter.Fill(this.ds, "TABLE1");
        this.ds.AcceptChanges();
        //set the table as the datasource for the grid in order to show that data in the grid
        this.dataGridView1.DataSource = ds.DefaultViewManager;
    }

    void SaveData()
    {
        DataSet changes = this.ds.GetChanges();
        if (changes != null)
        {
            //Data has changes. 
            //use update method in the adapter. it should update your datasource
            int updatedRows = this.dataAdapter.Update(changes);
            this.ds.AcceptChanges();
        }
    }

请参阅以下内容,因为它提供了有关使用 DataGrid 控件的更长示例

see the following as it gives a longer sample about using DataGrid control

http://www.codeproject.com/Articles/9986/使用数据网格控件

有关 DataTable、DataSet 和 DataGrids 的一些介绍,请参阅

and for some intro on DataTable, DataSets and DataGrids see

http://www.codeproject.com/Articles/6179/A-Practical-Guide-to-NET-DataTables-DataSets-and-D