How to return sqldatareader object

Alok Pandey

15y7.1k.NET

Hi,

In my web application I want to return object of sqldatareader from class.cs file to web.aspx.cs file to show result in TextBox. How will I use the sqldatareader object in web.aspx.cs file. Plz, help me

Thanks,

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
hi,

as per me, it is not good idea to move datareader between function.
intead of doing this use disconnected mode like dataset, datatable...

hope this will help you.
0
Hiral13y ago
its giving error we cant use in webservice as a public Static sqldatareader name(out sqldatareader rd)
0
Pravin More15y ago
Hi Alok,

You not metioned from where you want to return DataReader...i mean if you want to return it from webservice then you cant return DataReader object because this is a stream based object which cannot be serialized.
so you can create List or pass dataset table.......

Thanx,
Pravin.
0
Dorababu Meka15y ago
Class file code I am just getting a single value from the database as a sample you can change as per your requirement.

public static SqlDataReader returnData(out SqlDataReader sdr)
{
sdr = null;
SqlDataReader dr = null;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ToString());

SqlCommand cmd = new SqlCommand("Select Name from tblEmp", conn);
conn.Open();

dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
sdr = dr;
return dr;

}

in your webpage

Person.returnData(out dr);
while (dr.Read())
{
TextBox1.Text = dr.GetString(0);
}
0