Visual Basic

6-Jul-10 1:13

Hi everybody,

I'd like to make a little application to handle 3rd party gauges. These are basically C/C++ dlls, so it seems that I have to find out their entry points and members first. One major thing would be to simply show the bitmaps, which they provide for the GUI in the game (MSFS), inside my application.

Does anyone know a way how to do something like retrieving member and resource information from an unknown dll in VB.NET (or C#)?

Thank you
Michael

ddecoy6-Jul-10 1:33

ddecoy

6-Jul-10 1:33

depends.exe
oleview.exe

Sonhospa6-Jul-10 2:38

6-Jul-10 2:38

Thank you, I'll go google for these tools.

Dave Kreskowiak6-Jul-10 1:48

Dave Kreskowiak

6-Jul-10 1:48

For the uninitiated, that's Dependancy Walker[^].

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Sonhospa6-Jul-10 2:30

Excel to XML Conversion using VBA

6-Jul-10 2:30

This seems to be a really cool tool for the initiated Wink | ;)

... giving me what I asked for and showing me how far I am from "making a little application" with display support.

At least the dlls in question obviously don't expose any bitmaps, but only "ImportTable" and "Linkage" functions which both belong to a world of C-language and the 7 seals...

Thank you still!

priyaahh5-Jul-10 18:55

priyaahh

5-Jul-10 18:55

Hi Friends,

I wanted to convert excel sheet data to xml using VBA.
Kindly help me.

Thanks in advance.

Regards,
Priya.

Re: Excel to XML Conversion using VBA

_Damian S_5-Jul-10 19:03

_Damian S_

5-Jul-10 19:03

A quick search found this article clickety[^]

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!!

If you like cars, check out the Booger Mobile blog | If you feel generous - make a donation to Camp Quality!!

How can I take the most recent record from a table?

waner michaud5-Jul-10 9:53

Re: How can I take the most recent record from a table?

5-Jul-10 9:53

Hi,

I have this table

Accessories table
(ID, description, date, ArmoryID, ProfileID)

with these records:

1 belt 05/01/2010 1 1
2 hoslter 05/02/2010 2 1
3 charger 05/03/2010 3 1

I need to take the most recent record for profile 1

to have as result: (3 charger 05/03/2010 2 1)

I tried a number of querries, can't seem to get the right answer.

Please guide me through it..

Thanks a lot..

EliottA5-Jul-10 10:51

EliottA

5-Jul-10 10:51

Select count(*) from Accessories, the result is 3, then select * from Accessories where ID = result

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Re: How can I take the most recent record from a table?

waner michaud5-Jul-10 11:20

Re: How can I take the most recent record from a table? [modified]

5-Jul-10 11:20

Hi thanks, but we will not know what the result is..
One profiler can have more than one accessories as of in history archive.
but to check to see if a profiler has an accessorie, it should load based on the most recent date since we can have more than one accessories entries for one profiler.

Hope a bit clearer now.

thanks a lot

Dr.Walt Fair, PE5-Jul-10 11:18

Dr.Walt Fair, PE

5-Jul-10 11:18

SELECT * FROM Accessories ORDER BY date DESC;, then use the first returned record.

By the way, using "date" for a column name is a very bad idea, since it is a reserved word for a data type in most SQL dialects. I always use "order_date" or some other variation to make sure the SQL engine doesn't think you are using a reserved word. Sooner or later that problem will bite you.

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

modified on Monday, July 5, 2010 5:24 PM

Re: How can I take the most recent record from a table?

waner michaud5-Jul-10 11:31

Re: How can I take the most recent record from a table?

5-Jul-10 11:31

Hi,
Thanks.

I have used a variation for date..again thaks for the info..
I thought of doing it this way..wasn't sure if it was the right approaoch..

thanks..

Dave Kreskowiak5-Jul-10 18:16

Dave Kreskowiak

5-Jul-10 18:16

Instead of returning the entire ordered set, how about returning SELECT TOP 1 ... ORDER BY date DESC instead?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: How can I take the most recent record from a table?

Dr.Walt Fair, PE6-Jul-10 3:55

Dr.Walt Fair, PE

6-Jul-10 3:55

Yes, you're right. When I need to do that, I usually end up needing more info, so I usually just get the whole set, but if he really needs just 1 and only 1, selecting TOP 1 is the way to go.

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

Re: How can I take the most recent record from a table?

riced6-Jul-10 6:47

riced

6-Jul-10 6:47

Question: Is it possible to have two (or more) entries with the same date?
If so, then sorting on date descending and selecting first one (e.g. by using top) is not guaranteed to get you the most recent entry.
If the ID field is autogenerated then perhaps the max of that is a better candidate?

Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.

Re: How can I take the most recent record from a table?

waner michaud6-Jul-10 7:06

MDI Parent and Child issues

6-Jul-10 7:06

Hi,
the answer to your question is YES.

But not good in setting up candidate..in my case can u walk me through it so I can adapt myself..

Thanks.

Simon_Whale5-Jul-10 0:21

Simon_Whale

5-Jul-10 0:21

I have an MDI Application that I am developing using Visual Basic 2008

One of the forms that the application calls in inside a DLL. This works great

Imports articleSearch

Dim frm As New DocumentSearch("Broker", Me)
frm.MdiParent = Me
frm.Show()

My problem is that form spawn another form from the DLL depending on the user action i.e. documents to view.

For Each dgRow As DataGridViewRow In DataGridView1.SelectedRows
 'MessageBox.Show(dgRow.Cells(3).Value)
 Dim frm As New PDFViewer(Trim(dgRow.Cells(3).Value))
 frm.MdiParent = _CallingApp
 frm.Show()
Next

now if i use the frm.mdiparent = _CallingApp (where _callingApp is a reference to the form being called) then the form display is blank but if i omit that line it works as expected, but it is no longer a child window of the mdi app

any pointers?

Thanks
Simon

As barmey as a sack of badgers

Re: MDI Parent and Child issues

Tom Deketelaere5-Jul-10 2:12

Tom Deketelaere

5-Jul-10 2:12

Simon_Whale wrote:
where _callingApp is a reference to the form being called

What do you mean with the 'form being called'?

I would either put a reference to the MDI form in a class and use that one.
Or just use me.parentform instead of _CallingApp

Re: MDI Parent and Child issues

Simon_Whale5-Jul-10 2:29

Simon_Whale

5-Jul-10 2:29

Sorry Tom,

In my App I have the main exe and a DLL.

In the DLL I have 2 forms a document search form and a PDF viewer.

each of these forms are called by the main App (MDI parent)

I can call the document search and that works ok, but then the user clicks on docs to view and click on the view selected button. But I want to get the PDF viewer as a page in the MDI Application, if I set the parent no document shows (just a blank screen). If i ignore the mdiparent setting it works as expected but the user gets 1 to many pdf's open.

My question is how can I get the PDF viewer screen to show up inside the MDI Application only.

As barmey as a sack of badgers

Re: MDI Parent and Child issues

Tom Deketelaere5-Jul-10 3:01

Tom Deketelaere

5-Jul-10 3:01

To get it to open inside the mdi application you have to set the mdiparent of the form.

So either the _CallingApp reference is wrong (not a reference to the mdi parent form or something in your pdf viewer is going wrong when called into a mdi container.

Is it the right approach to speed up the copy process?

Sonhospa3-Jul-10 12:33

Re: Is it the right approach to speed up the copy process?

3-Jul-10 12:33

Hi all,

one of the tasks in my application is copying several thousand large picture files (12 MB). In order to make this perform to the maximum I tried to parallelize the copy process using the ThreadPool, so that every file is copied in a new thread if available. The idea behind was that, on the target system - which is equipped with several RAIDs - this might result in a remarkable performance gain.

On my development computer I have only 2 harddisks and also don't have the necessary amount of files available, so I simulated the copy process by using a dummy (thread.sleep(200) instead of copy). This worked fine, and it seemed like hundreds of files would copy within seconds while using up to 9 threads. On the other hand, a final test on my development system, without the dummy but with much lesser files, didn't result in any performance gain at all. WTF | :WTF:

Since I don't have a lot of experience there's the doubt arising if the basic approach is correct and worth following, so that - before implementing everything on the target system - I wish to get some more experienced advice on that. Does this concept make sense at all so that it would be worth the effort, or am I on a wrong track? Btw I have to stay with .NET2.0 and can't use any of the VS2010 parallelism options... and I'm working with the VS2008 Express Version only.

Thanks for some guiding thoughts
Michael

riced3-Jul-10 19:42

riced

3-Jul-10 19:42

Off the top of my head I'm not sure having so many threads buys you anything - unless you have several thousand processors each running one of them. Smile | :)

It looks to me that the main bottle neck will be the I/O performance rather than the CPU. So many threads is not likely to help.
Furthermore, each thread will come at a cost - there's the creation but also the cost of switching when a thread's time slice expires.
However, this is guesswork and there's no substitute for performance testing. Big Grin | :-D

Re: Is it the right approach to speed up the copy process?

Sonhospa4-Jul-10 0:03