just make a "save" with image or picture...

Question

Hi!

I am in need to save a picture or image into my database from a picturebox. My code work nice but how can I include some line of codes to save a picture? Thanx very much

conn.Open();

OleDbCommand comm = new OleDbCommand();

comm.Connection = conn;

connstr = "SELECT COUNT(*) FROM company WHERE [name] = @name";

comm.CommandText = connstr;

comm.Parameters.Clear();

comm.Parameters.AddWithValue("@name", txtName.Text);

int numRecords = (int)comm.ExecuteScalar();

if (numRecords == 0)

{

connstr = "INSERT INTO company([name],[surname],[number],[file_scaned)VALUES(@name,@surname,@number,@file_scaned)";

comm.CommandText = connstr;

comm.Parameters.Clear();

comm.Parameters.AddWithValue("@name", txtName.Text);

comm.Parameters.AddWithValue("@surname", txtSurname.Text);

comm.Parameters.AddWithValue("@number", txtNumber.Text);

comm.Parameters.AddWithValue("@file_scaned", picturBox2.Image); //I do this and it doenst result nothing

//

if (MessageBox.Show("Are you sure to save?", "Janela de gravação", MessageBoxButtons.YesNo) == DialogResult.Yes)

comm.ExecuteNonQuery();

}

else

{

MessageBox.Show("This name already exist", txtName.Text);

}

conn.Close();

Rajeev Punhani · Answer

Hi Israel Please declare the variable before using it. conn.Open(); OleDbCommandcomm= new OleDbCommand(); comm.Connection=conn; connstr= SELECTCOUNT(*)FROMcompanyWHERE[name]=@name ; comm.CommandText=connstr; comm.Parameters.Clear(); comm.Parameters.AddWithValue( @name txtName.Text); int numRecords=( int )comm.ExecuteScalar(); if (numRecords==0) { MemoryStreamms1= new MemoryStream(); pictureBox2.Image.Save(ms1System.Drawing.Imaging.ImageFormat.Jpeg); byte []img_arr1= new byte [ms1.Length]; ms1.Read(img_arr10img_arr1.Length); connstr= INSERTINTOcompany([name][surname][number][file_scaned)VALUES(@name@surname@number@file_scaned) ; comm.CommandText=connstr; comm.Parameters.Clear(); comm.Parameters.AddWithValue( @name txtName.Text); comm.Parameters.AddWithValue( @surname txtSurname.Text); comm.Parameters.AddWithValue( @number txtNumber.Text); comm.Parameters.AddWithValue( @file_scaned img_arr1); //Thereisabugg.Itscannotrunproperly if (MessageBox.Show( Areyousuretosave?  Janeladegravação MessageBoxButtons.YesNo)==DialogResult.Yes) comm.ExecuteNonQuery(); } else { MessageBox.Show( Thisnamealreadyexist txtName.Text); } conn.Close(); If the above solution is helpful then accept the answer.

Israel · Answer

@ Rajeev Punhani Look what I do There is bugg here: img_arr1 conn.Open(); OleDbCommand comm = new OleDbCommand(); comm.Connection = conn; connstr = SELECT COUNT(*) FROM company WHERE [name] = @name; comm.CommandText = connstr; comm.Parameters.Clear(); comm.Parameters.AddWithValue(@name txtName.Text); int numRecords = (int)comm.ExecuteScalar(); if (numRecords == 0) { connstr = INSERT INTO company([name][surname][number][file_scaned)VALUES(@name@surname@number@file_scaned); comm.CommandText = connstr; comm.Parameters.Clear(); comm.Parameters.AddWithValue(@name txtName.Text); comm.Parameters.AddWithValue(@surname txtSurname.Text); comm.Parameters.AddWithValue(@number txtNumber.Text); comm.Parameters.AddWithValue(@file_scaned img_arr1 ); //There is a bugg. Its cannot run properly MemoryStream ms1 = new MemoryStream (); pictureBox2.Image.Save(ms1 System.Drawing.Imaging. ImageFormat .Jpeg); byte [] img_arr1 = new byte [ms1.Length]; ms1.Read(img_arr1 0 img_arr1.Length); if (MessageBox.Show(Are you sure to save? Janela de gravação MessageBoxButtons.YesNo) == DialogResult.Yes) comm.ExecuteNonQuery(); } else { MessageBox.Show(This name already exist txtName.Text); } conn.Close();

Rajeev Punhani · Answer

Hi Israel Please add the following lines of code to achieve same. MemoryStreamms1= new MemoryStream(); pictureBox2.Image.Save(ms1System.Drawing.Imaging.ImageFormat.Jpeg); byte []img_arr1= new byte [ms1.Length]; ms1.Read(img_arr10img_arr1.Length); and pass img_arr1 to comm.Parameters.AddWithValue( @file_scaned  img_arr1 ); If the above solution is helpful then accept the answer.