hi Flavio ,
i tried with code wat you suggested above.but i'm getting following
error.
ERROR [23000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-community-nt]
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'Title,'x-zip-compressed'MIMEType,'PK\n\0\0\0\0\0ÏE
‰2\0\0\0\0\0\0\0\0\0\0\0\0\' at line 1
here is my code
using (OdbcConnection myConnection = new OdbcConnection(connString))
{
//OdbcConnection myConnection = new OdbcConnection
(connString);
const string SQL = "INSERT INTO PictureTable
(Title,MIMEType,Image) VALUES (?Title,?MIMEType,?ImageData)";
OdbcCommand myCommand = new OdbcCommand(SQL,
myConnection);
myCommand.Parameters.AddWithValue("?
Title",TextBox1.Text.Trim());
myCommand.Parameters.AddWithValue("?MIMEType",
MIMEType);
byte[] imageBytes = new byte
[fileUpload1.PostedFile.InputStream.Length];
fileUpload1.PostedFile.InputStream.Read(imageBytes,
0,imageBytes.Length);
myCommand.Parameters.AddWithValue("?
ImageData",imageBytes);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
On Dec 28, 12:17 am, "Flavio Stakoviak" <[email protected]> wrote:
> hi nag,
>
> try this codes, then confirm if your column on server if mediumblob type:
>
> String connString = "Driver={MySQL ODBC 3.51
> Driver};Server=mysql9.servername.com;Database=xyz;user
> id=kv;password=kv";
> OdbcConnection myConnection = new OdbcConnection(connString);
> const string SQL = "INSERT INTO PictureTable
> (Title,MIMEType,Image) VALUES (?Title, ?MIMEType, ?ImageData)";
>
> OdbcCommand myCommand = new OdbcCommand(SQL,myConnection);
> myCommand.Parameters.AddWithValue("?Title",
> TextBox1.Text.Trim());
> myCommand.Parameters.AddWithValue("?MIMEType", MIMEType);
> byte[] imageBytes = new byte
> [fileUpload1.PostedFile.InputStream.Length];
> fileUpload1.PostedFile.InputStream.Read(imageBytes, 0,
> imageBytes.Length);
> myCommand.Parameters.AddWithValue("?ImageData",
> imageBytes);
> myConnection.Open();
> myCommand.ExecuteNonQuery();
> myConnection.Close();
>
> --
> Flavio Henrique Moura Stakoviak
> DGTAF - Secretária da Fazenda
