This is a migrated thread and some comments may be shown as answers.

Grid Filter

5 Answers 252 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Husam Al Madain
Top achievements
Rank 1
Husam Al Madain asked on 21 Apr 2010, 08:22 AM
I need to get only the filterd data from the grid to show it in a report
example: I have grid with 10 rows binded from data set then I have filtered the data, and now the grid is showing only 4 rows,
how can I get only these 4 rows?

thank you

5 Answers, 1 is accepted

Sort by
0
Julian Benkov
Telerik team
answered on 23 Apr 2010, 01:45 PM
Hello Husam Al Madain,

You can use the Rows collection of the RadGridView control for this scenario:

private void radButton1_Click(object sender, EventArgs e)
{
    BindingList<object> filteredRows = new BindingList<object>();
    foreach (GridViewDataRowInfo row in this.radGridView1.Rows)
    {
        filteredRows.Add(row.DataBoundItem);
    }
 
    //use filteredRows collection for your report...
}

Kind regards,
Julian Benkov
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
Husam Al Madain
Top achievements
Rank 1
answered on 28 Apr 2010, 10:24 AM

Thank you for your reply

But I need another help please

How can I convert the “filteredRows” to Datatable

Because the report can’t see the rows from the filteredRows
or

If you can tell me how to bind it to datatable I’ll be very thankful

0
Julian Benkov
Telerik team
answered on 30 Apr 2010, 05:51 PM
Hello Husam Al Madain,

Please send me a code snippet for your filtering operation and binding so that we can give you the best solution for your scenario (please copy the source code in your Form object). Thank you in advance.
 

Kind regards,
Julian Benkov
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
Husam Al Madain
Top achievements
Rank 1
answered on 02 May 2010, 07:47 AM
' Loading the Datagrid  
            Dim obj As New ClsSearch  
            Dim ds As DataSet  
            ds = obj.Load_Search(SP_Report)  
            If ds Is Nothing Then Exit Sub 
            RadGridView1.DataSource = ds.Tables(0)  
 
'after filtering from the grid filter area I need to get only the filtered data in it  
'and use it in a report source(as datatable or dataset)  
 
 
 
thank you for your cooperation
0
Julian Benkov
Telerik team
answered on 05 May 2010, 11:46 AM
Hello Husam Al Madain,

You can use this code snippet:

Dim reportTable As New DataTable()
For Each column As GridViewDataColumn In Me.radGridView1.Columns
    reportTable.Columns.Add(column.UniqueName, column.DataType)
Next
 
For Each row As GridViewDataRowInfo In Me.radGridView1.Rows
    Dim dataRow As DataRow = reportTable.NewRow()
   
    For Each dataColumn As DataColumn In reportTable.Columns
        dataRow(dataColumn) = row.Cells(dataColumn.ColumnName).Value
    Next
   
    reportTable.Rows.Add(dataRow)
Next
 
'reportTable usage...

Greetings,
Julian Benkov
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.
Tags
GridView
Asked by
Husam Al Madain
Top achievements
Rank 1
Answers by
Julian Benkov
Telerik team
Husam Al Madain
Top achievements
Rank 1
Share this question
or