Method to return Datareader,dataset,datatable

Question

Hi friends, Please can you`ll help me

Sam Hobbs · Answer

Create a data source and the code will be created for you.

Datta Kharad · Answer

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.

Nethra R S · 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?

Datta Kharad · Answer

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

Method to return Datareader,dataset,datatable

Answers (4)