How do i...save an image to an n SQL database using C# and SQL

See more:

SQL

C#3.5

image

I have a windows form that get input from a user then store the data in a sql database. One of the feilds is a picturebox. I want to save the image as binary and then store it along with the other values in the sql database. My code for the save button is as follows:

SqlConnection cs = new SqlConnection ("Data Source=LAPTOP-QB470LUM\\SQLEXPRESS01;Initial Catalog=AssertManagement;Integrated Security=True");
SqlDataAdapter da = new SqlDataAdapter();
da.InsertCommand  = new SqlCommand ("Insert into Road_Sign values (@sign_id, @year_made, @route, @section, @date_intalled, @expiry_date, @position, @condition, @chainage_from,  @chainage_to, @picture)",cs);
            
da.InsertCommand.Parameters.Add("@sign_id", SqlDbType.Text).Value = txtSignId.Text;
da.InsertCommand.Parameters.Add("@year_made", SqlDbType.Date).Value =dtpYearMade.Value;
da.InsertCommand.Parameters.Add("@route", SqlDbType.Text).Value = txtRoute.Text;
da.InsertCommand.Parameters.Add("@section", SqlDbType.Text).Value = txtSection.Text;
da.InsertCommand.Parameters.Add("@date_intalled", SqlDbType.Date).Value = dtpDateInstalled.Value;
da.InsertCommand.Parameters.Add("@expiry_date", SqlDbType.Date).Value = dtpExpiryDate.Value;
if (radioButton1.Checked == true)
{
    da.InsertCommand.Parameters.Add("@position", SqlDbType.Text).Value = radioButton1.Checked;
}
else if (radioButton2.Checked == true)
{
    da.InsertCommand.Parameters.Add("@position", SqlDbType.Text).Value = radioButton2.Checked;
}
else
{
    da.InsertCommand.Parameters.Add("@position", SqlDbType.Text).Value = radioButton3.Checked;
}
da.InsertCommand.Parameters.Add("@condition", SqlDbType.Text).Value = txtCondition.Text;
da.InsertCommand.Parameters.Add("@chainage_from", SqlDbType.Text).Value = txtChainfrom.Text;
da.InsertCommand.Parameters.Add("@chainage_to", SqlDbType.Text).Value = txtChainTo.Text;
da.InsertCommand.Parameters.Add("@picture", SqlDbType.VarBinary).Value = DBNull.Value;
           
        
cs.Open();
da.InsertCommand.ExecuteNonQuery();
cs.Close();

btnSave.Enabled = false;

MessageBox.Show("Data Saved Successfully");

When I debug, I get the following error: operand type clash: text is incompatable with date.

The data type for the picture column in sql is a varbinary.

Is there an error in my code that I'm not picking up? Or do I need to change my approach to the project? Kindly assist.

What I have tried:

When I comment out the da.InsertComand.ExecuteNonQuery(); it goes to disable the save button and displays the message box. Obviously this isn't helping because the data is not being saved.