我正在尝试将图像从数据库加载到PictureBox.我使用以下代码加载我们的照片.我写了一些代码,但不知道我应该做什么来继续.
任何帮助将不胜感激.
private void button1_Click(object sender,EventArgs e)
{
sql = new sqlConnection(@"Data Source=PC-PC\PC;Initial Catalog=Test;Integrated Security=True");
cmd = new sqlCommand();
cmd.Connection = sql;
cmd.CommandText = ("select Image from Entry where EntryID =@EntryID");
cmd.Parameters.AddWithValue("@EntryID",Convert.ToInt32(textBox1.Text));
}
解决方法
在button1_Click中继续执行此操作：
// your code first here.. var da = new sqlDataAdapter(cmd); var ds = new DataSet(); da.Fill(ds,"Images"); int count = ds.Tables["Images"].Rows.Count; if (count > 0) { var data = (Byte[])(ds.Tables["Images"].Rows[count - 1]["Image"]); var stream = new MemoryStream(data); pictureBox1.Image= Image.FromStream(sream); }
