Save record Without image..in c#

Thanks resolved...

If you want to pass null value use 


cmd.parameters .AddWithValue("@Image", DBNull.Value)






Please mark if accepted as answer!

varbinary(MAX)

Hi,

        Can you tell me datatype of Image field in database?

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

on
 cmd.ExecuteNonQuery();

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 (StudentName,DOB,ContactNumber,DateOfJoin,Address,Image,FName,ParentsID,Gender,ImgPath) 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 Name,ParentsID");
 

  }
  else
  {
 
  cmd.ExecuteNonQuery();
  MessageBox.Show("Record Saved Successfully");

  con.Close();
  {


=========

Also let me know your code as well..

Thanks

Imran

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

Now same error on ...

if(PictureBox1.Image.Clone() != null)

Hi Mohammad,

Try This :

if(PictureBox1.Image.Clone() != null)
{
        Image img = (image)PictureBox1.Image.Clone();
        img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
}