better way to collect large amount of data from vb.net 2005
-
Dear all, In my program using vb.net, it involves a lots of data (about 300), when generate report, we don't need to list all, so user need to choose from these data for output to report. These 300 data is divided into 30 table, I am look for a better way to organize these data. At first I am thinking create an excel file that list all these data, one in a row, and next to the data create a checkbox, protect all except the checkbox, so when user click "Select Output List", I will launch the excel, let user select data, save and close it, then from my program I will read the selection from excel file, but the clients don't like it. They don't want extra file. they want everything is inside the VB form. I am new to VB.net, is there better way let me handle this issue? Thanks!
-
Dear all, In my program using vb.net, it involves a lots of data (about 300), when generate report, we don't need to list all, so user need to choose from these data for output to report. These 300 data is divided into 30 table, I am look for a better way to organize these data. At first I am thinking create an excel file that list all these data, one in a row, and next to the data create a checkbox, protect all except the checkbox, so when user click "Select Output List", I will launch the excel, let user select data, save and close it, then from my program I will read the selection from excel file, but the clients don't like it. They don't want extra file. they want everything is inside the VB form. I am new to VB.net, is there better way let me handle this issue? Thanks!
why would you need an external program to do part of the overall job? can't you just show the data and the checkboxes on a Form (maybe using a DataGridView, a ListBox, or whatever Control you like), let the user select the data items, and proceed? :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
-
why would you need an external program to do part of the overall job? can't you just show the data and the checkboxes on a Form (maybe using a DataGridView, a ListBox, or whatever Control you like), let the user select the data items, and proceed? :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
Luc, Thank you for your quick reply. I have 30 tables, If I use DataGridView to display them, can I merge some rows to make it looks like that the data is grouped by talbe? and also did you mean put all the 300 data in a DataGridView with a scrollbar? I also think about this, but I thought it's too crowded. Can you give me more explaination? Thanks!
-
Luc, Thank you for your quick reply. I have 30 tables, If I use DataGridView to display them, can I merge some rows to make it looks like that the data is grouped by talbe? and also did you mean put all the 300 data in a DataGridView with a scrollbar? I also think about this, but I thought it's too crowded. Can you give me more explaination? Thanks!
Does the data have logical groupings like Contact Info, Employment History, Certifications, etc ? You could then use the Tabbed interface to create tabs on your form which would display the logically grouped items.
-
Does the data have logical groupings like Contact Info, Employment History, Certifications, etc ? You could then use the Tabbed interface to create tabs on your form which would display the logically grouped items.
Yes, they are grouped by functionality. But there are 30 tables, if use tab, they should occupy at least 3 rows, it looks not good, right?
-
Luc, Thank you for your quick reply. I have 30 tables, If I use DataGridView to display them, can I merge some rows to make it looks like that the data is grouped by talbe? and also did you mean put all the 300 data in a DataGridView with a scrollbar? I also think about this, but I thought it's too crowded. Can you give me more explaination? Thanks!
I cannot decide what it is you want, you should, or your customer. Does the user need to see the content of a table in order to decide he wants to include it in the report? or is it just choosing tables from their table names? etc. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
-
I cannot decide what it is you want, you should, or your customer. Does the user need to see the content of a table in order to decide he wants to include it in the report? or is it just choosing tables from their table names? etc. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
User will choose columns from these tables. so we need to list all columns in each table.