How to fill other columns by selecting some value in a drop down column

[Anahita]

hello everyone, i have a problem, i have a product table in Database, i need to automatically fill other columns by selecting product code value in my combo box column in my dataview but i cant do it, please help me, i already tried CellEndEdit event but i just got the productId that i need.

[Anahita]

for the record other columns are text box columns

[Stefan]

Hello Anahita,

Thank you for writing.

A suitable event for the purpose would be CellValueChanged, which will get triggered once cell value is changed and submitted to the cell.

Another possible way is to use ValueChanged event, which will get triggered when the value of the cell is changed, even not yet submitted to the cell.

Here you can see the event sequence: http://www.telerik.com/help/winforms/gridview-editors-events.html.

I hope that you find this information useful. Should you have any other questions, do not hesitate to contact us.

Regards,
Stefan
Telerik

 

 

[Martin Hamilton]

Private Sub rgvDispenseProducts_CellValueChanged(sender As Object, e As GridViewCellEventArgs)
    If TypeOf e.Column Is GridViewComboBoxColumn Then
            oSQL = New DAL.SQLServer
            oSQL.ConnectionString = cnSQL
            Dim dtProducts As DataTable = oSQL.GetDataTable("Select * From Products where id = " & e.Value)
                        For Each myRow As DataRow In dtProducts.Rows
                                    rgvDispenseProducts.SelectedRows(0).Cells("ProductName").Value = myRow("ProductName").ToString
                        Next
            End If
End Sub