;summary>
/// 点击打开文件对话框确定按钮，将文件保存到数据库中
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void openFileDialog1_FileOk(object sender, System.ComponentModel.CancelEventArgs e)
{
string filename = this.openFileDialog1.FileName;
SqlConnection conn = new SqlConnection("server=192.168.2.200;integrated security = sspi;database = northwind");
SqlCommand cmd = new SqlCommand("insert imgtable values(@imgname,@imgData)",conn);
SqlParameter pm = new SqlParameter("@imgname",SqlDbType.VarChar,100);
pm.Value = filename;
SqlParameter pm1 = new SqlParameter("@imgData",SqlDbType.Image);
FileStream fs = new FileStream(filename,FileMode.Open);
int len = (int)fs.Length;
byte[] fileData = new byte[len];
fs.Read(fileData,0,len);
fs.Close();
pm1.Value = fileData;
cmd.Parameters.Add(pm);
cmd.Parameters.Add(pm1);
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, System.EventArgs e)
{
this.openFileDialog1.ShowDialog();
}
/// <summary>
/// 从数据库中读取bitmap图片并显示
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param&g 上一页 [1] [2] [3] [4] [5] [6] 下一页 |
