displaying data in a textbox by clicking a row in datagrid

[pranavcool]

I have one query related to datagrid. I have four textboxes for example textbox1,textbox2,textbox3,textbox4. And a datagrid control displaying data from sql server 2000.It has four colums say column1,column2,column3,column4. Now i want that when user click any row in that datagrid all the data of that particular row (say column1,column2,column3,column4) from a datagrid should appear in textbox1,textbox2,textbox3,textbox4. Can any one can help me.I required to do this thing in my project.If possible can any one explain this wit any example.Or please give any link on the internet explaining this thing. regards, pranav

Pranav Dave

[Nizha J]

datagrid has a property called columns.. in that choose button column and choose edit,update and camcel... then go to the codebehind window and selet datagrid name in class name combo box and edit command in method name combo box.. then write this.. Private Sub dg_EditCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles dg.EditCommand dg.EditItemIndex = e.Item.ItemIndex Dim ds As DataSet = getdata() bindgrid(ds) End Sub Public Function getdata() As DataSet Try con.Open() ada = New OleDbDataAdapter("select * from topic", con) ada.Fill(ds1) Return ds1 Catch ex As Exception Response.Write(ex.Message) Finally con.Close() End Try End Function Public Function bindgrid(ByVal ds As DataSet) dg.DataSource = ds dg.DataBind() End Function this will automatically replace a texbox with the respective values

Nizha

[Nizha J]

similarly you have to write statements for update and cancel.. if you have any problem.. ask..

Nizha