Iam using the follwing function to update records using gridview but the value fetched during process is not updated one instead its featching the older values
Protected Sub Namelist_RowUpdating(sender As Object, e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles Namelist.RowUpdating
Dim strcon As String = ConfigurationManager.ConnectionStrings("QnetConnection").ConnectionString
Dim SrNo As Integer = DirectCast(Namelist.Rows(e.RowIndex) _
.FindControl("lbSrNo"), Label).Text
Dim Name As String = DirectCast(Namelist.Rows(e.RowIndex) _
.FindControl("txtName"), TextBox).Text
Dim Mobile As String = DirectCast(Namelist.Rows(e.RowIndex) _
.FindControl("txtMobile"), TextBox).Text
Dim Relation As String = DirectCast(Namelist.Rows(e.RowIndex) _
.FindControl("txtRelation"), TextBox).Text
Dim KnownFrom As String = DirectCast(Namelist.Rows(e.RowIndex) _
.FindControl("txtKnownFrom"), TextBox).Text
Dim City As String = DirectCast(Namelist.Rows(e.RowIndex) _
.FindControl("txtCity"), TextBox).Text
Dim Category As String = DirectCast(Namelist.Rows(e.RowIndex) _
.FindControl("txtCategory"), TextBox).Text
Dim BridgeUp As String = DirectCast(Namelist.Rows(e.RowIndex) _
.FindControl("txtBridgeUp"), TextBox).Text
Dim Invite As String = DirectCast(Namelist.Rows(e.RowIndex) _
.FindControl("txtInvite"), TextBox).Text
Dim Presentation As String = DirectCast(Namelist.Rows(e.RowIndex) _
.FindControl("txtPresentation"), TextBox).Text
Dim Result As String = DirectCast(Namelist.Rows(e.RowIndex) _
.FindControl("txtResult"), TextBox).Text
Dim con As New SqlConnection(strcon)
Dim cmd As New SqlCommand()
cmd.CommandType = CommandType.Text
cmd.CommandText = "update NameList set Name=@Name,Mobile=@Mobile,Relation=@Relation,KnownFrom=@KnownFrom," _
& "City=@City,Category=@Category,BridgeUp=@BridgeUp,Invite=@Invite,Presentation=@Presentation,Result=@Result where SrNo = @SrNo;"
cmd.Parameters.AddWithValue("@SrNo", SrNo)
cmd.Parameters.AddWithValue("@Name", Name)
cmd.Parameters.AddWithValue("@Mobile", Mobile)
cmd.Parameters.AddWithValue("@Relation", Relation)
cmd.Parameters.AddWithValue("@KnownFrom", KnownFrom)
cmd.Parameters.AddWithValue("@City", City)
cmd.Parameters.AddWithValue("@Category", Category)
cmd.Parameters.AddWithValue("@BridgeUp", BridgeUp)
cmd.Parameters.AddWithValue("@Invite", Invite)
cmd.Parameters.AddWithValue("@Presentation", Presentation)
cmd.Parameters.AddWithValue("@Result", Result)
con.Open()
cmd.Connection = con
cmd.ExecuteNonQuery()
cmd.Connection = con
Namelist.EditIndex = -1
BindData()
End Sub
