Jeremy Yoder
Top achievements
Rank 1
Rank 1
Jeremy Yoder
asked on 12 Apr 2010, 10:15 PM
I created a RadGrid with predefined columns. At first when I ran the webpage, the grid was blank, not even showing the headers. But by creating a blank dataset in a Session variable and assigning it to the RadGrid, I get it to display. However, the "Add Record", "Edit", and "Delete" buttons don't work.
The online demos are all bound to a datasource, but we don't want that. How can the RadGrid work with a dataset in memory? I want the MasterTableView to load and display values, which I'll save later, all at once. My dummy HTML and code-behind are below...
| <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %> |
| <%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %> |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml"> |
| <head runat="server"> |
| <title></title> |
| </head> |
| <body> |
| <form id="form1" runat="server"> |
| <div> |
| <asp:ScriptManager ID="ScriptManager1" runat="server"> |
| </asp:ScriptManager> |
| <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" GridLines="None" |
| AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True"> |
| <HeaderContextMenu EnableAutoScroll="True"> |
| </HeaderContextMenu> |
| <MasterTableView CommandItemDisplay="Top"> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridBoundColumn DataField="Col1" HeaderText="Col1" UniqueName="Col1" SortExpression="Col1"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Col2" HeaderText="Col2" UniqueName="Col2" SortExpression="Col2"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| </MasterTableView> |
| </telerik:RadGrid> |
| </div> |
| </form> |
| </body> |
| </html> |
| Imports System.Data |
| Partial Class _Default |
| Inherits System.Web.UI.Page |
| Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load |
| If Not IsPostBack Then |
| Dim ds As New DataSet |
| Dim dt As New DataTable |
| dt.Columns.Add("Col1") |
| dt.Columns.Add("Col2") |
| ' Create dummy rows to delete/edit |
| Dim vals(1) As String |
| vals = New String() {"100", "Desc100"} |
| dt.Rows.Add(vals) |
| vals = New String() {"200", "Desc200"} |
| dt.Rows.Add(vals) |
| ds.Tables.Add(dt) |
| Session("myDS") = ds |
| RadGrid1.DataSource = Session("myDS") |
| RadGrid1.MasterTableView.DataSource = Session("myDS") |
| End If |
| End Sub |
| End Class |
7 Answers, 1 is accepted
0
Hi Jeremy,
To make sure that your setup works as expected, you can use the NeedDataSource event handler, and pass the session datasource there.
Setting the datasource for the grid anywhere else, or calling databind directly, will break its default functionalities.
Greetings,
Yavor
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
To make sure that your setup works as expected, you can use the NeedDataSource event handler, and pass the session datasource there.
Setting the datasource for the grid anywhere else, or calling databind directly, will break its default functionalities.
Greetings,
Yavor
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Jeremy Yoder
Top achievements
Rank 1
Rank 1
answered on 23 Apr 2010, 09:07 PM
Thanks for the response. I changed my code to use NeedDatasource, and turned on the 3 "AllowAutomatic..." options, but the Insert/Delete/Edit functions aren't working. What am I missing? I've been poking around the site, but I can't find an example working with a dataset like I'm doing. My updated code is below...
| <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %> |
| <%@ Register TagPrefix="telerik" Namespace="Telerik.QuickStart" %> |
| <%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %> |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml"> |
| <head runat="server"> |
| <title></title> |
| </head> |
| <body> |
| <form id="form1" runat="server"> |
| <div> |
| <asp:ScriptManager ID="ScriptManager1" runat="server"> |
| </asp:ScriptManager> |
| <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" GridLines="None" |
| AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" |
| AllowAutomaticDeletes="True" AllowAutomaticInserts="True" |
| AllowAutomaticUpdates="True"> |
| <HeaderContextMenu EnableAutoScroll="True"> |
| </HeaderContextMenu> |
| <MasterTableView CommandItemDisplay="Top"> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridBoundColumn DataField="Col1" HeaderText="Col1" UniqueName="Col1" SortExpression="Col1"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Col2" HeaderText="Col2" UniqueName="Col2" SortExpression="Col2"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| </MasterTableView> |
| </telerik:RadGrid> |
| </div> |
| </form> |
| </body> |
| </html> |
| Imports System.Data |
| Partial Class _Default |
| Inherits System.Web.UI.Page |
| Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load |
| If Not IsPostBack Then |
| Dim ds As New DataSet |
| Dim dt As New DataTable |
| dt.Columns.Add("Col1") |
| dt.Columns.Add("Col2") |
| ' Create dummy rows to delete/edit/insert |
| Dim vals(1) As String |
| vals = New String() {"100", "Desc100"} |
| dt.Rows.Add(vals) |
| vals = New String() {"200", "Desc200"} |
| dt.Rows.Add(vals) |
| ds.Tables.Add(dt) |
| Session("myDS") = ds |
| End If |
| End Sub |
| Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource |
| RadGrid1.DataSource = Session("myDS") |
| End Sub |
| End Class |
0
Hi Jeremy,
To use automatic operations, you will need to employ a Datasource control, such as AccessDataSource, or SQLDataSource.
If you want to use NeedDataSource, you will need to manually handle the CRUD operations, as shown in this article:
http://www.telerik.com/help/aspnet-ajax/grdupdatinginplaceandeditforms.html
I hope this information helps.
Regards,
Yavor
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
To use automatic operations, you will need to employ a Datasource control, such as AccessDataSource, or SQLDataSource.
If you want to use NeedDataSource, you will need to manually handle the CRUD operations, as shown in this article:
http://www.telerik.com/help/aspnet-ajax/grdupdatinginplaceandeditforms.html
I hope this information helps.
Regards,
Yavor
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Jeremy Yoder
Top achievements
Rank 1
Rank 1
answered on 29 Apr 2010, 08:16 PM
Thanks for the link. I got both the 2nd and 3rd options to work. Is either method more recommended than the other?
However, in both cases, when I click "Edit", "Update", "Add Record", "Insert", or "Cancel", the page refreshes. That makes sense for Insert, Delete, and Update, given the server-side code I've added. But I'd rather do all these client-side. How can that be done now that I'm manually adding CRUD operations via NeedDataSource?
But let me back up the truck a bit and give you a big picture of what we want to see if I'm even going about this right...
We want a grid to do all CRUD operations to a datable in memory (either in a session variable or on the RadGrid's data -- whichever is doable) without any PostBacks. Below the grid, we'll have save and cancel buttons. Both will do a Postback to either save all changes or reload the original datatable. (I don't know if it makes a difference, but we later want comboboxes and search buttons for some columns.)
So are my examples above on the right track, or am I way off since the code you pointed me to is all server-side? Is what I'm asking for even possible with the RadGrid? Thanks.
0
Hello Jeremy,
In such a setup, avoiding a postback is not possible.
You can use client side databinding for the control, as shown in this example:
http://demos.telerik.com/aspnet-ajax/grid/examples/client/insertupdatedelete/defaultcs.aspx
the inserts/updates/deletes are handled with an outside editform, because of which no postback is required.
I hope this information helps.
Kind regards,
Yavor
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
In such a setup, avoiding a postback is not possible.
You can use client side databinding for the control, as shown in this example:
http://demos.telerik.com/aspnet-ajax/grid/examples/client/insertupdatedelete/defaultcs.aspx
the inserts/updates/deletes are handled with an outside editform, because of which no postback is required.
I hope this information helps.
Kind regards,
Yavor
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Jeremy Yoder
Top achievements
Rank 1
Rank 1
answered on 04 May 2010, 10:13 PM
It seems the answers to my latest questions were easier than expected. None of your online examples refreshed the page, so I didn't understand how your server code for the CRUD functions ran. Then I discovered your RadAjaxManager, which selects which controls post back. Once I understood that, the rest made sense.
Do you have some type of tutorial I should go through that tells how to link all your various controls together? Otherwise, I had never stumbled across that control, and I feel like I should have known about it somewhere along the way.
Also, could you answer my initial question in the previous post, which was, "I got both the 2nd and 3rd options to work. Is either method more recommended than the other?" Thanks.
0
Hello Jeremy,
To make the most of our products, I recommend that you examine the Step-by-step Tutorial – RadControls for ASP.NET AJAX.
For the Insert/Update/Delete operations techniques: you can use the one you prefer, they all implement the same functionality.
Regards,
Mira
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
To make the most of our products, I recommend that you examine the Step-by-step Tutorial – RadControls for ASP.NET AJAX.
For the Insert/Update/Delete operations techniques: you can use the one you prefer, they all implement the same functionality.
Regards,
Mira
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.