111,097
社区成员




using (OleDbConnection Conn = new OleDbConnection(ConnString))
{
OleDbCommand Comm = new OleDbCommand();
Comm.Connection = Conn;
OleDbDataAdapter Adapter = new OleDbDataAdapter();
Conn.Open();
//动态获取excel内的sheet
DataTable sheetNameTable = Conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });
string TableName = sheetNameTable.Rows[0]["TABLE_NAME"].ToString();
Comm.CommandText = "select * from [" + TableName + "]";
Adapter.SelectCommand = Comm;
dtImport = new DataTable("BFCliChkMonImptDetl");
Adapter.Fill(dtImport);
if (Conn.State != ConnectionState.Closed)
{
Conn.Close();
}
}