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.CreateNewUser(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***@discussions.microsoft.com> wrote in message
news:9C**********************************@microsof t.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.ToString(myReader.GetValue(2));
dr["dob"] =
Convert.ToString(Convert.ToDateTime(myReader.GetVa lue(3)).ToShortDateString());
dr["description"] = Convert.ToString(myReader.GetValue(4));
dt.Rows.Add(dr);
}

Then,
GridView1.datasource=dt//dt is the datatable
GridView.DataBind().

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.CreateNewUser(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***@discussions.microsoft.com> wrote in message
news:9C**********************************@microsof t.com...

Hi

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

--
Thanks,
SDRoy