Updating Data from a Datagrid

Hi All

I am trying to update data from a data grid and get this error, from the below code


I am lost ...an help here would be greatlly apprecaited...


rgs

Tony



Server Error in '/' Application.
--------------------------------------------------------------------------------

Specified argument was out of the range of valid values. Parameter name: index
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: index

Stack Trace:

Private Sub MyUpdateAction(Sender as Object, Args as DataGridCommandEventArgs)
        Status.Text="Updated"
        Dim strID, strEmail,strFirstName,strSurname,strcsm as String
        strID= MyGrid.DataKeys(Args.Item.ItemIndex)

        strFirstName=  CType(Args.Item.Cells(1).Controls(0),TextBox).Text
        strSurname= CType(Args.Item.Cells(2).Controls(0),TextBox).Text
        strEmail= Ctype(Args.Item.Cells(3).Controls(0),TextBox).Text
        strcsm= Ctype(Args.Item.Cells(4).Controls(0),TextBox).Text



''''''''''''''''''''''''''
Dim sqlCON as sqlconnection
dim sqlCMD as sqlcommand
dim strSQL as string = "Update tblContacts Set FirstName='" & strFirstName &"',Surname='" & strSurname &"',EmailAddress='" & strEmail &"',CSM='" & strcsm &"' where ID='" & strId &"'"


try
  sqlcon = new sqlconnection("server='sql2.redstation.co.uk'; user id='2128779.150'; password='CLT42876'; database='2128779.150'")
  sqlcon.open
 sqlcmd = new sqlcommand(strsql,sqlcon)

 sqlcmd.ExecuteNonQuery()


catch ex as sqlexception

catch ex as Exception

finally
sqlcmd.dispose
'if sqlcon = State.Open then
sqlcon.close
'end if
sqlcon.dispose

end Try



'''''''''''''''''''''''''''''







'open Connection and through  SqlCommand Update to the Database
Status.Text= strSql

        MyGrid.EditItemIndex= -1
        MyAddressBook(11)
        'MyGrid()
End Sub

[ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: index]
   System.Web.UI.ControlCollection.get_Item(Int32 index) +57
   ASP.contacts_aspx.MyUpdateAction(Object Sender, DataGridCommandEventArgs Args) +155
   System.Web.UI.WebControls.DataGrid.OnUpdateCommand(DataGridCommandEventArgs e) +83
   System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +499
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26
   System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +100
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26
   System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +95
   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +116
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138
   System.Web.UI.Page.ProcessRequestMain() +1263



Private Sub MyUpdateAction(Sender as Object, Args as DataGridCommandEventArgs)
        Status.Text="Updated"
        Dim strID, strEmail,strFirstName,strSurname,strcsm as String
        strID= MyGrid.DataKeys(Args.Item.ItemIndex)

        strFirstName=  CType(Args.Item.Cells(1).Controls(0),TextBox).Text
        strSurname= CType(Args.Item.Cells(2).Controls(0),TextBox).Text
        strEmail= Ctype(Args.Item.Cells(3).Controls(0),TextBox).Text
        strcsm= Ctype(Args.Item.Cells(4).Controls(0),TextBox).Text



''''''''''''''''''''''''''
Dim sqlCON as sqlconnection
dim sqlCMD as sqlcommand
dim strSQL as string = "Update tblContacts Set FirstName='" & strFirstName &"',Surname='" & strSurname &"',EmailAddress='" & strEmail &"',CSM='" & strcsm &"' where ID='" & strId &"'"


try
  sqlcon = new sqlconnection("server=xxx.xxxxxx.co.uk'; user id=xxxxxxxx.150'; password=xxxxxx; database=xxxxxxxx.150'")
  sqlcon.open
 sqlcmd = new sqlcommand(strsql,sqlcon)

 sqlcmd.ExecuteNonQuery()


catch ex as sqlexception

catch ex as Exception

finally
sqlcmd.dispose

sqlcon.close

sqlcon.dispose

end Try





 

<code/>



Start Free Trial