i wanna store some string or test file which might be generated by user at run time.
i need to store it into mysql database.
at present, i can store fixed data something like ( if i put column value as 'test' , then i pass it to DB. mysql can get 'test' as column value. But when i pass variable value (not string) , mysql always get 'NULL' as that column value.

anyway, thanks for your reply. hope to get further help from you fri :)

How do you pass the variable value? What does your statement looks like in your code? There is probably an error in your coding so that your variable values do not get into the actual query.
If your mysql server runs a log, you can see in the log file how your query actually gets to the server.

How do you pass the variable value? What does your statement looks like in your code? There is probably an error in your coding so that your variable values do not get into the actual query.
If your mysql server runs a log, you can see in the log file how your query actually gets to the server.

here's my code fri,
i use MySQL Command Line Client.
when i use fixed data , it worked fine.

I don't know C#. But I cannot see how "keyvalue" could have a value other than NULL. Nowwhere it gets assigned.
And how do your test the success of your insert query? Maybe you have a problem with the table definition. Would it accept NULL for FileID or for Value?