我用下面的代码读取Northwind的Employee表的图片,调试报错:参数无效。
不知道哪位大侠能告知解决方法,感激不尽.
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;Integrated Security=True;User Instance=True");
SqlCommand cmd = new SqlCommand("select [Photo] from Employees where EmployeeId=1", conn);
conn.Open();
SqlDataReader read = cmd.ExecuteReader();
read.Read();
byte[] bytes = (byte[])read["Photo"];
read.Close();
conn.Close();
MemoryStream ms = new MemoryStream();
ms.Write(bytes, 0, bytes.Length);
*System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
}
打星号的地方报错。
不知道哪位大侠能告知解决方法,感激不尽.
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;Integrated Security=True;User Instance=True");
SqlCommand cmd = new SqlCommand("select [Photo] from Employees where EmployeeId=1", conn);
conn.Open();
SqlDataReader read = cmd.ExecuteReader();
read.Read();
byte[] bytes = (byte[])read["Photo"];
read.Close();
conn.Close();
MemoryStream ms = new MemoryStream();
ms.Write(bytes, 0, bytes.Length);
*System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
}
打星号的地方报错。
解决方案 »
- 为何使用FileImport.PostedFile.FileName得到的是文件名,而没有路径?
- 在WebUserControl下 IsValid失效??
- Repeater遍历table里的值就报错怎么回事
- 如何抓取网站的表格分页数据,http://www.webcargo.com.cn/QueryPages/ApecQuery.asp的表格数据,解决了另给100分.
- 郁闷了,一个页面跳转,半天都没搞定 -_-|| 哪位帮我看看吧
- 如何取asp:Table的值
- 邮件解码问题,高分求教!!!
- 一个datagrid中有两个selectcommand列,如何识别他们触发的事件?
- DataSet里面数据表的问题,,?帮帮忙
- 谁有能用的画直方画或饼图的组件??
- 再加100分,求解
- 谁给我发个正则,验证日期时间2007-05-17 14:03 感谢
byte[] bytes = (byte[])read["Photo"].Substring(某个数字);
这个数字我忘记了,好象是64,还是多少
// for Northwind images.
// There's no header in PUBS as PUBS
// just contains the raw image bits.
int offset = 78; 详见!
http://www.ftponline.com/vsm/2002_07/online/hottips/esposito/