skip navigation
Telerik UI for ASP.NET AJAX
Product Bundles
DevCraft
All Telerik .NET tools and Kendo UI JavaScript components in one package. Now enhanced with:
NEW
: Design Kits for Figma
Online Training
Document Processing Library
Embedded Reporting for web and desktop
Web
Kendo UI
UI for jQuery
UI for Angular
UI for React
UI for Vue
UI for Blazor
UI for ASP.NET Core
UI for ASP.NET MVC
UI for ASP.NET AJAX
Mobile
UI for .NET MAUI
UI for Xamarin
Document Management
Telerik Document Processing
Desktop
UI for .NET MAUI
UI for WinUI
UI for WinForms
UI for WPF
Reporting
Telerik Reporting
Telerik Report Server
Testing & Mocking
Test Studio
Test Studio Dev Edition
Telerik JustMock
CMS
Sitefinity
UI/UX Tools
ThemeBuilder
Design System Kit
Templates and Building Blocks
Debugging
Fiddler
Fiddler Everywhere
Fiddler Classic
FiddlerCap
FiddlerCore
Free Tools
VB.NET to C# Converter
Testing Framework
View all products
Overview
Demos
Roadmap
What's New
Roadmap
Release History
Migrate to Blazor
Docs & Support
Support and Learning
Support and Learning Hub
Docs
Demos
Virtual Classroom
Forums
Videos
Blogs
Accessibility and Security
Submit a Ticket
Productivity and Design Tools
Visual Studio Extensions
ThemeBuilder
Embedded Reporting
Pricing
Shopping cart
Login
Contact Us
Try now
close mobile menu
Telerik Forums
/
UI for ASP.NET AJAX
This is a migrated thread and some comments may be shown as answers.
radgrid to datatable
1 Answer
1109 Views
Grid
This is a migrated thread and some comments may be shown as answers.
mohammad
Top achievements
Rank 1
mohammad
asked on
03 Mar 2009,
06:06 AM
Hello
How do i want to convert grid data after filtering to datatable?
How do i want to use datatable instead grid after filtering?
Add a comment
Submit comment
Cancel
1 Answer
, 1 is accepted
Sort by
Score
Date
0
Shinu
Top achievements
Rank 2
answered on
03 Mar 2009,
11:47 AM
Hi Mohammad,
You can store the DataTable that you using to bind the Grid to a ViewState. In a button click event you can clear the rows of the DataTable and add new rows according to the rows present in the Grid.
CS:
public
DataTable dt =
new
DataTable();
protected
void
RadGrid1_NeedDataSource(
object
source, GridNeedDataSourceEventArgs e)
{
string
connectionstring =
"Data Source=inc156; Initial Catalog=NorthWind;User ID=rt; Password=rt"
;
SqlConnection conn =
new
SqlConnection(connectionstring);
SqlCommand cmd =
new
SqlCommand();
conn.Open();
SqlDataAdapter adp1 =
new
SqlDataAdapter(
"select ProductID,ProductName from Products "
, conn);
adp1.Fill(dt);
RadGrid1.DataSource = dt;
ViewState[
"dt"
] = dt;
conn.Close();
}
protected
void
Button2_Click(
object
sender, EventArgs e)
{
DataTable dt = (DataTable)ViewState[
"dt"
];
dt.Rows.Clear();
foreach
(GridDataItem item
in
RadGrid1.MasterTableView.Items)
{
DataRow newRow = dt.NewRow();
foreach
(GridColumn col
in
RadGrid1.MasterTableView.RenderColumns)
{
if
(col.ColumnType ==
"GridBoundColumn"
)
{
string
unique = col.UniqueName;
newRow[unique] = item[unique].Text;
}
}
dt.Rows.Add(newRow);
}
RadGrid2.DataSource = dt;
RadGrid2.DataBind();
}
}
Regards
Shinu.
Add a comment
Submit comment
Cancel
Answer this question
Drag and drop files here or
browse
to attach...
Browse
for files to attach...
Supported file types: PNG, JPG, JPEG, ZIP, RAR, TXT. Max total file size - 20MB.
Submit answer
Cancel
Tags
Grid
Asked by
mohammad
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Share this question
or
Copy link