How to bind data to Text box

Question

Hi I use a filter on a sqlDataSource which has uniq rows. I need to bind several fields of the result filtered row to textboxes. Here the code : SqlDataSource dsPrev = (SqlDataSource)PreviousPage.FindControl(SqlDataSource1); dsPrev.FilterExpression = dr_id=' + id + ' ; GridView gvTemp = new GridView(); gvTemp.DataSource = dsPrev; gvTemp.DataBind(); TextBox1.Text = gvTemp.Rows[0].Cells[3].Text; Is there a more professional way to do it ? Thanks David

Anwar Buchoo · Answer

Use a DataList and set its DataSource to your sqlDataSource object. In the ItemTemplate of the dataList object at as many textboxes as you have fields. Then set the TextBox.Text value to DataBind.Eval(Container.DataItem corresponding fieldname) in the code in-front like follows: Text=' ' Cheers

David · Answer

Hi You stopped just where I have the problem. How can I bind this textbox to a field in the dataview ? Thanks for your help. David

Tirthadip Mukhopadhyay · Answer

hi use dataview.Instantiate a dataview from the dataset table.dataview has a method called filteri suppose you know.place your filter condition like--- mydataview.Filter=filter condition; now bind your textboxes by that filtered values. hope this will do. happy programming. Tirthadip.