Data not storing in SQL from C# form

Jayita Roy

/***I have a table in SQL database with (Id,Visitor_Name,Organisation_Name,Phone_No,No_Person,To_whom,Purpose,Color_Code,Day_In,Time_In,Day_Out,Time_Out,Image)

Now I want to insert values of (Id,Visitor_Name,Organisation_Name,Phone_No,No_Person,To_whom,Purpose,Color_Code,Day_In,Time_In, Image) into database.
I wrote this code in C# below, it's working fine but not storing any data to SQL database. Please help.***/

private void button_Pass_Click(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection("Data Source=JAYI-PC\\SQLEXPRESS;Initial Catalog=db-ub;Integrated Security=True");
con1.Open();

SqlCommand cmd1 = new SqlCommand("Insert into Visitors(Id,Visitor_Name,Organisation_Name,Phone_No,No_Person,To_whom,Purpose,Color_Code,Day_In,Time_In,Image) values (@id,@vname,@org,@phn,@nop,@whom,@prps,@ccd,@dI,@tI,@img)");
cmd1.Parameters.AddWithValue("@id",textBox_Id.Text);
cmd1.Parameters.AddWithValue("@vname",textBox_NameV.Text);
cmd1.Parameters.AddWithValue("@org",textBox_Org.Text);
cmd1.Parameters.AddWithValue("@phn",textBox_Phn.Text);
cmd1.Parameters.AddWithValue("@nop", numericUpDown_Person.Value.ToString());
cmd1.Parameters.AddWithValue("@whom",comboBox_TOWHOM.SelectedItem.ToString());
string prps;
if(radioButton_OFFICIAL.Checked)
{
prps = "Official";
cmd1.Parameters.AddWithValue("@prps",prps);
}
else if(radioButton_PERSONAL.Checked)
{
prps = "Personal";
cmd1.Parameters.AddWithValue("@prps",prps);
}
cmd1.Parameters.AddWithValue("@ccd",comboBox_color.SelectedItem.ToString());
cmd1.Parameters.AddWithValue("@dI",textBox_Dayin.Text);
cmd1.Parameters.AddWithValue("@tI",textBox_timeR.Text);
Image img = pictureBox_UB.Image;
byte[] arr;
ImageConverter converter = new ImageConverter();
arr = (byte[])converter.ConvertTo(img, typeof(byte[]));
cmd1.Parameters.AddWithValue("@img",img);
MessageBox.Show("Record has been inserted");
con1.Close();

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreekanth Reddy11y ago
Accepted answer
pass the con object to constructor in sql command:

Plzz correct this line with highlighted one:

SqlCommand cmd1 = new SqlCommand("Insert into Visitors(Id,Visitor_Name,Organisation_Name,Phone_No,No_Person,To_whom,Purpose,Color_Code,Day_In,Time_In,Image) values (@id,@vname,@org,@phn,@nop,@whom,@prps,@ccd,@dI,@tI,@img)",con1);

---------------------------------------------------------------------------------------------------------------------------------Plz accept the answer if helpful.
Thank you.

Sreekanth Reddy11y ago

You have to convert the image to binary format before saving.

so use this method:

public static byte[] ImageToByte2(Image img)

   byte[] byteArray = new byte[0];

   using (MemoryStream stream = new MemoryStream())

      img.Save(stream, System.Drawing.Imaging.ImageFormat.Png);

      stream.Close();

      byteArray = stream.ToArray();

     return byteArray;

For more details:

http://stackoverflow.com/questions/27310874/no-mapping-exists-from-object-type-system-drawing-bitmap-to-a-known-managed-prov

-------------------------------------------------------------------------------------------------------------

Please accept this answer if its useful.

Thank you.

Jayita Roy11y ago
Image
Sreekanth Reddy11y ago
what is the datatype of image column in your sql server?
Jayita Roy11y ago
I am getting this error "No mapping exists from object type System.Drawing.Bitmap to a known managed provider native type."
Jayita Roy11y ago
I am getting this error
"No mapping exists from object type System.Drawing.Bitmap to a known managed provider native type."
Khan Abrar Ahmed11y ago
Hi try below code

private void button_Pass_Click(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection("Data Source=JAYI-PC\\SQLEXPRESS;Initial Catalog=db-ub;Integrated Security=True");
con1.Open();

SqlCommand cmd1 = new SqlCommand("Insert into Visitors(Id,Visitor_Name,Organisation_Name,Phone_No,No_Person,To_whom,Purpose,Color_Code,Day_In,Time_In,Image) values (@id,@vname,@org,@phn,@nop,@whom,@prps,@ccd,@dI,@tI,@img)");
cmd1.CommandType = CommandType.Text;
cmd1.Connection = con1;
cmd1.Parameters.AddWithValue("@id",textBox_Id.Text);
cmd1.Parameters.AddWithValue("@vname",textBox_NameV.Text);
cmd1.Parameters.AddWithValue("@org",textBox_Org.Text);
cmd1.Parameters.AddWithValue("@phn",textBox_Phn.Text);
cmd1.Parameters.AddWithValue("@nop", numericUpDown_Person.Value.ToString());
cmd1.Parameters.AddWithValue("@whom",comboBox_TOWHOM.SelectedItem.ToString());
string prps;
if(radioButton_OFFICIAL.Checked)
{
prps = "Official";
cmd1.Parameters.AddWithValue("@prps",prps);
}
else if(radioButton_PERSONAL.Checked)
{
prps = "Personal";
cmd1.Parameters.AddWithValue("@prps",prps);
}
cmd1.Parameters.AddWithValue("@ccd",comboBox_color.SelectedItem.ToString());
cmd1.Parameters.AddWithValue("@dI",textBox_Dayin.Text);
cmd1.Parameters.AddWithValue("@tI",textBox_timeR.Text);
Image img = pictureBox_UB.Image;
byte[] arr;
ImageConverter converter = new ImageConverter();
arr = (byte[])converter.ConvertTo(img, typeof(byte[]));
cmd1.Parameters.AddWithValue("@img",img);
cmd1.ExecuteNonQuery();
MessageBox.Show("Record has been inserted");
con1.Close();
}
Jayita Roy11y ago
Hi..after writing your code am getting error " Connection property has not been initialized."Please help
Manoj Bhoir11y ago
Hi,

You are not executing command.

cmd1.Parameters.AddWithValue("@img",img);
con1.Open();
cmd1.ExecuteNonQuery();
Sreekanth Reddy11y ago
Provide,
cmd.ExecuteNonquery();

after passing all values to parameters.
Ex:
cmd1.Parameters.AddWithValue("@ccd",comboBox_color.SelectedItem.ToString());
cmd1.Parameters.AddWithValue("@dI",textBox_Dayin.Text);
cmd1.Parameters.AddWithValue("@tI",textBox_timeR.Text);
Image img = pictureBox_UB.Image;
byte[] arr;
ImageConverter converter = new ImageConverter();
arr = (byte[])converter.ConvertTo(img, typeof(byte[]));
cmd1.Parameters.AddWithValue("@img",img);
int i=cmd.ExecuteNonquery();
if(i>0)
MessageBox.Show("Record has been inserted");
Khan Abrar Ahmed11y ago
Hi try the below code

private void button_Pass_Click(object sender, EventArgs e)
{
string connectionString ="Data Source=JAYI-PC\\SQLEXPRESS;Initial Catalog=db-ub;Integrated Security=True";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd1 = new SqlCommand("Insert into Visitors(Id,Visitor_Name,Organisation_Name,Phone_No,No_Person,To_whom,Purpose,Color_Code,Day_In,Time_In,Image) values (@id,@vname,@org,@phn,@nop,@whom,@prps,@ccd,@dI,@tI,@img)");
cmd1.CommandType = CommandType.Text;
cmd1.Connection = connection;
cmd1.Parameters.AddWithValue("@id",textBox_Id.Text);
cmd1.Parameters.AddWithValue("@vname",textBox_NameV.Text);
cmd1.Parameters.AddWithValue("@org",textBox_Org.Text);
cmd1.Parameters.AddWithValue("@phn",textBox_Phn.Text);
cmd1.Parameters.AddWithValue("@nop", numericUpDown_Person.Value.ToString());
cmd1.Parameters.AddWithValue("@whom",comboBox_TOWHOM.SelectedItem.ToString());
string prps;
if(radioButton_OFFICIAL.Checked)
{
prps = "Official";
cmd1.Parameters.AddWithValue("@prps",prps);
}
else if(radioButton_PERSONAL.Checked)
{
prps = "Personal";
cmd1.Parameters.AddWithValue("@prps",prps);
}
cmd1.Parameters.AddWithValue("@ccd",comboBox_color.SelectedItem.ToString());
cmd1.Parameters.AddWithValue("@dI",textBox_Dayin.Text);
cmd1.Parameters.AddWithValue("@tI",textBox_timeR.Text);
Image img = pictureBox_UB.Image;
byte[] arr;
ImageConverter converter = new ImageConverter();
arr = (byte[])converter.ConvertTo(img, typeof(byte[]));
cmd1.Parameters.AddWithValue("@img",img);

connection.Open();
cmd1.ExecuteNonQuery();
}
MessageBox.Show("Record has been inserted");
}