Hi everyone,

Can someone tellme how I can iterate through all the values of a column in a databse?

Thanks,

Pankaj

you can use a 'for next' loop to run through each row in your dataset

If you want to show these values in a DataGrid, you just need to bind the results you got from the database to the datagrid. Usually it's something like this:

'Do database stuff here...
DataGrid1.DataSource = dataSet1.Tables(0)
DataGrid1.DataBind()

That's it. Now your datagrid will show every column and every row in the resulting datatable. You can use the DataGrid markup to customize the datagrid (hide columns, change styles, etc)

Peter
------------------------------------------------------
Work smarter, not harder.

Hi everyone,

I made a mistake in posting my question. The question that was intended was: how to iterate through the values of a column of a DATAGRID. Sorry about that.

Thanks,
Pankaj

I don't understand your question. If I understand correctlty the datagrid control is what the code gets returned to. You can create a data source and have it bound to the datagrid control.

Are you wanting to know about data paging? IE. [u]< Prev. Page</u> | Page 2 of 5 | [u]Next Page ></u>