#command builder

Syntax Error INSERT INTO Statement – ADO.Net Solved

This is a common error occurred during the database operation in ADO.Net. The cause for this error is the column name matches some reserved words. To solve this issue suffix and prefix with “] and [” in column names. Command object If you are using command object use the following method in the insert statement. OleDbCommand cmd = new OleDbCommand(“insert into acgroup(gname,parent,[note])…

When I talk about C# Dataset quote that it can also be used for insertion of data into the table too. In this post, we are going to learn how to. Prerequisites Data connection with SQL Dataset Command builder object In our example, we had MiniPurchaseInfo table and dataset associated with it.  First thing first, the dataset SqlDataAdapter MiniPurchaseInfo = new SqlDataAdapter(“select * from…

Delete a rows using command builder and dataset in C#

The following example simply illustrate how you can delete rows using dataset and command builder in C#. As a C# programmer you may know how important a dataset is.

Here in our example, we first create a database adapter pointing to some table rows and then build a dataset which is the local representation of database table.

Common.StockPurchase_Part = new SqlDataAdapter("select * from…