Displaying data in a datagrid

[Guest]

Hi

What is the best way to populate a datagrid?, can you populate it row by row using a datareader or is dataAdapater.Fill then Dataset binding the only way

John

 

[Scott M.]

The data doesn't have to come from a DataAdapter, but calling
dataGrid.DataBind after setting its dataSource is the only way.

Hi,

What is the best way to populate a datagrid?, can you populate it row by

row using a datareader or is dataAdapater.Fill then Dataset binding the only
way?

 

[Guest]

What are the different ways of populating the datagrid, can I do it one row at a time.

----- Scott M. wrote: -----

The data doesn't have to come from a DataAdapter, but calling
dataGrid.DataBind after setting its dataSource is the only way.

Hi,

row using a datareader or is dataAdapater.Fill then Dataset binding the only
way?

 

[Scott M.]

I answered that question already....When you set the DataGrid.DataSource
property you are telling the grid where ALL the data is that it will be
bound to. When you call DataGrid.DataBind, you are instructing the grid to
bind itself to ALL of the data. You can't do it one record at a time. This
is the only way to populate a DataGrid.

If you want that functionality, look into building an HTML table dynamically
(like the way we did it in classic ASP).

 

[ajaymehra]

- you can use a sqlcommand to write a query and retrieve the records i
a datatable or dataview and bind it to the datagrid

- you can use the dataadapter method

I think you are thinking in terms of classic ASP - do while no
rs.EOF.....rs.MoveNext

You cant do that here.
You can however have complete control over the datagrid to display wha
columns and what rows by setting the Datagrids AutoGenerateColumn
property to FALSE and using the ItemBound method to display data.

*Hi,

What is the best way to populate a datagrid?, can you populate it ro
by row using a datareader or is dataAdapater.Fill then Datase
binding the only way?

John

ajaymehr