Contents DataSet

[ace333]

I am just wondering that if you run call a stored procedure from c# that adds a row of data to a table, is there any way check the contents of the dataset after the stored procedure has run successfully.
This is the code:
public DataSet getData(string[] aParams)
{

string sConn = GetConnString();

OracleConnection oracleConn = new OracleConnection(sConn);
OracleCommand objCmd;

DataSet dsRet = new DataSet();

try
{
PopulateCommand(aParams,out objCmd); //Add the parameters to the stored procedure.

objCmd.Connection=oracleConn;

OracleDataAdapter objDA = new OracleDataAdapter(objCmd);

objDA.Fill(dsRet);



///DataTable dataTable = dsRet.Tables[0];
///DataGrid1.DataSource = dataTable;
///DataGrid1.DataBind();


}

 

[MadJock]

Hi,

What do you want to check?

Is this any good:

if (dsRet.Tables[0].Rows.Count > 0){
  //  all is well
} else {
  //  nothing loaded - take action
}

"Just beacuse you're paranoid, don't mean they're not after you