110,535
社区成员
发帖
与我相关
我的任务
分享
private void button1_Click(object sender, EventArgs e)
{
byte[] imageBytes = GetImageBytes(pictureBox1.Image);
string connStr = "SQL Server连接字符串";
using (SqlConnection conn = new SqlConnection(connStr))
{
string sql = "Insert Into T_Img Values (@ImgData) ";
using (SqlCommand cmd = new SqlCommand(sql))
{
SqlParameter param = new SqlParameter("ImgData", SqlDbType.VarBinary, imageBytes.Length);
param.Value = imageBytes;
cmd.Parameters.Add(param);
cmd.Connection = conn;
conn.Open();
int i = cmd.ExecuteNonQuery();
MessageBox.Show(i.ToString());
}
}
}
private byte[] GetImageBytes(Image image)
{
MemoryStream mstream = new MemoryStream();
image.Save(mstream, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] byteData = new Byte[mstream.Length];
mstream.Position = 0;
mstream.Read(byteData, 0, byteData.Length);
mstream.Close();
return byteData;
}