Hi Frnds,
    I am trying to edit and update one field of my datagrid. But it is not updating at all.
I am sending my HTML code as well as .VB code. Can you please help me regarding this problem?

Here is my CODE:
======================

Imports System.Data
Imports System.Data.SqlClient


Public Class WebForm1
    Inherits System.Web.UI.Page
    Protected WithEvents resumedisplay As System.Web.UI.WebControls.DataGrid
    Protected WithEvents editresume As System.Web.UI.WebControls.DataGrid

    Sub BindDataGrid()
        Dim myconn As SqlConnection
        Dim mycmd As SqlDataAdapter
        Dim myds As DataSet

        myconn = New SqlConnection("Server=xyz;user id=sa;password=none;database=myDB")
        myconn.Open()
        mycmd = New SqlDataAdapter("Query1", myconn)
        myds = New DataSet()
        mycmd.Fill(myds, "Query1")
        resumedisplay.DataSource = myds.Tables("Query1").DefaultView
        resumedisplay.DataBind()
        mycmd.Dispose()
        myconn.Close()

    End Sub

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        BindDataGrid()
    End Sub

    Sub EditRecord(ByVal Src As Object, ByVal Args As DataGridCommandEventArgs)
        resumedisplay.EditItemIndex = Args.Item.ItemIndex
        BindDataGrid()
    End Sub

    Sub UpdateRecord(ByVal Src As Object, ByVal Args As DataGridCommandEventArgs)
        Dim sqlConn As SqlConnection
        Dim sqlCmd As SqlCommand
        Dim sqlString, sqlString2 As String
        Dim resumeid As Integer


        resumeid = resumedisplay.DataKeys(Args.Item.ItemIndex)
        Dim custname = CType(Args.Item.Cells(1).Controls(0), TextBox).Text
        sqlString = "Update General_Info SET Name='" & custname & "' WHERE RID='" & resumeid & "'"
        sqlConn = New SqlConnection("Server=xyz;user id=sa;password=none;database=myDB")
        sqlConn.Open()
        sqlString = "Update General_Info SET Name='" & custname & "' WHERE RID='" & resumeid & "' "

        sqlCmd = New SqlCommand(sqlString, sqlConn)
        sqlCmd.ExecuteNonQuery()
        sqlConn.Close()

        resumedisplay.EditItemIndex = -1
        BindDataGrid()
    End Sub

    Sub CancelRecoed(ByVal Src As Object, ByVal Args As DataGridCommandEventArgs)
        resumedisplay.EditItemIndex = -1
        BindDataGrid()
    End Sub


End Class

Dont cross post.

http://p2p.wrox.com/topic.asp?TOPIC_ID=54421

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

seems fine to me.Add a label to ur page (Lets say LblMsg)
        Try
              'add the code to update_record here and compile the program
              'if its not showing then there must be an error.Check the text in the label and reply back
              LblMsg.visible=false
        Catch ex As Exception
              LblMsg.visible=true
              LblMsg.text=ex.Message
        End Try

Hi RoniR,

          Thanks for your reply. I tried your suggested solution. But I couldn't find any exception. Please help me...I am in big trouble..

Waiting for your response.

Actually what happening is, when i'm updating any field (for example-from Prasanta to RoniR) it is not effecting on the variable . I have tested this using one label. Is there any way to resolve this? It will be very helpful if you send me one example(small) code.

I think the problem is in this line :
Dim custname = CType(Args.Item.Cells(1).Controls(0), TextBox).Text

Change this line to :
Dim custtextbox as textbox = CType(Args.Item.Cells(1).Controls(0), TextBox)
Dim custname as string = custtextbox.Text

Hope it will solve your problem.

 Hi Gaurav,

           I tried with your suggested solution. But it did not work. I am totally confused...Can you please send me a small sample code???

Waiting for ur response.

Thanks guys...

I have solved my problem.