thank you for your help ariel and peter. by the way i will ask another question :). i'm trying to insert a value in my table that is defined as type "number"in my database.
the next query works:
string myInsertQuery = "INSERT INTO PROYECTO (Column1) VALUES (22)";
but if a define a variable, assigne it this value and try to do the insert, it generate an error of the type: column not allowed here.
this is what i'm trying to do:
int mydata = 22;
string myInsertQuery = "INSERT INTO PROYECTO (Column1) VALUES (mydata)";
i need to use variable values, so i can't write directly a number. do you know how this sentence doesn't work?
thank you very much. i haven't ever work with databases, and i'm really lost