gabrieleb
دوشنبه 03 آبان 1389, 20:44 عصر
private void button2_Click_1(object sender, EventArgs e)
{
try
{
SqlConnection SqlConnection1 = new SqlConnection("Data Source=.;" + "Initial Catalog=ax;Integrated Security=True");
string strsql = "INSERT INTO Table_1(Name,Photo) VALUES(@Name,@Photo)";
MemoryStream MemoryStream1 = new MemoryStream();
pictureBox1.Image.Save(MemoryStream1, pictureBox1.Image.RawFormat);
byte[] arrpic = MemoryStream1.GetBuffer();
MemoryStream1.Close();
SqlConnection1.Open();
SqlCommand SqlCommand1 = new SqlCommand(strsql,SqlConnection1);
SqlCommand1.Parameters.Add("@Name", SqlDbType.NVarChar, 50).Value = textBox2.Text;
SqlCommand1.Parameters.Add("@Photo", SqlDbType.VarBinary).Value = arrpic;
SqlCommand1.ExecuteNonQuery();
SqlConnection1.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return;
}
MessageBox.Show("Saved");
}
پیغام خطاش همون رنگ قرمزه و اینه
String or binary data would be truncated.
The statement has been terminated.
ممنون میشم اگه راهنمایی کنین ...خیلی لازم دارم:قلب:
{
try
{
SqlConnection SqlConnection1 = new SqlConnection("Data Source=.;" + "Initial Catalog=ax;Integrated Security=True");
string strsql = "INSERT INTO Table_1(Name,Photo) VALUES(@Name,@Photo)";
MemoryStream MemoryStream1 = new MemoryStream();
pictureBox1.Image.Save(MemoryStream1, pictureBox1.Image.RawFormat);
byte[] arrpic = MemoryStream1.GetBuffer();
MemoryStream1.Close();
SqlConnection1.Open();
SqlCommand SqlCommand1 = new SqlCommand(strsql,SqlConnection1);
SqlCommand1.Parameters.Add("@Name", SqlDbType.NVarChar, 50).Value = textBox2.Text;
SqlCommand1.Parameters.Add("@Photo", SqlDbType.VarBinary).Value = arrpic;
SqlCommand1.ExecuteNonQuery();
SqlConnection1.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return;
}
MessageBox.Show("Saved");
}
پیغام خطاش همون رنگ قرمزه و اینه
String or binary data would be truncated.
The statement has been terminated.
ممنون میشم اگه راهنمایی کنین ...خیلی لازم دارم:قلب: