private void button1_Click(object sender, System.EventArgs e)
{
string str=@"C:\Documents and Settings\Administrator.SHUTUPANDCODE\桌面\图片\内页-1.jpg";
FileStream file = new FileStream(str,FileMode.Open, FileAccess.Read);
Byte[] bytBLOBData = new Byte[file.Length];
file.Read(bytBLOBData, 0, bytBLOBData.Length);
file.Close();
OleDbCommand olecommand=new OleDbCommand("INSERT INTO tupian (jpeg) values(?)",oleDbConnection1);
olecommand.Parameters.Add(new OleDbParameter("jpeg",OleDbType.Binary,bytBLOBData.Length,ParameterDirection.Input,true,0,0,null,DataRowVersion.Default,bytBLOBData));
oleDbConnection1.Open();
olecommand.ExecuteScalar();
} private void button2_Click(object sender, System.EventArgs e)
{
OleDbCommand olecommand=new OleDbCommand("select * from tupian",oleDbConnection1);
oleDbConnection1.Open();
OleDbDataReader dr=olecommand.ExecuteReader();
dr.Read();
Byte[] byteBLOBData = (Byte[])((dr.GetValue(0)));
MemoryStream stmBLOBData = new MemoryStream(byteBLOBData);
pictureBox1.Image=Image.FromStream(stmBLOBData); }
{
string str=@"C:\Documents and Settings\Administrator.SHUTUPANDCODE\桌面\图片\内页-1.jpg";
FileStream file = new FileStream(str,FileMode.Open, FileAccess.Read);
Byte[] bytBLOBData = new Byte[file.Length];
file.Read(bytBLOBData, 0, bytBLOBData.Length);
file.Close();
OleDbCommand olecommand=new OleDbCommand("INSERT INTO tupian (jpeg) values(?)",oleDbConnection1);
olecommand.Parameters.Add(new OleDbParameter("jpeg",OleDbType.Binary,bytBLOBData.Length,ParameterDirection.Input,true,0,0,null,DataRowVersion.Default,bytBLOBData));
oleDbConnection1.Open();
olecommand.ExecuteScalar();
} private void button2_Click(object sender, System.EventArgs e)
{
OleDbCommand olecommand=new OleDbCommand("select * from tupian",oleDbConnection1);
oleDbConnection1.Open();
OleDbDataReader dr=olecommand.ExecuteReader();
dr.Read();
Byte[] byteBLOBData = (Byte[])((dr.GetValue(0)));
MemoryStream stmBLOBData = new MemoryStream(byteBLOBData);
pictureBox1.Image=Image.FromStream(stmBLOBData); }
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货