PC Review


Reply
Thread Tools Rate Thread

Grid/spreadsheet control that binds to a System.Data.Dataset (multi-Datatable)and automagically creates multiple sheets

 
 
TR
Guest
Posts: n/a
 
      20th Dec 2007
I am looking for a control where I can do this:

TheControl.DataSource = MyDataSet

and then the control will automagically create a grid/spreadhsheet for
each Datatable in the MyDataset.Tables collection, and present a tabbed
interface something like Excel's Sheet1, Sheet2, Sheet3 bottom tabs.
The contents of each "sheet" would correspond to MyDataset.Tables(0),
MyDataSet.Tables(1), and so on.


The DataTables would have different schemas -- different column names,
datatypes, different number of columns.

Does such a control exist?

Thanks in advance.
 
Reply With Quote
 
 
 
 
Marc Greiner
Guest
Posts: n/a
 
      20th Dec 2007
Hi TR,

I am not aware of such a control that does implement a tab with a grid in each tab (all grids I know do bind to one table or list of objects).

However, with some third party controls, you can achieve this result with few effort and line of code.

Some grids can autogenerate the columns of the bound table and allow direct edition with the proper editor (date, text, numeric, etc.).

www.devexpress.com is one of them.

Regards,
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating multiple sheets and populating data in it from two diffrent dataset hemant.basvapattan Microsoft Excel Misc 0 2nd Sep 2008 12:44 PM
custom control with multiple data binds =?Utf-8?B?Y29kb2hlcnR5?= Microsoft Dot NET 6 7th Jul 2006 03:39 PM
Editing data in grid, creates duplicate record =?Utf-8?B?QW50b25pbw==?= Microsoft Dot NET 0 9th Jun 2006 03:37 PM
Transfer Dataset / DataTable / Datareader Info to Excel Spreadsheet L Anthony Johnson Microsoft ADO .NET 1 12th Nov 2004 01:41 PM
fill dataset/grid with multiple queries from multiple servers Dave Edwards Microsoft VB .NET 4 20th Jul 2004 11:49 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:53 PM.