怎样把Excel文件本身存入SQL Server数据库,又怎样查出后显示在Form上
解决方案 »
- 正则匹配换行符
- 字符串的处理
- 如何展开树形中指定的节点?
- 请问如何在datagridview中筛选记录?
- 开发一个网上直播教学的网站,不知道从哪里下手!!
- C# 数据集操作问题
- 《完全训练Asp.net》(Total Training for Microsoft ASP.NET 2.0)4DVD[ISO]
- VS2005有什么好的控件?
- 求高手帮忙啊,。。。。速度啊
- 我在看".NET SDK文档"时,不断弹出"Visual Studio .NET Enterprise Architect - CHS"安装
- atlas有.net1.1版的吗?
- 急急急!!!!!! 在web客户端如何对TreeView 进行初始话?
1、将图片显示在pictureBox里
if (this.loadingPicture1._LoadingPicture.Rows.Count == 1)
{
if (this.loadingPicture1._LoadingPicture.Rows[0]["Picture"] != System.DBNull.Value)
{
FileInfo fi = new FileInfo(Type.Missing.ToString());
byte[] mydata = ((byte[])this.loadingPicture1._LoadingPicture.Rows[0]["Picture"]);
FileStream PictureStream = fi.Open(FileMode.Create);
foreach (byte a in mydata)
{
PictureStream.WriteByte(a);
}
this.pictureBox1.Image = Image.FromStream(PictureStream);
PictureStream.Close();
}
} 2、将图片写入DataRow
this.pictureBox1.Image = Image.FromFile(filename);
FileInfo fi = new FileInfo(filename);
int imgdatalen = (int)fi.Length;
byte[] imgdata = new byte[imgdatalen];
Stream imgdatastream = fi.OpenRead();
int n = imgdatastream.Read(imgdata, 0, imgdatalen);
if (this.loadingPicture1._LoadingPicture.Rows.Count == 1)
this.loadingPicture1._LoadingPicture.Rows[0]["Picture"] = imgdata;我用同样的办法不会处理Excel文件,可不可以写示范一段代码
文件里都是客户发来的一个图片,对应一个机型编号,数据列就是两个:机型编号,图形
string strSql = "";
string sheetName = "";
OleDbDataAdapter objDa;
objConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + this.mFilePath + ";Extended Properties=\"Excel 8.0;IMEX=1;\"");
//获取工作簿中的表
strSql = "select * from [" + sheetName + "$]";
//将sheet填入table中
objDa = new OleDbDataAdapter(strSql, objConn);
objDa.Fill(tTable);