主题:关于SQLDATAREADER的问题
我在数据库中存储了两张图片,IMAGE格式
我写了段代码如下
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=localhost;Database=酒店管理;User Id=sa";
string strSql = "select images from Test ";
SqlCommand cmd = new SqlCommand(strSql, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
reader.Read();
MemoryStream ms = new MemoryStream((byte[])reader["images"]);
Image image = Image.FromStream(ms, true);
pictureBox1.Image = image;
}
reader.Close();
conn.Close();
把WHILE去掉FROM上的PICTURE就可以显示第一张图片,我加上WHILE就提示Image image = Image.FromStream(ms, true);
的参数无效,这是为什么呢?
我写了段代码如下
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=localhost;Database=酒店管理;User Id=sa";
string strSql = "select images from Test ";
SqlCommand cmd = new SqlCommand(strSql, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
reader.Read();
MemoryStream ms = new MemoryStream((byte[])reader["images"]);
Image image = Image.FromStream(ms, true);
pictureBox1.Image = image;
}
reader.Close();
conn.Close();
把WHILE去掉FROM上的PICTURE就可以显示第一张图片,我加上WHILE就提示Image image = Image.FromStream(ms, true);
的参数无效,这是为什么呢?