public DataSet ExecutePagedDataSet(string CmdText, int intStart, int intMaxRec, string strTable, CommandType CmdType, out int totalRecords)
{
try
{
MySqlDataAdapter Adaptergrid;
if (CmdType == CommandType.Text)
{
Adaptergrid = new MySqlDataAdapter(CmdText, Con);
Adaptergrid.SelectCommand.CommandType = CmdType;
}
else
{
Adaptergrid = new MySqlDataAdapter();
this.Cmd.CommandText = CmdText;
this.Cmd.CommandType = CmdType;
this.Cmd.Connection = this.Con;
Adaptergrid.SelectCommand = this.Cmd;
}
this.OpenConnection();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Adaptergrid.Fill(ds, intStart, intMaxRec, strTable);
Adaptergrid.Fill(dt);
totalRecords = dt.Rows.Count;
this.CloseConnection();
return(ds);
}
catch (Exception e)
{
totalRecords = 0;
throw (e);
}
}
public DataSet ExecuteTransactionDataSet(string CmdText, CommandType CmdType)
{
try
{
MySqlDataAdapter Adaptergrid;
if (CmdType == CommandType.Text)
{
Adaptergrid = new MySqlDataAdapter(CmdText, this.Con);
Adaptergrid.SelectCommand.Transaction = this.Trans;
Adaptergrid.SelectCommand.CommandType = CmdType;
}
else
{
Adaptergrid = new MySqlDataAdapter();
this.Cmd.CommandText = CmdText;
this.Cmd.CommandType = CmdType;
this.Cmd.Transaction = this.Trans;
this.Cmd.Connection = this.Con;
Adaptergrid.SelectCommand = this.Cmd;
}
DataSet ds = new DataSet();
Adaptergrid.Fill(ds);
return(ds);
}
catch (Exception e)
{
throw (e);
}
}
