you have a driver problem but i dont know how you can cope wit that
2008/12/22 nag <[email protected]>
>
> hi
> i trying to upload file to mysql db with one text field.when i click
> on upload button i',m getting following error
> ERROR [HYT00] [MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-community-nt]
> Column 'Title' cannot be null
> its working fine in local ms sql.
>
> please let me knw wer i'm wrong
> here is my code
>
> using System.Data.Odbc;
> partial class _Default : System.Web.UI.Page
> {
> protected void Upload_Click(object sender, System.EventArgs e)
> {
> FileUpload fileUpload1 = (FileUpload)this.FindControl
> ("fileUpload1");
>
> if (fileUpload1.PostedFile == null || string.IsNullOrEmpty
> (fileUpload1.PostedFile.FileName) ||
> fileUpload1.PostedFile.InputStream == null)
> {
> Label1.Text = "Please Upload Valid picture file";
> return;
> }
>
> string extension = System.IO.Path.GetExtension
> (fileUpload1.PostedFile.FileName).ToLower();
>
> string titl = TextBox1.Text.Trim();
>
> string MIMEType = null;
> switch (extension)
> {
> case ".gif":
> MIMEType = "image/gif"; break;
> case ".doc":
> case ".rtf":
> MIMEType = "application/msword"; break;
> case ".zip":
> MIMEType = "x-zip-compressed"; break;
> case ".jpg":
> case ".jpeg":
> case ".jpe":
> MIMEType = "image/jpeg"; break;
> case ".png":
> MIMEType = "image/png"; break;
> default:
>
> Label1.Text = "Not a Valid file format";
> return;
>
> }
> 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.Add("@Title", OdbcType.VarChar).Value
> = TextBox1.Text.Trim();
> myCommand.Parameters.AddWithValue("@MIMEType",
> OdbcType.VarChar).Value = 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();
>
>
> }
> }
>
