|
Hi all
I have written a piece of code that retrives data from database table and does some operation with the retrived data.
Code:
Dim ensartRows As List(Of EnsartRow) = EnsartRow.GetDBRows(cad.parent, cad.enfant, GetConnectionStr())
For Each e In ensartRows
If Not e.MatchesDataLineOtherFields(cad) Then
WriteAddFromEA(cad, e)
End If
Next
That gets a list from the database for matching values in a text file.
Now I want to do an operation for all that is not in the list(for all that does not have a match in the text file).
eg: a FOR for for the non matched list with the text file.
How to accomplish this?
Thanks in Advance.
|
|
|
|
|
I'm not sure exactly what it is that you are trying to do. If the list you talk about is ensartRows, then you need to create another list with the items that aren't in ensartRows.
If you are talking about doing something for items that don't match the If condition, then add an Else block to take care of the others.
Otherwise, I just don't know what it is you are asking about.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Thanks for the reply.
How to create another list that arent in ensartRows?
Thanks in advance.
|
|
|
|
|
The same way you created the first one, but with other criteria. If it was an SQL query, change the WHERE clause to be opposite of what it was.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Thanks for the reply.
I will try it out.
|
|
|
|
|
Hi,
I want after printing on a location erase all graphics(lines, tekst, circles,...);
Write now I use comething like this:
e.Graphics.FillRectangle(Brushes.White, 300, 80, 220, 200)
Is there a beter solution to do something like this.
E.Graphics.clear clears everything.
Jan
|
|
|
|
|
Don't draw them in the first place??
If they are already on the "page", then you either have to draw those object exactly as before, only in white, or you have to do what you did here.
|
|
|
|
|
Thanks Dave,
I keep it this way. I clarify why.
I had a report and now I want to add something. I’m to lazy to add some condition do I print the old or new info. So If I want the new info. I clear the already printed info and write on top of the clear portion
Jan
|
|
|
|
|
That doesn't change the answer. I've already given you what your options are.
|
|
|
|
|
And I say thanks. I just have clearefy why I want it
|
|
|
|
|
If you're able to edit the code that renders the content you want to clear, perhaps you could adjust the clip rect before the 'content to be cleared' is drawn - thus in effect not drawing it (but leaving the paint method relatively unchanged)?
|
|
|
|
|
This looks interresting but how can I do something that?
It sounds like something like screen in the good old days of GW basic but I have never found this in VB.net
Jan
|
|
|
|
|
Hello ,
I want guidance for converting my excel work sheet to PDF using VB6.0
Parag
|
|
|
|
|
You can convert anything to PDF using PDFCreator[^] printer.
If you want to print from VB6 you will have to use the Windows API ShellExecute[^] function, passing the verb "print" to its lpOperation argument, but before you will have to make sure that PDFCreator printer is the default printer. You might want to have a look at this[^] to see how to manage the default printer.
|
|
|
|
|
Thanx Erik
But is there any other way for direct convertion from excel to pdf i got solution from text file to pdf but in text file i can't add images or tables. Please help
Parag
|
|
|
|
|
yes!
one possibility would be:
* buy an pdf library (or use one of the .net libraries an make them com visible)
* reference the Microsoft Office ... Object Library
* use it to open excel file
* create your pdf
another possibility could had been: use google with some keywords ... for example:
activex create pdf control vb6
and, if possible, throw away vb6. It´s from 1998 ...
|
|
|
|
|
I need an application that waits for a sound (beep or chime) to be detected in a speaker (maybe via Direct X and sound card). When sound is detected, I want code to be run , say for now, a Msgbox pops up and says "sound dete3cted"
Thanks,
Gary
|
|
|
|
|
Gary99 wrote: I want code
You sound like you're ordering a pizza 
AFAIK, Windows doesn't raise any events when sound is played. If you only need to "detect" sound, then you might want to google for a VU meter. That would still only react to a sound-card, not the internal speaker.
Or switch the microphone on, actively listening for sounds. That's probably not a practical solution, since it would also give you background-noise.
I are Troll 
|
|
|
|
|
Hi - No, it's not for pizza. I googled and was not able to find a simple way to detect sound. Would DirectX be a possibility ? I don;t know where to look for sample code.
Thanks,
Gary
|
|
|
|
|
Gary99 wrote: I don;t know where to look for sample code.
There's always the CodeProject articles[^] that provide sample code.
Do you want to detect a sound that you're making yourself, or from a third party?
I are Troll
|
|
|
|
|
Hi, thanks for your interest. I believe it's a third party. I get a pop up and bell or chime rings in external speaker. I want to know it happened if I am away from my PC. I think I can write a routine to text me on my cell phone via MS Outlook when a sound is detected. So i need a routine that I can add a call to my routine to send a text message.
Thanks,
Gary
|
|
|
|
|
Gary99 wrote: I get a pop up
It'd be easier to watch for the popup than to detect a sound; there's multiple ways of looking whats "on screen" from code, but I haven't seen a way to listen to what's currently playing.
I are Troll
|
|
|
|
|
Hi - I can't stay glued to PC. I want to be able to move around. I have working VB code that will send me an email when triggered. The problem is I don;t have the trigger (yet). Thanks,
Gary
|
|
|
|
|
Gary99 wrote: I can't stay glued to PC. I want to be able to move around.
That does not change my previous statements, as they are based on technical limitations.
Gary99 wrote: The problem is I don;t have the trigger (yet).
Windows doesn't pull a trigger when it's playing a sound, there's no notification-mechanism that could be described as "easy". Working your way through a VUmeter-example amd adapting that would be the easy route. The DirectX example only showed how to check if a sound is finished that you started yourself - that's not the same as intercepting a playsound-command from a third-party application.
So, now that we know that you can't stay glued to your PC, and that catching sound is hard - would it be an option to look for alternatives? Might become a bit frustrating, but that makes it more fun and rewarding when one finds a relevant solution.
You said it was a sound and a popup. What application raises the notification? The popup could perhaps be identified by enumerating all windows.
I are Troll
|
|
|
|
|
The pop up flashes for a few seconds and disappears on its own. I tried w/o success to use Enumwindows and look for window title. It was never detected. Any sample code to look for a particular window title from an application I can not control ? could the pop-up be a child window of the other application and i need different API to find it ? Thanks, Gary
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
