public void addr()--------上传图片
{ XmlDocument doc = new XmlDocument();
doc.Load("Database.xml");
string strSql=doc.DocumentElement.SelectSingleNode("//connName").InnerText;
SqlConnection conn=new SqlConnection(strSql);
SqlCommand cmd=new SqlCommand("update NowStuda00Infotest set Pic=@i where StudCode=0001",conn);
byte[] ib=new Byte[60000];
FileStream fs=new FileStream(@"D:\Pic\1.jpg",FileMode.Open ,FileAccess.Read ); fs.Read(ib,0,60000);
cmd.Parameters.Add("@i",SqlDbType.Image,(int)fs.Length);
cmd.Parameters["@i"].Value=ib;
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("22");
conn.Close();
} private void button3_Click(object sender, System.EventArgs e)----读取图片
{
XmlDocument doc = new XmlDocument();
doc.Load("Database.xml");
string strSql=doc.DocumentElement.SelectSingleNode("//connName").InnerText;
SqlConnection conn=new SqlConnection(strSql);
SqlCommand cmd=new SqlCommand("select pic from NowStuda00Infotest where StudCode=0001 ",conn);
SqlDataReader reader=cmd.ExecuteReader();
reader.Read();
MemoryStream buf=new MemoryStream((byte[])reader[0]);
Image image=Image.FromStream(buf,true);
pictureBox1.Image=image;
}说SqlDataReader reader=cmd.ExecuteReader(); 这句有错 图片是以2进制的方式存储的 怎么解决啊
{ XmlDocument doc = new XmlDocument();
doc.Load("Database.xml");
string strSql=doc.DocumentElement.SelectSingleNode("//connName").InnerText;
SqlConnection conn=new SqlConnection(strSql);
SqlCommand cmd=new SqlCommand("update NowStuda00Infotest set Pic=@i where StudCode=0001",conn);
byte[] ib=new Byte[60000];
FileStream fs=new FileStream(@"D:\Pic\1.jpg",FileMode.Open ,FileAccess.Read ); fs.Read(ib,0,60000);
cmd.Parameters.Add("@i",SqlDbType.Image,(int)fs.Length);
cmd.Parameters["@i"].Value=ib;
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("22");
conn.Close();
} private void button3_Click(object sender, System.EventArgs e)----读取图片
{
XmlDocument doc = new XmlDocument();
doc.Load("Database.xml");
string strSql=doc.DocumentElement.SelectSingleNode("//connName").InnerText;
SqlConnection conn=new SqlConnection(strSql);
SqlCommand cmd=new SqlCommand("select pic from NowStuda00Infotest where StudCode=0001 ",conn);
SqlDataReader reader=cmd.ExecuteReader();
reader.Read();
MemoryStream buf=new MemoryStream((byte[])reader[0]);
Image image=Image.FromStream(buf,true);
pictureBox1.Image=image;
}说SqlDataReader reader=cmd.ExecuteReader(); 这句有错 图片是以2进制的方式存储的 怎么解决啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货