Save record Without image..in c#

Question

I was try to save record without image...but its stuck on and error nullreferenceexception was unhandeled... img.Save(ms System.Drawing.Imaging.ImageFormat.Jpeg); Image img = (Image)pictureBox1.Image.Clone(); Please let me know how to save record without picture... im new one... Thanks Imran

Piyush Pansuriya · Answer

Ok then put cmd.Parameters.AddWithValue(@Image None ); instead of cmd.Parameters.AddWithValue(@Image null );

Mohammad Imran · Answer

Thanks resolved...

N Vinodh · Answer

If you want to pass null value use cmd.parameters .AddWithValue(@Image DBNull.Value) Please mark if accepted as answer!

Mohammad Imran · Answer

varbinary(MAX)

Piyush Pansuriya · Answer

Hi Can you tell me datatype of Image field in database?

Mohammad Imran · Answer

Giving Error ... The parameterized query '(@StudentName nvarchar(6)@DOB datetime@ContactNumber nvarchar(' expects the parameter '@Image' which was not supplied. on cmd.ExecuteNonQuery();

Piyush Pansuriya · Answer

cmd = new SqlCommand(INSERT INTO tblstudent (StudentNameDOBContactNumberDateOfJoinAddressImageFNameParentsIDGenderImgPath) values (@StudentName@DOB@ContactNumber@DateOfJoin@Address@Image@FName@ParentsID@Gender@ImgPath) con); cmd.Parameters.AddWithValue(@StudentName txtSName.Text.Trim()); cmd.Parameters.AddWithValue(@DOB dateTimePicker1.Value.Date); cmd.Parameters.AddWithValue(@ContactNumber txtCNumber.Text); cmd.Parameters.AddWithValue(@DateOfJoin dateTimePicker2.Value.Date); cmd.Parameters.AddWithValue(@Address txtAddress.Text); MemoryStream ms = new MemoryStream(); if ( pictureBox1.Image != null) { Image img = (Image)pictureBox1.Image.Clone(); img.Save(ms System.Drawing.Imaging.ImageFormat.Jpeg); cmd.Parameters.AddWithValue(@Image ms.ToArray()); } else cmd.Parameters.AddWithValue(@Image null); cmd.Parameters.AddWithValue(@ImgPath textBox1.Text); cmd.Parameters.AddWithValue(@FName txtFName.Text); cmd.Parameters.AddWithValue(@ParentsID comboBox3.SelectedValue); cmd.Parameters.AddWithValue(@Gender comboBox1.SelectedValue);

Mohammad Imran · Answer

im not using storeprocedure..Please see below my code for saving image.... con = new SqlConnection(@Data Source=WIN-A8JN3DFCFO1;Initial Catalog=contactus;Integrated Security=True); con.Open(); cmd = new SqlCommand(INSERT INTO tblstudent (StudentNameDOBContactNumberDateOfJoinAddressImageFNameParentsIDGenderImgPath) values (@StudentName@DOB@ContactNumber@DateOfJoin@Address@Image@FName@ParentsID@Gender@ImgPath) con); cmd.Parameters.AddWithValue(@StudentName txtSName.Text.Trim()); cmd.Parameters.AddWithValue(@DOB dateTimePicker1.Value.Date); cmd.Parameters.AddWithValue(@ContactNumber txtCNumber.Text); cmd.Parameters.AddWithValue(@DateOfJoin dateTimePicker2.Value.Date); cmd.Parameters.AddWithValue(@Address txtAddress.Text); MemoryStream ms = new MemoryStream(); if (pictureBox1.Image.Clone() != null) { Image img = (Image)pictureBox1.Image.Clone(); img.Save(ms System.Drawing.Imaging.ImageFormat.Jpeg); } cmd.Parameters.AddWithValue(@Image ms.ToArray()); cmd.Parameters.AddWithValue(@ImgPath textBox1.Text); cmd.Parameters.AddWithValue(@FName txtFName.Text); cmd.Parameters.AddWithValue(@ParentsID comboBox3.SelectedValue); cmd.Parameters.AddWithValue(@Gender comboBox1.SelectedValue); if (string.IsNullOrWhiteSpace(txtSName.Text)) { MessageBox.Show(Must Enter Student Name and Father NameParentsID); } else { cmd.ExecuteNonQuery(); MessageBox.Show(Record Saved Successfully); con.Close(); { ========= Also let me know your code as well.. Thanks Imran

Piyush Pansuriya · Answer

Hi Mohammad Try This : Remove .Clone() if(PictureBox1.Image != null) { Image img = (image)PictureBox1.Image.Clone(); img.Save(ms System.Drawing.Imaging.ImageFormat.Jpeg); }

Vithal Wadje · Answer

if you have used stored procedure then set stored procedure variable to null which used to insert image

Mohammad Imran · Answer

Actually i want to save record with picture AND without picture....anyone help...

Mohammad Imran · Answer

Now same error on ... if(PictureBox1.Image.Clone() != null)

Piyush Pansuriya · Answer

Hi Mohammad Try This : if(PictureBox1.Image.Clone() != null) { Image img = (image)PictureBox1.Image.Clone(); img.Save(ms System.Drawing.Imaging.ImageFormat.Jpeg); }