//using System.Data;
//using System.Data.OleDb;
String file_name = "P:/test.xls";
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file_name + ";Extended Properties=Excel 8.0;";
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
OleDbDataAdapter obad = new OleDbDataAdapter();
obad.SelectCommand = objCmdSelect;
DataSet ds1 = new DataSet();
obad.Fill(ds1, "table1");
objConn.Close();
// 这里， 如何查询 第一列， 等于 tester 的数据
ds1.Tables[0].Select("A='tester'");
GridView1.DataSource = ds1;
GridView1.DataBind();
//test.xls 表格数据如下
//注明， 工号， 那列是第一行 , tester 第二行
工号 名称 基本工资 实发工资 合计
tester test 11 222 333
tester2 test2 22 333 555
String file_name = "P:/test.xls";
String select_exp = "[工号]='tester'";
String query_string = "SELECT * FROM [Sheet1$]";
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file_name + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';";
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
OleDbCommand objCmdSelect = new OleDbCommand(query_string, objConn);
OleDbDataAdapter obad = new OleDbDataAdapter();
obad.SelectCommand = objCmdSelect;
DataSet ds1 = new DataSet();
obad.Fill(ds1, "table1");
objConn.Close();
DataTable dt = ds1.Tables[0].Clone();
dt.Clear();
DataRow[] _data = ds1.Tables[0].Select(select_exp);
foreach (DataRow row in _data)
{
dt.Rows.Add(row.ItemArray);
}
GridView1.DataSource = dt;
GridView1.DataBind();
