Forms Data Controls :: Using A GridView For Custom Reports
Jan 19, 2010
One part of the app I'm building enables the user to select from a range of reports (step 1) then select criteria (step 2). It then needs to pop the results onto the page and allow exporting to Excel/CSV (step 3).Step 2 isn't easy to do generically and there aren't that many reports to make it worthwhile for me to build a framework to do this at this point. The CSV export code is easy enough.For Step 3 I have in my mind a page such as DisplayReport.aspx?Report=ThisReport&Parameters=a,12,43,c or similar which builds a GridView on the page. At least that part can be generic. The complexity I see is in formatting the fields. I know I can build up the report consisting entirely of strings in the database and return it to the GridView all pre-prepared, but that really isn't what I was looking to do architecturally
I have to generate several simple reports using simple sql statements and present the result in a gridview. I would like the user to be able to select each report from a single drop downlist, once selected the report is viewable in the grid. Is it possible to have one single grid that can display multiple reports?...if so how? Also how can I select each report from a dropdownlist?
I have read your article from aspsnippets.com about custom paging it really work, but there are a problem that if there are more record in database (2000 to 5000) than number of page index will be goes in large number. like 1 to 200, any way which can divide it like 12345678910...2000.
As a part of requirement, I need to bind a table data to the Gridview, but the data content in the table is too large. I need not want to bring in all the data into the dataset, rather I need to bring only the rows that are needed to be displayed(Eg, if the page size is 10, i need only 10 records to be filled in dataset
I have a gridview control which contains aproximately 2,040 records of IP addresses. Right now I have setup my gridview control with the following options: AllowPaging="True" PageSize="255".
This has the effect of placing each IP range on its own page. So for instance 192.168.0.1-192.168.0.255 is on page 1, and 192.168.1.0-192.168.1-255 is on page 2 and so forth. The issue is that finding the IP range I want in the application is really a pain and I usually have to click page by page through the gridview to find the range I want to edit.
I'd like to have a custom paging and instead having pagination which says 1,2,3,4,5,6 etc had more meaningful labels like "192.168.0.x Range", "10.10.10.1 Range", "172.22.50.x range" and so forth. So that I can immediately jump to the page that I want. note that in most cases I need to browse the data not search for a specific element so creating a searchbox isn't neccessarily the answer. I just need more efficient paging.
I'm not really sure how to accomplish this. I've tried searching google for custom pagination + gridview etc and I'm not having much luck. Maybe I don't have the right combo of search terms.
Searching in the web, i found a lot post of how create gridview paging with DataPager, but all this solution used the default paging of datapager.How can i create a gridview with custom paging using DataPager?
Im pretty confused on this and would appreciate any suggestions.Im trying to implement custom paging because my database has some 400,000ish records and i want to show 20 at a time in a gridview. I don't want to use a datasource in the html because this gridview gets populated using a dataset in the .cs (c#) because the user first filters on params. I have two sp (on to get the total record count and one that filters). Both sp work.
[Code]....
and...
[Code]....
Does anyone know how i can tell my gridview (and if i need to implement a datapager) the total number of records, to get the page numbers on the bottom correct and then pass the parameter @PageNum @PageSize@sortExpression?
Is there any way to have the gridview page by categories instead of pages. In other words instead of at the bottom having some sort of page numbering scheme there would be categories from a specific column (kind of like a group by in sql) arranged along the bottom and when I would click one it would page to the start of all those matching rows (preferably return all of them rather than just say 10 or 20).
I am binding gridivew with custom datasource. I have 3 columns and I want two columns to be editable. right now grid showing the data but i want it to delete and update as well.
I am using ObjectDataSource controll to bind gridview and using custom paging. Everything working fine but the problem arises when last page contains only one record and i try to delete it-- gridview disappear.
Below is ObjectDataSource declaration..It is working fine..only problem is with deleting from last
I have been reading alot about this and for some reason I am just not able to grasp the concept. Hopefully someone here can enlighten me.As an example situation I have a collection of strongly typed User objects that represent a database table, and some properties that represent its columns: UserID(PK), Username,FirstName,LastName, etc..Here are some of my requirements/goals:1. Users/Objects needs to be bound to the gridview programatically.2. I do not want to update the database right away, I only want the underlying collection to be updated. I would like to call the database update method myself when I am ready. 3. I do not want the primary key stored on the client side.Summary:So I bind a List<Users> to a gridview with the appropriate bound fields set up, I exlude bound fields such as primary key because I don't want it being changed/hacked by the client side. When I edit and update a row it is saved back to the collection of objects. I will iterate through the objects manually at a later time and commit them to database.
Questions:1. Can I cast a gridview row directly back to my object, in the RowUpdating or RowUpdated events? I am assuming I can't... So....2. How can I reference back my original collection if the gridview does not contain a primary key?3. Where do I store my collection, should it be in Session or should I recreate it on each postback?Sorry if any of this is confusing, let me know if you need clarification.
i have a gridview with paging[index 10] enabled on my webpage, now i want a simple dropdownlist in footer or below gridview to have list of no 20,30,40.so that when user selects 20 from it the gridview shows 20 records on same page,when 30 is selected the gridview should show 30 records.i cant figure it out that how to do it, whether it requires coding at database(MYSql) or can be done at the page itself.
i would like to create custom columns in the GridView Control.For example:After performing SQL query, there are 4 columns bound to the control: 1. ID 2. Name 3. LA 4. LE
Now, for each row, I would like to add column5. Custom - which would read LA and LE values from each row, assign them to variables vLA and vLE respectfuly, and then, I'd take vLA and vLE to perform custom calculations every time the page is displayed.I know how to make a custom colum to display calculated result, butCan someone please help me how to read LA and LE values for each row?
I have a datarepeater inside which I load a gridview. After the grid's binding is done I create an extra header line to group the columns (that's the only way I could do it, I couldn't figure a way to add an event for a control inside the repeater).That works fine and the page displays perfectly.However everytime I do a postback from other controls, I lose the 2nd header and 1 extra empty line appears at the top of the gridview
I want to validate a GridView row only if the checkbox is selected.
My page contains a gridview and 1 button, I have used custome template for few fields in GridView. All fields are currently validated using requiredfield validator.
The validation workd fine when I click the button, but now I want custome validation, means only the rows which are selected shoud be validated.
I am trying to hook up custom pagination with an ObjectDataSource to my GridView. However, this thing renders no data, but does render the column headers. The debugger clearly indicates a populated DataTable being returned.