/// <summary> /// /// </summary> /// <param name="tableName"></param> /// <param name="mode"></param> /// <param name="criteria"></param> /// <returns></returns> public int GetCountRows(string tableName, ExcelHelperReadMode mode, string criteria) { if (Connection.State != ConnectionState.Open) { Connection.Open(); } string cmdText = "Select Count(*) from [{0}]"; if (!string.IsNullOrEmpty(criteria)) { cmdText += " Where " + criteria; } string tableNameSuffix = string.Empty; if (mode == ExcelHelperReadMode.ReadWorkSheet) { tableNameSuffix = "$"; } var cmd = new OleDbCommand(string.Format(cmdText, tableName + tableNameSuffix)) { Connection = Connection }; var count = (int)cmd.ExecuteScalar(); return(count); }
/// <summary> /// /// </summary> /// <param name="tableName"></param> /// <param name="mode"></param> /// <param name="criteria"></param> /// <returns></returns> public OleDbDataReader ReadTable(string tableName, ExcelHelperReadMode mode, string criteria) { if (Connection.State != ConnectionState.Open) { Connection.Open(); } string cmdText = "Select * from [{0}]"; if (!string.IsNullOrEmpty(criteria)) { cmdText += " Where " + criteria; } string tableNameSuffix = string.Empty; if (mode == ExcelHelperReadMode.ReadWorkSheet) { tableNameSuffix = "$"; } var cmd = new OleDbCommand(string.Format(cmdText, tableName + tableNameSuffix)) { Connection = Connection }; OleDbDataReader read = cmd.ExecuteReader(); //OleDbDataAdapter adpt = new OleDbDataAdapter(cmd); //DataSet ds = new DataSet(); //adpt.Fill(ds, tableName); //if (ds.Tables.Count >= 1) //{ // return ds.Tables[0]; //} //else //{ // return null; //} return(read); }
/// <summary> /// /// </summary> /// <param name="tableName"></param> /// <param name="mode"></param> /// <returns></returns> public OleDbDataReader ReadTable(string tableName, ExcelHelperReadMode mode) { return(ReadTable(tableName, mode, "")); }
/// <summary> /// /// </summary> /// <param name="tableName"></param> /// <param name="mode"></param> /// <param name="criteria"></param> /// <returns></returns> public OleDbDataReader ReadTable(string tableName, ExcelHelperReadMode mode, string criteria) { if (Connection.State != ConnectionState.Open) { Connection.Open(); } string cmdText = "Select * from [{0}]"; if (!string.IsNullOrEmpty(criteria)) { cmdText += " Where " + criteria; } string tableNameSuffix = string.Empty; if (mode == ExcelHelperReadMode.ReadWorkSheet) tableNameSuffix = "$"; var cmd = new OleDbCommand(string.Format(cmdText, tableName + tableNameSuffix)) { Connection = Connection }; OleDbDataReader read = cmd.ExecuteReader(); //OleDbDataAdapter adpt = new OleDbDataAdapter(cmd); //DataSet ds = new DataSet(); //adpt.Fill(ds, tableName); //if (ds.Tables.Count >= 1) //{ // return ds.Tables[0]; //} //else //{ // return null; //} return read; }
/// <summary> /// /// </summary> /// <param name="tableName"></param> /// <param name="mode"></param> /// <returns></returns> public OleDbDataReader ReadTable(string tableName, ExcelHelperReadMode mode) { return ReadTable(tableName, mode, ""); }
/// <summary> /// /// </summary> /// <param name="tableName"></param> /// <param name="mode"></param> /// <param name="criteria"></param> /// <returns></returns> public int GetCountRows(string tableName, ExcelHelperReadMode mode, string criteria) { if (Connection.State != ConnectionState.Open) { Connection.Open(); } string cmdText = "Select Count(*) from [{0}]"; if (!string.IsNullOrEmpty(criteria)) { cmdText += " Where " + criteria; } string tableNameSuffix = string.Empty; if (mode == ExcelHelperReadMode.ReadWorkSheet) tableNameSuffix = "$"; var cmd = new OleDbCommand(string.Format(cmdText, tableName + tableNameSuffix)) { Connection = Connection }; var count = (int) cmd.ExecuteScalar(); return count; }