Databases
StackOverflow2013
Postsdbo
POCode Behind Update Command in RadGrid Telerik (help)
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCode Behind Update Command in RadGrid Telerik (help)
    text
    copied!<p>Greetings Everyone </p> <p>I am new in asp.net and i'm using RadControls for Asp.net Ajax now. I tried to follow the Asp.Net GridDemo - Insert/Update/Delete and it seems to be not all working pretty fine with me so i did few changes and turned out to be somehow doing well but the update button still not working...</p> <p>I have this 2 tables tblUser and tblRole</p> <p>In my Radgrid i only wanted to display the <strong>user_id</strong>,<strong>last_name</strong> and <strong>first_name</strong> from my <strong>tblUser</strong> and <strong>role</strong> from my <strong>tblRole</strong> </p> <p>And in my Edit Form The only editable region is the last_name,first_name and role but when i hit the update Button it doesn't work.. -_-,</p> <p>I'm already ok with the designs the only problem is my update button is not working..</p> <p>Here's my code </p> <h2>TeacherRole.aspx</h2> <pre><code> &lt;telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1" GridLines="None" Skin="Black" DataKeyNames="user_id" EditMode="PopUp" AllowAutomaticUpdates="True" ShowGroupPanel="True" GroupPanel-ID = "RadAjaxLoadingPanel1"&gt; &lt;MasterTableView EditMode="PopUp" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames = "user_id"&gt; &lt;Columns&gt; &lt;telerik:GridBoundColumn DataField="user_id" DataType="System.Int32" HeaderText="User ID" SortExpression="user_id" UniqueName="user_id"&gt; &lt;/telerik:GridBoundColumn&gt; &lt;telerik:GridBoundColumn DataField="last_name" HeaderText="Last Name" SortExpression="last_name" UniqueName="last_name"&gt; &lt;/telerik:GridBoundColumn&gt; &lt;telerik:GridBoundColumn DataField="first_name" HeaderText="First Name" SortExpression="first_name" UniqueName="first_name"&gt; &lt;/telerik:GridBoundColumn&gt; &lt;telerik:GridBoundColumn DataField="role" HeaderText="Role" SortExpression="role" UniqueName="role"&gt; &lt;/telerik:GridBoundColumn&gt; &lt;/Columns&gt; &lt;EditFormSettings InsertCaption="Add new item" CaptionFormatString="Edit User ID: {0}" CaptionDataField="user_id" EditFormType="Template" PopUpSettings-Modal="True" PopUpSettings-ScrollBars="Auto"&gt; &lt;FormTemplate&gt; &lt;table id="Table1" cellspacing="1" cellpadding="1" width="250" border="0"&gt; &lt;tr&gt; &lt;td&gt; User ID: &lt;/td&gt; &lt;td&gt; &lt;asp:label id="Message1" runat="server" text='&lt;%# Bind( "user_id" ) %&gt;'/&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Last Name: &lt;/td&gt; &lt;td&gt; &lt;asp:TextBox ID="TextBox1" runat="server" Text='&lt;%# Bind( "last_name" ) %&gt;'&gt; &lt;/asp:TextBox&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; First Name: &lt;/td&gt; &lt;td&gt; &lt;asp:TextBox ID="TextBox2" runat="server" Text='&lt;%# Bind( "first_name") %&gt;' TabIndex="1"&gt; &lt;/asp:TextBox&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Role: &lt;/td&gt; &lt;td&gt; &lt;asp:DropDownList ID="DropDownList1" runat="server" SelectedValue='&lt;%# Bind("role") %&gt;' DataSource='&lt;%# (new string() { "Admin", "Teacher", "Student"}) %&gt;' TabIndex="7" AppendDataBoundItems="True"&gt; &lt;asp:ListItem Selected="True" Text="Select" Value=""&gt;&lt;/asp:ListItem&gt; &lt;/asp:DropDownList&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;table style="width: 100%"&gt; &lt;tr&gt; &lt;td align="right" colspan="2"&gt; &lt;asp:Button ID="Button1" Text='&lt;%# Iif (TypeOf Container is GridEditFormInsertItem, "Insert", "Update") %&gt;' runat="server" CommandName='&lt;%# Iif (TypeOf Container is GridEditFormInsertItem, "PerformInsert", "Update") %&gt;'&gt; &lt;/asp:Button&gt;&amp;nbsp; &lt;asp:Button ID="Button2" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel"&gt; &lt;/asp:Button&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/FormTemplate&gt; &lt;PopUpSettings ScrollBars="Auto" Modal="True"&gt;&lt;/PopUpSettings&gt; &lt;/EditFormSettings&gt; &lt;/MasterTableView&gt; &lt;ClientSettings AllowDragToGroup="True"&gt; &lt;Scrolling AllowScroll="True" UseStaticHeaders="True" /&gt; &lt;ClientEvents OnRowDblClick="RowDblClick" /&gt; &lt;/ClientSettings&gt; &lt;/telerik:RadGrid&gt; &lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="&lt;%$ ConnectionStrings:ProLearnConnectionString %&gt;" SelectCommand="SELECT tblUser.user_id, tblUser.last_name, tblUser.first_name, tblRole.role FROM tblUser INNER JOIN tblRole ON tblUser.role_id = tblRole.role_id ORDER BY tblUser.user_id" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [tblUser] SET [last_name] = ?, [first_name] = ? WHERE [user_id] = ? "&gt; &lt;UpdateParameters&gt; &lt;asp:Parameter Name="last_name" Type="String" /&gt; &lt;asp:Parameter Name="first_name" Type="String" /&gt; &lt;asp:Parameter Name="original_user_id" Type="Int32" /&gt; &lt;/UpdateParameters&gt; &lt;/asp:SqlDataSource&gt; </code></pre> <p>And this if my code in </p> <h2>TeacherRole.aspx.vb</h2> <pre><code>Imports Telerik.Web.UI Partial Class Admin_TeacherRole Inherits System.Web.UI.Page Private Sub RadGrid1_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadGrid1.PreRender If Not IsPostBack Then For Each item As GridItem In RadGrid1.MasterTableView.Items If TypeOf item Is GridEditableItem Then Dim editableItem As GridEditableItem = CType(item, GridDataItem) editableItem.Edit = True End If Next End If End Sub Protected Sub RadGrid1_UpdateCommand(ByVal source As Object, ByVal e As GridCommandEventArgs) If e.CommandName = RadGrid.UpdateCommandName Then If TypeOf e.Item Is GridEditFormItem Then Dim item As GridEditFormItem = DirectCast(e.Item, GridEditFormItem) Dim id As Integer = Convert.ToInt32(item.GetDataKeyValue("user_id")) If id &lt;&gt; 0 Then Dim txtlastname As TextBox = DirectCast(item.FindControl("TextBox1"), TextBox) Dim txtfirstname As TextBox = DirectCast(item.FindControl("TextBox5"), TextBox) End If End If End If End Sub End Class </code></pre> <p>Any advise and suggestion would be highly sought .. Have a nice day.. Thanks in Advance </p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload