SqlDataReader Limitation?

[SDRoy]

Hi

Is there a limitation on how many rows can be fetched using a SqlDataReader
in ASP.Net 2.0 ?

--
Thanks,
SDRoy

[neilmcguigan]

one?

[Karl Seguin [MVP]]

Well, you can only read one at a time, which I assume is that the previous
poster was talking about...

But there's no built-in limitation. I imagine if you tried to receive a
billion rows something would go wrong. The real limitation is going to be
what you are storing the data into. I mean, if you discard the data via
something like:

while (dr.Read())
{
}

I imagine you could fetch an unlimited number of rows...
but if you are loading the data into something, like:

while(dr.Read() )
{
users.Add(new User.CreateNewU ser(dr));
}

you'll obviously eventually run out of memory because your user collection
is going to grow to be too much.

Karl

--
http://www.openmymind.net/
http://www.fuelindustries.com/
"SDRoy" <SD***@discussi ons.microsoft.c om> wrote in message
news:9C******** *************** ***********@mic rosoft.com...

Hi

Is there a limitation on how many rows can be fetched using a
SqlDataReader
in ASP.Net 2.0 ?

--
Thanks,
SDRoy

[SDRoy]

Thanks. Yes I am doing something like...

while (myReader.Read( ))
{
dr = dt.NewRow();
dr["fullname"] = Convert.ToStrin g(myReader.GetV alue(2));
dr["dob"] =
Convert.ToStrin g(Convert.ToDat eTime(myReader. GetValue(3)).To ShortDateString ());
dr["descriptio n"] = Convert.ToStrin g(myReader.GetV alue(4));
dt.Rows.Add(dr) ;
}

Then,
GridView1.datas ource=dt//dt is the datatable
GridView.DataBi nd().

I am seeing that my GridView doesn't show all the rows that have been
returned from the sql query...
How do I achieve this ?

Thanks

--
Thanks,
SDRoy
"Karl Seguin [MVP]" wrote:

Well, you can only read one at a time, which I assume is that the previous
poster was talking about...

But there's no built-in limitation. I imagine if you tried to receive a
billion rows something would go wrong. The real limitation is going to be
what you are storing the data into. I mean, if you discard the data via
something like:

while (dr.Read())
{
}

I imagine you could fetch an unlimited number of rows...
but if you are loading the data into something, like:

while(dr.Read() )
{
users.Add(new User.CreateNewU ser(dr));
}

you'll obviously eventually run out of memory because your user collection
is going to grow to be too much.

Karl

--
http://www.openmymind.net/
http://www.fuelindustries.com/
"SDRoy" <SD***@discussi ons.microsoft.c om> wrote in message
news:9C******** *************** ***********@mic rosoft.com...

Hi

Is there a limitation on how many rows can be fetched using a
SqlDataReader
in ASP.Net 2.0 ?

--
Thanks,
SDRoy