Method to return Datareader,dataset,datatable

Hi Nethra

  You can try this code...

private void button2_Click(object sender, EventArgs e)
{
DataSet ds=new DataSet();
DataSet dsData = new DataSet();
DataTable dt=new DataTable();
DataTable dtData = new DataTable();
SqlDataReader dr=null;
SqlDataReader drData = null;
object objData;
objData = MethodCall(ds, "DATASET");
dsData = (DataSet)objData;
objData = MethodCall(dt, "DATATABLE");
dtData = (DataTable)objData;
objData = MethodCall(dr, "DATAREADER");
drData = (SqlDataReader)objData;
}

private object MethodCall(object obj, string senderType)
{

DataSet dsTemp=new DataSet();
DataTable dtTemp = new DataTable();
SqlDataReader drTemp ;
object resObj=null;
if (senderType == "DATASET")
{
dsTemp = (DataSet)obj;
//Here your code
//==========
resObj = dsTemp;
}
else if(senderType=="DATATABLE")
{
dtTemp = (DataTable)obj;
//Here your code
//==========
resObj = dtTemp;
}
else if (senderType == "DATAREADER")
{
drTemp = (SqlDataReader)obj;
//Here your code
//==========
resObj = drTemp;
}
return resObj;
}

  If you got correct solution then mark as Accepted Answer.

Hi Datta,

How to write a method that returns a datareader object, same way to return dataset,datatable object. Can you tell me how to write the code for that?

Hi
  Describe your question in detail i,e what do you want?