|
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,
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.
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
User will choose columns from these tables. so we need to list all columns in each table.
|
|
|
|
|
Hi,everyone! I want to insert an image into an Excel sheet,I know I could insert an file on disk into Excel sheet using these codes:
xlWorkSheet.Shapes.AddPicture("C:\xl_pic.JPG", _
Microsoft.Office.Core.MsoTriState.msoFalse, _
Microsoft.Office.Core.MsoTriState.msoCTrue, 50, 50, 300, 45)
But I don't know how can I insert an image of Project Resources.resx File ,could anyone give me some suggestion or help ? Thanks a lot !
|
|
|
|
|
You can't import a resx file as an image. It's not in any image format and certainly not in a format that Excel understands.
You have to extract the image yourself and use the method you used before or a variant of it.
|
|
|
|
|
I've got it! Thank you, Dave!
|
|
|
|
|
Hi,
How do you select multi items in a listbox?
I have a listbox with say the following values
A, B, C, D, E, F
I want to select and then display the items I selected e.g. C, E, F
It has been a while since I done VB development and I am a wee bit rusty. Due to staff cutbacks.
Thanks in advance.
|
|
|
|
|
directred wrote: How do you select multi items in a listbox?
There's an excellent example on MSDN[^]
I are Troll 
|
|
|
|
|
I have the multi selection on.
What I want to display is the actual items selected to be used in another procedure e.g. if b then etc
Almost like assigning the selected items to a variable.
Hope this makes sense???
|
|
|
|
|
|
By reading up on the members of the ListBox class, you're bound to find what you need.
If I'm guessing right from what you wrote, it could be this[^].
|
|
|
|
|
the SelectionMode property needs your attention.
|
|
|
|
|
Hello !
i'm using CDO to send email from my visual basic application.Everything is ok when i send emails to yahoo etc, i have problems only when i send emails to hotmail.com addreses.These emails are never received , are lost.
What can i do ?
Thank you in advance.
|
|
|
|
|
Hotmail tends to class a lot of E-Mails as spam, could it be that the E-Mails are being moved to the "Junk" folder?
"People demand freedom of speech to make up for the freedom of thought which they avoid."
|
|
|
|
|
thank you !
But the emails are lost , i check both inbox and Junk folder but i can't find them.If i try to send emails with the same configuration (smtp , user , password...) from outlook express the emails are received instantly on hotmail inbox.
so , i think is possible to create a cdo email with the same header as outlook express email?
|
|
|
|
|
is there any way to get active internet connections through WMI classes including the executabels which are connected ....
|
|
|
|
|
|
Accurate, but terse.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
See here[^].
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
My latest tip/trick
Visit the Hindi forum here.
|
|
|
|
|
HOW COULD I MAKE A TEXTBOX IN vB A FULL ip fIELD ,WHICH CHECKS THE FORMAT OF THE IP AND DOES NOT ACCEPT INVALID IP ADDRESS
|
|
|
|
|
Was it really necessary to use all capital letters and bold type?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
