Member Avatar for jssupekar

i want to know how to take input from user using DBGrid

  • 2 Contributors
  • 1 Reply
  • 127 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by aktharshaik
Member Avatar for aktharshaik

Many events, methods and properties are defined to handle DataGrid. what have u tried at first. make a beginning first.

i am giving a small code for AfterColUpdate Event Example

This example does a lookup when one column is updated and places the result in another column.

Private Sub DataGrid1_AfterColUpdate (ColIndex As Integer)
If ColIndex = 1 Then
Data1.Recordset.FindFirst "PubId = " _
& DataGrid1.Columns(1).Value
If Not Data1.Recordset.NoMatch Then
DataGrid1.Columns(2).Value = _
Data1.Recordset.Fields("Publisher")
Else
DataGrid1.Columns(2).Value = "No Match"
End If
End If
End Sub

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.