Thread: Using OleDb in C#?

Thanks for the help. I started playing around with using different commands. I'm new to sql but I've looked up some stuff. I have a table with column headers A,B,C, and D. I can insert items into the table by doing:

Code:

insert into table1 values (1,2,3,4)

but I think I should be able to do that by doing:

Code:

insert into table1 (A,B,C,D) values (1,2,3,4)

but I can't. I also can't add in things that aren't numbers so this doesn't work either

Code:

insert into table1 values ("hi",2,3,4)

or

Code:

insert into table1 values (hi,2,3,4)

Is C# limited in the sql statements it can execute?