Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use DataGrid to display simple Excel Table?

Status
Not open for further replies.

Fherrera

Technical User
May 11, 2004
129
CA
Hi everyone,

(does this apply to this forum??)

I'm starting to use VB.NET i figured it wouldn't be such a bad transition after all the VBA in Excel and a some in Access i've been doing. But i'm getting stuck with all these components available.

Two questions:

1) To display a simple table in excel, one where there is a header on the top (2 headers actually) and the first column is filled with 1,2,3,4,5 numbers that I do not want to let the user change. Other than the top 2 rows and first column the rest of the table i'd like to let the user edit. Is datagrid the component to use? I was also looking at this "SourceGrid: C# grid control" from which seems cool. I can use a C# control in VB.net right?

2) I want to be able to display 3 tables in a tab control panel. Except, i'd like to have the title of each shown and a little expand button to the left of each so when i click expand the rest of the table will show and the rest of the tables will be pushed down. (same kind of tables as listed above) What is the easiest way to achieve this? is there another control for this kind of thing or will I have to program some event triggers to show the table and change the height properties appropriately of the other tables? There would be a few cases to take care of if that was the only way :<

Any help would be great!! Thank you.

Frank
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top