OleDbConnection OleDB = null; OleDbDataAdapter OleDat = null; string path = Server.MapPath("TempDoc/sh.xls"); if (!File.Exists(Server.MapPath("TempDoc/sh.xls"))) { alertMessage("请先上传数据文件!"); return; } try { string strOdbcCon = @"Provider=Microsoft.ACE.OLEDB.12.0; Persist Security Info=False;Data Source=" + path + "; Extended Properties=Excel 8.0"; OleDB = new OleDbConnection(strOdbcCon); OleDat = new OleDbDataAdapter("select 狗编号,领购日期,单位名称,业务人,地市,部门划分 from [Sheet1$]", OleDB); DataTable dt = new DataTable(); OleDat.Fill(dt); using (JXNetBidDBEntities ent = new JXNetBidDBEntities()) { for (int i = 0; i < dt.Rows.Count; i++) { string key = dt.Rows[i]["狗编号"].ToString().Trim(); char first = key.Trim()[0]; int count = ent.tab_zbb_userinfo.Where(p => p.SequenceNo.Equals(key)).Count(); if (count != 0 || first != 'B' || first != 'E' || first != 'b' || first != 'e') { dt.Rows.RemoveAt(i); } } } grvNotFound.DataSource = dt; grvNotFound.DataBind(); } catch (Exception ex) { //提示对话框 Response.Write(ex.Message); } finally { OleDat.Dispose(); OleDB.Close(); }