Bind datareader to datagrid

Hi,

Using the same way:

SqlDataReader reader = GetReader();
datagrid.DataSource = reader;
datagrid.DataBind();
reader.Close();

Note that you NEED to close the datareader !!! , otherwise you could let the
connection open.

Have you considered pagination?
cheers,
"Ricardo Luceac" <rl*****@gmail.com> wrote in message
news:OM**************@TK2MSFTNGP15.phx.gbl...

Hi...

My program make a select to an table and return the results to a
datagrid, it's all ok with dataset, but in large tables it needs to get
the entire table to show in datagrid and sometimes it takes much time...

So I thik of use the datareader, but how can I bind the data that it is
picking from the database to the datagrid???

thx...

*** Sent via Developersdex http://www.developersdex.com ***

Nov 17 '05 #2

Hi...

My program make a select to an table and return the results to a
datagrid, it's all ok with dataset, but in large tables it needs to get
the entire table to show in datagrid and sometimes it takes much time...

So I thik of use the datareader, but how can I bind the data that it is
picking from the database to the datagrid???

thx...

*** Sent via Developersdex http://www.developersdex.com ***

Nov 17 '05 #3

Ricardo Luceac

Sory but what is that GetReader()???

What is Pagination...

see ya...

*** Sent via Developersdex http://www.developersdex.com ***

Nov 17 '05 #4

Ricardo Luceac

Sory but what is that GetReader()???

What is Pagination...

see ya...

*** Sent via Developersdex http://www.developersdex.com ***

Nov 17 '05 #5

"Ricardo Luceac" <rl*****@gmail.com> wrote in message
news:Oc**************@TK2MSFTNGP10.phx.gbl...

Sory but what is that GetReader()???
That is any method that you use to get a DataReader, you hvae to change it
to reflect the name you used.
What is Pagination...
Is how you display a large table, you show only X records and use some way
to go a Next and/or Prev

cheers,

see ya...

*** Sent via Developersdex http://www.developersdex.com ***

Nov 17 '05 #6

Bind datareader to datagrid

"Ricardo Luceac" <rl*****@gmail.com> wrote in message
news:Oc**************@TK2MSFTNGP10.phx.gbl...

Sory but what is that GetReader()???
That is any method that you use to get a DataReader, you hvae to change it
to reflect the name you used.
What is Pagination...
Is how you display a large table, you show only X records and use some way
to go a Next and/or Prev

cheers,

see ya...

*** Sent via Developersdex http://www.developersdex.com ***

Nov 17 '05 #7

by: Al | last post by:

in order to implement sorting, paging in a datagrid, can I have the datasource of the datagrid a datareader or it must be a dataset then I create a dataview and make it a datasource of the...

.NET Framework

by: Ricardo Luceac | last post by:

Hi... My program make a select to an table and return the results to a datagrid, it's all ok with dataset, but in large tables it needs to get the entire table to show in datagrid and sometimes...

C# / C Sharp

How do I bind a repeater?

by: timmso | last post by:

I got this sample of code from Mike Moore in response to my question of how I create clickable links from a data source. <asp:Repeater id="Repeater1" runat="server"> <ItemTemplate>...

should I bind datagrid to array or temporary dataset?

by: AFN | last post by:

I need to manually create the data to be shown in a datagrid (or some data table object). Should I create an array and bind the array to the datagrid OR should I create a temporary dataset and...

Datagrid and datareader

by: Bart Schelkens | last post by:

Hi, I have 2 more questions : 1. Can I fill a datagrid by using a DataReader or does it have to be a DataSet or a DataView? 2. In my datagrid I need to display two images and one of does...

Simple Question: Bind DataReader to DatagGrid

by: Shapper | last post by:

Hello, I have this code to bind a DataGrid to a DataReader when page loads: Sub Page_Load(Sender As Object, e As EventArgs) dgContent.DataSource = drContent dgContent.DataBind() End Sub ...

Can I bind an oledbreader to a datagrid?

by: Fred Flintstone | last post by:

Just new to .net, and started using oledb connection to database. After getting most things working, now want to bind to a datagrid, but have not been successful as of yet. Will use alternate db...

Visual Basic .NET

Bind datagrid to SQL query using a CURSOR

by: Niclas | last post by:

Hi, I am using a SQL query that uses a CURSOR to loop and executes a SELECT statement in each loop. When I bind a datagrid to this stored procedure through a datareader as data source, I only...

Can't Figure Out How To Sort On Bind

by: pbd22 | last post by:

Hi. I am returning to an old bit of code in our program and need to figure out how to sort my columns on bind. I am sorting on Date (mostly) and some other values. Problem is, the code is an...

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...