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 .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

Does this line: Update General_Info SET Name='" & custname & "' WHERE RID='" & resumeid update your database? e.g. does the query hit the table and update the column?

-------------------------
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

Yes, this line is working fine for my database.

Hi,

After you have updated your database, you need to reload the Data after the update, your datagrid still sees the old version of the data.

Refill the dataset then bind to the datagrid.

Have fun,
dynamicsuit

<i>Goin' Mad</i>