我的目的是先从一个本地excel表中读出一列编号数据,这一步已经做好了,然后根据这些编号再从数据库中读出详细的信息,该怎么写呢,怎么遍历这些数据然后select呢OleDbConnection conn = new OleDbConnection(strConn);
OleDbCommand com = new OleDbCommand("SELECT 姓名 FROM [Sheet1$]", conn); //conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
下面该怎么写?
OleDbCommand com = new OleDbCommand("SELECT 姓名 FROM [Sheet1$]", conn); //conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
下面该怎么写?
OleDbConnection conn = new OleDbConnection(strConn);
OleDbCommand com = new OleDbCommand("SELECT 姓名 FROM [Sheet1$]", conn);
OleDbDataAdapter da = new OleDbDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
if(ds!=null && ds.Tables.Count>0)
{
foreach(DataRow dr in ds.Tables[0].Rows)
{
//在这里遍历,然后查询
string Sql="select * from 表名 where Name='"+dr["姓名"]+"'";
....
}
}