GridView paging using CommandBar

Requirements
RadControls version	2010.3 10.1215+
.NET version	3.5 SP1
Visual Studio version	2008
programming language	C# and VB

PROJECT DESCRIPTION
This is a very basic example on how paging could be achieved using the telerik grid and the command bar.

I know it has a lot of things and features missing, but if more people would be interested in this i will be more than happy to continue working on this.

I have to mention that in this version i have used the grid's internal mechanism for calculating the number visible rows to calculate the maximum number of rows to be displayed.

Please feel free to share all of your toughs and ideas :)



Navigation:


Sorting:
 
Filtering:


Best Regards,
Emanuel Varga
Telerik WinForms MVP

Hello Emanuel,

Thank you for providing this code library project. I believe that our community will be very happy with your implementation. May be providing a VB version of this project will make it easier for the part of the community which uses Visual Basic.

Thank you for your cooperation.
 
Best wishes,
Stefan
the Telerik team

I Would use also a Data Reader, Can I??? If Yes in which way. Can you explane me. I am a new user of telerik win form.
Regards
Robybas

Hi Robybas,

Your question does not seem directly related to this thread. If it is not, please avoid mixing different topics in the one thread and open new thread for questions that were not discussed.

Please refer to this documentation article which demonstrates how to populate your grid from DataReader: http://www.telerik.com/help/winforms/gridview-populating-with-data-binding-to-datareader.html.

I hope this helps.
 
All the best,
Stefan
the Telerik team

Ok thanks.
I've another question for you.
Could I Export all element of my radGridview?
For useful I create a paging on my RadGridView(because the Item displayed are 19000), but when I export the data (in Csv and in Xml), the system Export me only 20 elements(the elements per page). I know is correct, but I need to export all the element.
Could you help me:
Follow I attach the try-catch code for the export:

 try
            {
                 //Export Per File XLS
 
                ExportToExcelML exporterXLS = new ExportToExcelML(newGridView);
                
                exporterXLS.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.ExportAlways;
                exporterXLS.ExportVisualSettings = true;
                exporterXLS.SheetMaxRows = ExcelMaxRows._1048576;
                exporterXLS.SheetName = "Sheet";
                exporterXLS.SummariesExportOption = SummariesOption.DoNotExport;
                string fileNameXLS = "ExportXLS_" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss");
                exporterXLS.RunExport(fileNameXLS);
                
                //Export Per dati CSV
                ExportToCSV exporterCSV = new ExportToCSV(newGridView);
 
                exporterCSV.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.ExportAlways;
                exporterCSV.SummariesExportOption = SummariesOption.DoNotExport;
                string fileNameCSV = "ExportCSV_" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss");
                exporterCSV.RunExport(fileNameCSV);
 
                MessageBox.Show("Esportazione Dati Riuscita Correttamente", "Avviso", MessageBoxButtons.OK); 
            }
            catch (Exception Ex)
            {
                MessageBox.Show("Errore, Esportazione Dati Non Avvenuta, Problema Dovuto al Seguente Errore:  " + Ex.Message, "Attenzione", MessageBoxButtons.OK); 
            
            }

Hello Robybas,

Thank you for writing back.

You can create a RadGridView in memory without the paging functionality, set its data source and assign it as the grid to export. This will export all the data in your data source. Here is an example:

I hope this will be useful. Should you have further questions, I would be glad to help.
 
Regards,
Ivan Petrov
the Telerik team

Yesssss, you're great...It's Ok now!!!!
Bye
Robybas

Hi,
I have one question here,
will the filter apply on entire datasource or it will be applied only on the visible rows.
i.e when user types "emp" in the filter it will search in the entire datasource or only the visible rows?

regards
tom