Re: Unabl to insert byte into database

[latha mad]

latha mad Wrote:
-------------------------------------------------------
> Hello everyone,
>
> I have problem inserting byte in to dtaabse. When
> byte array is inserted into database it gives an
> error saying that the syntax is wrong. but i
> followed the same syntax specified in mysql
> manual. What could be the problem? This is the
> code i use.
>
> FileStream mystream1 =
> File.Open("image.xml",FileMode.Open);
>
> int filesize = (int)mystream1.Length;
> byte[] rawdata=new byte;
> mystream1.Read(rawdata, 0, filesize);
> try
> {
>
> Connectionclass.OdbcCom = new
> System.Data.Odbc.OdbcCommand();
> Connectionclass.OdbcCom.Connection
> = Connectionclass.OdbcCon;
>
> Connectionclass.OdbcCom.CommandText="insert into
> Pattern_desc (byte_stream,file_size,Length,Width)
> values("+rawdata+","+filesize+",10, 20)";
> }
> catch (exception e)
> {
> }
>
> Can someone please help me?
>
> Thank you,
> Latha


----------------------------------
And the database i created is
Create table Pattern_desc(byte_stream blob, filesize INT,Length INT, Width INT);

--------------------------------------