i'm trying to use c# with mysql
 

what if I want to insert things in a mysql table using data from a c# array?
it's a lot easier if i am just trying to hardcode values into the table, for example,
would work fine...
but the line below would not quite work...
please let me know if my question doesnt make sense...
any suggestions, please?

command.CommandText = "insert into profilet (id, firstn, lastn) values (array[0], array[2], array[3])";

you need to use quotations, that will just insert the words array[0] etc..

command.CommandText = "insert profilet (id, firstn, lastn) values ("array[0]", "array[2]", "array[3])"";

Samuraijack's will insert those words as you say however your command string should not compile at all!

"INSER INTO profilet (id, firstn, lastn) VALUES (" + array[0] + "," + array[1] + "," + array[2] + ")";

The above command string should do what you want it to programmingnoob, considering you have an initialised array of objects named 'array' and those numbers are valid index identifiers.

but thats not what I want to do....
I want to insert the value of array[0] and so on...

for example, if array[0] = 11, array[2] = 15...
I would want 11 and 15 inserted into the table... not the words array[0] etc

as john Wesley said :

I just added the ' .. i remember it's necessary for inserting strings.

On the other hand, take a look at MySqlParameter.(aka google_it)

I suggest using parameterized queries instead of simple concatenation to aviod sql injection attacks.

precisely, yours would have inserted the words 'array[0]' etc..

look at the pairs of quotations more carefully and you will understand..

Thanks john wesley for completing my code, i knew it was close, not done it for a while lol..

umm elaborate please?!
I'm new to this stuff you see
if you could point me to a weblink, then that would be great too

I don't know how it's done in C# with whatever MySQL API you're using, but this is the same thing in python:


the point is that the SQL library takes care of putting the values into the query with correct quoting as to avoid danger if someone sets array[2] to something like Butcher"); update profilet set ( firstn = "idiot (you get the general idea)