Datagrid Editing--UpdateCommand NotWorking ..

[siddu]

While i am Updating MyDataGrid Data it is not Updating and Even it is not Displaying any Error..

Sub MyDataGrid_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs ) Handles MyDataGrid.UpdateCommand
Dim conn As SqlConnection
Dim MyCommand As SqlCommand
Dim strConn As String = "Data source=B4-2F-128-HTB2\SQLSVR; user id=sa; password=; Database=New_Cart"
Dim txtQty As TextBox = e.Item.Cells(3).Controls(0)
Dim strUpdateStmt As String
strUpdateStmt = " UPDATE backup_ProductDetails SET Qty =@Qty " & _
" WHERE Pcode = @pcode"

conn = New SqlConnection(strConn)
MyCommand = New SqlCommand(strUpdateStmt, conn)
MyCommand.Parameters.Add(New SqlParameter("@Qty", txtQty.Text))
MyCommand.Parameters.Add(New SqlParameter("@Pcode", e.Item.Cells(1).Text))
conn.Open()
MyCommand.ExecuteNonQuery()
MyDataGrid.EditItemIndex = -1
conn.Close()
BindData()
End Sub

EveryThing Connection and Binding Data is Working Fine but i don't know where i have done small Mistake

[shashikanta]

Create a command builder object
Using that execute your Querry.