<telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" runat="server" Skin="Lime" GridLines="None" AllowPaging="True"AllowSorting="True" AutoGenerateColumns="False" Width="97%" OnUpdateCommand="RadGrid1_UpdateCommand"><PagerStyle Mode="NextPrevAndNumeric"></PagerStyle><MasterTableView DataKeyNames="EmployeeID" GridLines="None" Width="100%" CommandItemDisplay="Top"><Columns><telerik:GridBoundColumn DataField="EmployeeID" HeaderText="EmployeeID" UniqueName="EmployeeID"ReadOnly="True"></telerik:GridBoundColumn><telerik:GridBoundColumn DataField="LastName" HeaderText="LastName" UniqueName="LastName"></telerik:GridBoundColumn><telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName" UniqueName="FirstName"></telerik:GridBoundColumn><telerik:GridBoundColumn DataField="Title" HeaderText="Title" UniqueName="Title"></telerik:GridBoundColumn><telerik:GridBoundColumn DataField="Address" HeaderText="Address" UniqueName="Address"></telerik:GridBoundColumn><telerik:GridBoundColumn DataField="City" HeaderText="City" UniqueName="City"></telerik:GridBoundColumn><telerik:GridEditCommandColumn></telerik:GridEditCommandColumn></Columns><EditFormSettings CaptionDataField="EmployeeID"><FormTableItemStyle Wrap="False"></FormTableItemStyle><FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle><FormMainTableStyle CellSpacing="0" CellPadding="3" Width="100%" /><FormTableStyle GridLines="Horizontal" CellSpacing="0" CellPadding="2" CssClass="module"Height="110px" Width="100%" /><FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle><FormStyle Width="100%" BackColor="#EEF2EA"></FormStyle><EditColumn UpdateText="Update record" UniqueName="EditCommandColumn1" CancelText="Cancel edit"></EditColumn><FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditFormButtonRow"></FormTableButtonRowStyle></EditFormSettings><ExpandCollapseColumn Visible="False"><HeaderStyle Width="19px"></HeaderStyle></ExpandCollapseColumn><RowIndicatorColumn Visible="False"><HeaderStyle Width="20px" /></RowIndicatorColumn></MasterTableView></telerik:RadGrid>
VB Code-
Public Shared dtTable As DataTable
'Get the connectionstring from the webconfig and declare a global SqlConnection "SqlConnection"
Public Shared connectionString As String = ConfigurationManager.AppSettings("ConnectionString")
Public SqlConnection As New SqlConnection(connectionString)
'Declare a global SqlDataAdapter SqlDataAdapter
Public SqlDataAdapter As New SqlDataAdapter()
'Declare a global SqlCommand SqlCommand
Public SqlCommand As New SqlCommand()
Protected Sub RadGrid1_UpdateCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs)
'Get the GridEditableItem of the RadGrid
Dim editedItem As GridEditableItem = TryCast(e.Item, GridEditableItem)
'Get the primary key value using the DataKeyValue.
Dim EmployeeID As String = editedItem.OwnerTableView.DataKeyValues(editedItem.ItemIndex)("EmployeeID").ToString()
'Access the textbox from the edit form template and store the values in string variables.
Dim LastName As String = (TryCast(editedItem("LastName").Controls(0), TextBox)).Text
Dim FirstName As String = (TryCast(editedItem("FirstName").Controls(0), TextBox)).Text
Dim Title As String = (TryCast(editedItem("Title").Controls(0), TextBox)).Text
Dim Address As String = (TryCast(editedItem("Address").Controls(0), TextBox)).Text
Dim City As String = (TryCast(editedItem("City").Controls(0), TextBox)).Text
Try
'Open the SqlConnection
SqlConnection.Open()
'Update Query to update the Datatable
Dim updateQuery As String = "UPDATE Employees set LastName='" & LastName & "',FirstName='" & FirstName & "',Title='" & Title & "',Address='" & Address & "',City='" & City & "' where EmployeeID='" & EmployeeID & "'"
SqlCommand.CommandText = updateQuery
SqlCommand.Connection = SqlConnection
SqlCommand.ExecuteNonQuery()
'Close the SqlConnection
SqlConnection.Close()
Catch ex As Exception
RadGrid1.Controls.Add(New LiteralControl("Unable to update Employee. Reason: " + ex.Message))
e.Canceled = True
End Try
End Sub
I am using above code but getting error like specified arguement out of range of valid values parameter name :index