Doing INSERT with parameterized SQL

[Eng]

I am having a problem inserting a record into the Red Brick Database Table. I just simply don't know 'HOW'? If someone out there have already done it, please help!!!

 

I have a sql String that contains paramters as follows:

"Insert into TestTable (ColA, ColB, ColC)

values (@ColA, @ColB, @ColC)"

 

What should be inserted is the users inputs for ColA, ColB, and ColC. I tried using a Data Adapter and setting the parameter with "INSERTCommand" ~ but it's not doing anything. I am probably missing a step or two....

 

Please note that Red Brick Database doesn't support Stored Procedures so I don't that option on creating a stored procedure call to do this.

[NK2000]

i never tried mySQL in connection with .net but with php

 

normally you have to use strings to insert..

 

string SqlQuery = String.Format("INSERT INTO TestTable(`{0}`,`{1}`,`{2}`) VALUES ('{3}','{4}','{5}',) ", Key1, Key2, Key3, Value1, Value2, Value3);