C dataadapter update not updating database
The Ole Db Data Adapter uses the Connection object of the .
The properties of the Ole Db Data Adapter object update the Data Source with the data modifications that are run on a Data Set object.
Thus i have my datagridview as student Id , student Name , Update student Id is the primary key and auto increments. But for Update the changes were not reflected in the tables, although the value in the dataset was changing.
NET Framework data provider to connect to a data source and Command objects to retrieve data from and resolve changes to the data source.
This post has been edited by poptcat: 05 August 2011 - PM I'm still confuse with this code since you don't have create the "Delete" table in your database. Pls tell me how your Windows Form look like using this code? Hi, Nice explanation and easy enough to understand.Details: Topic: Insert, Update & Delete Table from Data Grid View Language: C#.Net 2.0 Level: Intermediate Today I will show you how to Insert, Update & Delete table with Data Grid View in C#. Create a database Employees DB and create a table Employees CREATE TABLE Employees ( Employee ID numeric(9) IDENTITY (1, 1) PRIMARY KEY NOT NULL , Last Name nvarchar(20)NOT NULL , First Name nvarchar(10) NOT NULL , Title nvarchar(30) NULL , Hire Date datetime NULL , Postal Code nvarchar(10) NULL ) GO Sql Connection sql Con = new Sql Connection("Server=(local); Database=Employee DB; Integrated Security=TRUE"); Sql Command Builder sql Command = null; Sql Data Adapter sql Adapter = null; Data Set dataset = null; Now you can see the value of Delete column is Insert after clicking insert it will update the table and change column value to Delete] And here is our delete and update code In this we used to check if index of clicked cell is 6 or is it Delete column, if yes then it will check for the value Insert & Delete if it is Insert then new row will be add to dataset & DGV and update the table if it is Delete then delete command will excute after a confirmation. I made a 3 steps tutorial - c# with oracle this time. Data Grid View programatically binded to Oracle data source Updating Oracle table through Ole Db Basic Oracle C# application - insert,update,delete operations The last article shows how to refresh datasource for Datagrid View, how to retrieve primary key for a newly inserted row - things you may find hard on the net.For example, if you call Delete on a row on the Data Set, then when Update is called on the Data Adapter, the Delete Command of the Data Adapter will be called using the particular row in the Data Set.Note: Keep in mind that this Update is different than a SQL UPDATE statement.