DATAGrid

[yasseralim]

I create datagrid and bound data ftom database here is my code

Dim con As New OleDbConnection
        con.ConnectionString = "Provider=Microsoft.Jet.OleDB.4.0;data source=" & Server.MapPath("pctech.mdb")
        Dim cmdselect As New OleDbCommand
        cmdselect.Connection = con
        cmdselect.CommandType = CommandType.Text
        cmdselect.CommandText = "select * from pc_details , pckind  where pc_details.pckindid = pckind.pckindid  and stockid  > 0 "
        Dim ad As New OleDbDataAdapter
        ad.SelectCommand = cmdselect
        Dim ds As New DataSet
        ad.Fill(ds)
        DataGrid1.DataSource = ds.Tables(0).DefaultView
        DataGrid1.DataBind()
        con.Close()

The datagrid is bounded find and i c the data Now i added select command to datagrid and i need when user click on select command datagrid fill the textbox on the form i write this code but dose no t work and textbox still empty

Sub test(ByVal Sender As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs)
 
 
        If e.CommandName = "Select" Then
            Dim strKey As String
            strKey = e.Item.Cells(0).Text
            TextBox1.Text = (strKey)
            TextBox1.DataBind()
 
        End If
 
    End Sub

[Shashi Sadasivan]

Hi,
Welcome to TSDN.

Please let us know the problem you are facing with your code!
The more details you can give the easier it would be for experts over here to help you out.


Is the test (Sub) method an even from the click of the datagrid?

You do not need to bind the textbox. Is the tesxt box being set to any field in the dataset?

-Shashi