62,268
社区成员
发帖
与我相关
我的任务
分享
FileStream imageStream = new FileStream(imagePath, FileMode.Open);
System.Drawing.Image image = System.Drawing.Image.FromStream(imageStream);
image.Save(mPath + "\\" + imageName); string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + @filename + ";Extended Properties=Excel 8.0";
OleDbConnection myConn = new OleDbConnection(strCon);
string strCom1 = " SELECT * FROM [企业$]";
myConn.Open();
//打开数据链接,得到一个数据集
OleDbDataAdapter myCommand1 = new OleDbDataAdapter(strCom1, myConn);
//创建一个 DataSet对象
DataSet myDataSet1 = new DataSet();
//得到自己的DataSet对象
myCommand1.Fill(myDataSet1, "tt1");
//关闭此数据链接
myConn.Close();
DataTable dt1 = myDataSet1.Tables[0];
//循环读取excel内容到数据库
foreach (DataRow dr in dt.Rows)
{
model.NAME = dr["名称"].ToString();//名称
}
add(model);