Hi. Over the weekend I was referred to Telerik as a solution for various controls that I need for a website that I'm developing. So far I am impressed but I am having some difficult with the RadGrid control. I will try to briefly summarise the problems and I would also greatly appreciate some guidance on how to do a couple of specific things (to save me a lot of learning time).
First I have looked at the demos. When I view the demo (link below) and set a filter criteria of ProductId = 1) the grid still displays 300,000 records but they appear to all be identical copies of the same record. Similar if I put a filter of (([Product Name] = "ch") and ([unit price] = 18)) then again the grid control says that it has 300,000 records but they appear to be a repeative set of two records (for productId 1 and 39). Is this a bug/correct?
http://demos.telerik.com/aspnet-ajax/grid/examples/performance/linq/defaultcs.aspx
I tried to get the RadGrid control working yesterday in a simple form. However, I was using an Access database and so an asp:accessdatasource control was create for the data source. However, I couldn't get it to work. I eventually switched to an SQLdatasource with exactly the same definition (including parameter definition) and it worked fine. Is this a bug/incompatibility between the RadGrid and asp:AccessDataSource?
When using the RadGrid with a datasource, the CRUD commands are defined in the datasource. However, they appear to work with or without the corresponding parameter definitions? Can anyone explain?
OK Those are the comments about my experience so far. I have two questions both of which are important for my development:
1. If I have CRUD functionality on a grid can I pre-populate a new record with values and how do I do this? For example, a table may have a field [DateCreated] which I want to set to the date that the record was created. How can I do this within the grid?
2. I want a table with a guid primary key field and then 3 text fields ([Title], {Description], [Content]). The Title and Description I want to edit with simple text boxes but the Content I want to create and edit with RadEditor. Is there an example that shows how to do this?
Many thanks
First I have looked at the demos. When I view the demo (link below) and set a filter criteria of ProductId = 1) the grid still displays 300,000 records but they appear to all be identical copies of the same record. Similar if I put a filter of (([Product Name] = "ch") and ([unit price] = 18)) then again the grid control says that it has 300,000 records but they appear to be a repeative set of two records (for productId 1 and 39). Is this a bug/correct?
http://demos.telerik.com/aspnet-ajax/grid/examples/performance/linq/defaultcs.aspx
I tried to get the RadGrid control working yesterday in a simple form. However, I was using an Access database and so an asp:accessdatasource control was create for the data source. However, I couldn't get it to work. I eventually switched to an SQLdatasource with exactly the same definition (including parameter definition) and it worked fine. Is this a bug/incompatibility between the RadGrid and asp:AccessDataSource?
When using the RadGrid with a datasource, the CRUD commands are defined in the datasource. However, they appear to work with or without the corresponding parameter definitions? Can anyone explain?
OK Those are the comments about my experience so far. I have two questions both of which are important for my development:
1. If I have CRUD functionality on a grid can I pre-populate a new record with values and how do I do this? For example, a table may have a field [DateCreated] which I want to set to the date that the record was created. How can I do this within the grid?
2. I want a table with a guid primary key field and then 3 text fields ([Title], {Description], [Content]). The Title and Description I want to edit with simple text boxes but the Content I want to create and edit with RadEditor. Is there an example that shows how to do this?
Many thanks
1 Answer, 1 is accepted
0
Hello Paul,
Straight to your questions:
The reason for the same records is that we multiplicated the records of a smaller table in order to create a large one with 300 000+ records. As for the item count, it seems the virtual item count is not properly updated. We will take a closer look at the demo and will improve it.
There should be no problem binding your RadGrid to an AccessDataSource. You can see a sample configuration in this help article which also gives an example of how the data source should be set up in order for RadGrid to be able to perform its automatic datasource operations.
You can see how you can set predefined values for a new item in RadGrid in this help article (the Setting predefined values for different column editors section).
In regard of the edit form that you need to get, you can take a look at this online demo demonstrating a functionality similar to your requirements.
Greetings,
Tsvetina
the Telerik team
Straight to your questions:
The reason for the same records is that we multiplicated the records of a smaller table in order to create a large one with 300 000+ records. As for the item count, it seems the virtual item count is not properly updated. We will take a closer look at the demo and will improve it.
There should be no problem binding your RadGrid to an AccessDataSource. You can see a sample configuration in this help article which also gives an example of how the data source should be set up in order for RadGrid to be able to perform its automatic datasource operations.
You can see how you can set predefined values for a new item in RadGrid in this help article (the Setting predefined values for different column editors section).
In regard of the edit form that you need to get, you can take a look at this online demo demonstrating a functionality similar to your requirements.
Greetings,
Tsvetina
the Telerik team
Browse the vast support resources we have to jumpstart your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.