AutoPostBack="true" SelectedValue='<%# Bind("SupplierId") %>'>
[
UpdateCommandType="Text" UpdateCommand="UPDATE InvoicesDetails SET INVOICEDETAILID=INVOICEDETAILID WHERE 1=2"
DeleteCommandType="Text" DeleteCommand="DELETE FROM InvoicesDetails WHERE INVOICEDETAILID=@INVOICEDETAILID">
the code behind event handlers
Private Sub GridView2_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView2.PreRender
If Me.GridView2.EditIndex <> -1 Then
Dim C1 As Control = GridView2.Rows(Me.GridView2.EditIndex).FindControl("cmbSuppliers1")
Dim D1 As DropDownList = CType(C1, DropDownList)
Dim C2 As Control = GridView2.Rows(Me.GridView2.EditIndex).FindControl("cmbProducts1")
Dim D2 As DropDownList = CType(C2, DropDownList)
If Not D2 Is Nothing Then
Dim ds As DataSet
ds = New DB().SelectQuery("select ProductId, ProductName from cds.products WHERE SUPPLIERID = " + D1.SelectedValue.ToString)
D2.DataSource = ds.Tables(0)
D2.DataTextField = "ProductName"
D2.DataValueField = "ProductId"
D2.DataBind()
End If
End If
End Sub
Private Sub GridView2_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView2.RowUpdating
Dim C1 As Control = GridView2.Rows(e.RowIndex).FindControl("cmbSuppliers1")
Dim D1 As DropDownList = CType(C1, DropDownList)
Dim C2 As Control = GridView2.Rows(e.RowIndex).FindControl("cmbProducts1")
Dim D2 As DropDownList = CType(C2, DropDownList)
Try
Dim db As New DB
Dim id As String = CType(GridView2.Rows(e.RowIndex).Cells(1).Controls(0), TextBox).Text
Dim qty As String = CType(GridView2.Rows(e.RowIndex).Cells(3).Controls(0), TextBox).Text 'GridView2.Rows(e.RowIndex).Cells(2).Text
Dim price As String = CType(GridView2.Rows(e.RowIndex).Cells(4).Controls(0), TextBox).Text 'GridView2.Rows(e.RowIndex).Cells(3).Text
db.InvoicesDetailsEdit(id, D2.SelectedValue, qty, price)
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
This should get you going with this.
Enjoy IT!