retrieve field from dataset

**viviensiu** · 12-07-2005, 08:55 AM

hello, I populated my dataset object with table Test that has 3 specific fields in it, namely "name" , "age", "sex".

How can I get each one of them out from the dataset object, set the value of the textfield with it, then display the textfield on the HTML page? All datagrid can go is to get everything out, which is not what I wanted. Because I might only want the name and age, and display them separate places.

Please help coz I'm a newbie to .NET. Also please suggest if I shouldn't be using dataset at all.

**Phil Weber** · 12-07-2005, 10:53 AM

TextBox1.Text= MyDataSet.Tables("Test").Rows(0)("name").ToString()

**viviensiu** · 12-07-2005, 10:58 PM

Thanks Phil

**raghavandx** · 12-16-2005, 11:31 PM

Hey vivien.,
Well if you want to screen data from dataset, you can use the Dataview
Set the dataview's table property to whihc table u r gonna retrive values, use rowfilter property to filter those columns you need. and sort property according to which u can order the columns.
Then give ur dataview as a datasource to ur datagrid. problem solved--!!