MYSQL Command Parameter

[jackpotsvr]

Hey Epvps!

 Spoiler

I was programming in C# and I had some byte arrays I wanted to be stored in a SQL Server, so it should be in as an BLOB,- ( Binary Large Object). So I coded this, but it seems not to work. I've been working hours on it trying to make it work but it keeps posting the Parameter name in my database instead doing the actually parameter job.

I just coded an try catch and the other basic mysql database connect thigns.

PHP Code:


                    MySqlCommand Jackcm = Jackconn.CreateCommand();
                    MySqlParameter Jackpar = new MySqlParameter("@JackArray", SqlDbType.Binary);
                    Jackpar.Value = JackArray;                    
                    Jackcm.CommandText = "Insert into jacktable(Data) values('@JackArray')";
                    Jackcm.Parameters.Add(Jackpar);
                    Jackconn.Open();
                    Jackcm.ExecuteNonQuery();
                    Jackconn.Close(); 


So the problem I am experiencing is that in my database it keeps saying @JackArray instead of that the parameter changes that into the byte array.
Am I using a wrong token for the parameter? I either tried some others like $ and more. I hope you can help me.


I used MYSQL and C#, NOT the windows sql thats inside VC.

**UPDATE

I've fixed the problem with the parameters yet, but still its not working like in the tutorials I watched (those weren't for mysql but I converted the sql parts to mysql with the correct prefix. I either succeeded to put strings into my database using the parameters. But now there is an error I keep hanging on. (It's not an building error, it comes when I try to inject the byte array.

Unable to cast object of type 'System.Byte[]' to type 'System.IConvertible'.

Any Idea?
Tell me if I need to put the code down here.

[pro4never]

Excuse me as I'm not very experienced with sql in general... but you have it inside a quote so it's going to be treated as a literal string unless it's a special character (like \). take it out of the quotes and it may work but the more likely outcome is it will use the objects name (similar as if you tried to do Console.WriteLine(JackArray)

That being, said, give it a try and prove me wrong.


Jackcm.CommandText = "Insert into jacktable(Data) values('"+JackArray+"')";

[jackpotsvr]

Originally Posted by pro4never

Excuse me as I'm not very experienced with sql in general... but you have it inside a quote so it's going to be treated as a literal string unless it's a special character (like \). take it out of the quotes and it may work but the more likely outcome is it will use the objects name (similar as if you tried to do Console.WriteLine(JackArray)

That being, said, give it a try and prove me wrong.


Jackcm.CommandText = "Insert into jacktable(Data) values('"+JackArray+"')";

I did try that either but doesn't seems to work. I debugged and the byte array is fine. Either the SQL connection is. It do insert data into the database but just doesn't seems to 'listen' to the parameter which should say "Hey, you must be replaced with the byte array (named JackArray)"

Should figure how to make the parameter work, or what else I do wrong !
I hope some one can help me , guess I won't find it myself as I've been looking to this little piece of code for hours now :P

Either still im looking for someone who can comfirm that the parameter token is right :P

[.Kinshi]

I ran into this problem as well.
The default prefix for variable names it seems is ? not @.
Try ?JackArray, it's what fixed it for me.

[jackpotsvr]

Originally Posted by .Kinshi

I ran into this problem as well.
The default prefix for variable names it seems is ? not @.
Try ?JackArray, it's what fixed it for me.

When I was seraching on the web I either found someone who was using ? for the parameters. When I change it It still won't work. I guess it's very important to put the parameterer before or after the command itself but I can't find the good combination.

Either I don't know if I should do "?x" aswell in the parameter or just in the command and just parameter "x" if you get what I mean.

Maybe you still have the code you used? (I can understand if you're not willing to leave it here but I guess it can help me much.
Thanks in advance, Jackpotsvr

EDIT --!
Came a step closer, the SQL part works now.
Just come with the error Unable to cast object of type 'system.byte[]' to type 'system.Iconvertible'

[jackpotsvr]

Re-used this old thread for a new problem in the project-