public DataSet ExecDataSet(DbCommand cmd) { try { cmd.Connection = this.SQLConn; this.Open(); SqlServerDataAdapter adp = new SqlServerDataAdapter((SqlCommand)cmd); DataSet ds = new DataSet(); adp.Fill(ds); this.Close(); return(ds); } catch (Exception e) { this.Close(); throw e; } }
public XORM.CBase.Data.Common.DataTable ExecDataTable(DbCommand cmd) { try { cmd.Connection = this.SQLConn; this.Open(); SqlServerDataAdapter adp = new SqlServerDataAdapter((SqlCommand)cmd); XORM.CBase.Data.Common.DataTable dt = new XORM.CBase.Data.Common.DataTable(); adp.Fill(dt); this.Close(); return(dt); } catch (Exception e) { this.Close(); throw e; } }
public DataSet ExecProcDataSet(string ProcName, params object[] cmdParams) { SqlCommand cmd = new SqlCommand(); try { CommonPreCmd(ProcName, cmd, null, CommandType.StoredProcedure, cmdParams); SqlServerDataAdapter da = new SqlServerDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); cmd.Parameters.Clear(); this.Close(); return(ds); } catch (Exception e) { this.Close(); throw e; } }
public XORM.CBase.Data.Common.DataTable ExecTextDataTable(string SQLText, params object[] cmdParams) { SqlCommand cmd = new SqlCommand(); try { CommonPreCmd(SQLText, cmd, null, CommandType.Text, cmdParams); SqlServerDataAdapter da = new SqlServerDataAdapter(cmd); XORM.CBase.Data.Common.DataTable dt = new XORM.CBase.Data.Common.DataTable(); da.Fill(dt); cmd.Parameters.Clear(); this.Close(); return(dt); } catch (Exception e) { this.Close(); throw e; } }