#oledbcommand

Update Oledb Access columns at run time in C#/.Net

How to add fields to a access table in C# at run time ? This tutorial will share what you need to learn.

.Net Coder

First I have to say that , in this example used the Oledb adapter and connection which is not included in this code. You can check my previous posts on oledb connections(connection and Adapter).

I am going to put a checking section before adding column, others wise C# will…

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])…