/// <summary> /// 执行一个DbCommand并返回DataSet /// </summary> /// <param name="comm"></param> /// <returns></returns> public static DataSet ExecuteCommand(this DbProviderFactory dbFactory, DbCommand comm, string connectionStringName) { DbConnection conn = dbFactory.CreateConnection(connectionStringName); comm.Connection = conn; DbDataAdapter adapter = dbFactory.CreateDataAdapter(); adapter.SelectCommand = comm; try { DataSet ds = new DataSet(); adapter.Fill(ds); return ds; } catch (Exception eX) { throw eX; } finally { if (ConnectionState.Open == conn.State) conn.Close(); } }
public static void FillDataSet(this DbConnection conn, DataSet dataSet, string tableName, string sql, MissingSchemaAction missingSchemaAction = MissingSchemaAction.Add) { using (var da = conn.CreateDataAdapter()) using (var cmd = conn.CreateCommand()) { cmd.CommandText = sql; da.SelectCommand = cmd; da.MissingSchemaAction = missingSchemaAction; da.Fill(dataSet, tableName); } }
public static DataTable Query(this DbConnection conn, string sqlStatement, int start = 0, int maxRecords = 0) { DataSet ds = new DataSet(); IDbDataAdapter da = conn.CreateDataAdapter(); IDbCommand cmd = conn.CreateCommand(); cmd.CommandText = sqlStatement; da.SelectCommand = cmd; da.Fill(ds); return ds.Tables[0]; }