Question

数据库是SQL2005,如何在VS2008水晶报表中显示Image字段

Answer 1

privatevoid button1_Click(object sender, EventArgs e)
{
BindPicture();
}
privatevoid BindPicture()
{
string sql = ReportForm.Properties.Settings.Default.ZXHConnectionString;
SqlConnection conn =new SqlConnection(sql);
string testsql ="select Picture from ProductTab where ProID = "+ comboBox1.Text.Trim().ToString() ;

SqlCommand cmd =new SqlCommand(testsql, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();

MemoryStream ms =new MemoryStream((byte[])reader["Picture"]);

Image image = Image.FromStream(ms, true);

reader.Close();
conn.Close();

pictureBox1.Image = image;

}