I have gridview
gridview.datasource=obj.find()
gridview.databind()
Public Function find(ByVal id As Integer) As DataTable
Dim cmd As New SqlCommand
Dim da As New SqlDataAdapter
Dim con As New SqlConnection(getcon())
Dim query As String = "select p.paym_Pipelineid,p.paym_PaymentsID,p.paym_value,p.paym_Date,p.paym_perc,i.plin_wonvalue from Payments p,Pipeline i Where p.paym_Pipelineid=i.plin_PipelineID and p.paym_Deleted is null and p.paym_Pipelineid= " & id
With cmd
.CommandType = CommandType.Text
.CommandText = query
.Connection = con
End With
da.SelectCommand = cmd
Dim dt As New DataTable
da.Fill(dt)
Return dt
End Function
in my update :
Public Sub update(ByVal datet As String, ByVal per As Integer, ByVal val As Integer, ByVal pid As Integer)
...
Go to the complete details ...