|
Kiotaya wrote: The tables represent the different rooms in the house. The items in each room fill the cells in the table.
Why do you need a different table for each room ?
Kiotaya wrote: The problem I am having is that there are several databases(houses), each in their own directory
Your approach seems broken. Why not have a houses table and a rooms table ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Im sorry, I should have explained the name "House" is an example. The actual database name is "Merchant". How do I switch from Access database in folder A to Access database in folder B?
|
|
|
|
|
change your connection string or create a new connection to the other database
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thank you for your response but neither of these options are practicle. I need to be able to programaticlly switch from one database to another.
|
|
|
|
|
Kiotaya wrote: neither of these options are practicle
How on earth do you expect to change the database if you won't change/create another connection.
Create a connection to database A called connA
use it to do something
create another connection to database B called connB
use it to do something in the other database.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
That will not work. I need to know how to switch between databases programatically. All the databases have the same name and tables. Also I may be adding more merchants in the future. I do not want to have to go back and recompile the code everytime I add another merchant.
I would appreciate it of someone could help me with this or point me in the direction of an article that may help answer this.
Thanks
Kio
|
|
|
|
|
You can't have one connection to many databases. (At least with Access.)
Having multiple connections is a way to do this programatically.
How about a Dictionary of connections?
Otherwise you'll need to explain what you need more clearly.
|
|
|
|
|
Thanks but I figured it out myself.
-You can't have one connection to many databases. (At least with Access.)-
-How about a Dictionary of connections?-
-Otherwise you'll need to explain what you need more clearly.-
By using the "xxx.exe.config" file you can change the directory your connection is pointing to. This way I do not have to recompile code everytime I want to add a merchant.
|
|
|
|
|
What so you are going to add a new merchant to your config file every time you expand your base. Your design sucks (sticking with a good CP theme) you need to take a look at the design of your entire solution.
I wrote the above and then sat back and thought maybe it works for you, I'm glad you found a solution although it is not one I would use.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Well why didn't you say that's what you wanted to do in the first place?! 
|
|
|
|
|
Hi,
I use reportviewer to display reports in a small application some years ago.
I've implemented it "quick and dirty" and now it's time to clean up 
I have seen many samples and walkthroughs but haven't found any that uses untyped dataset or a separate datalayer. One of the things is that I want to avoid adding separate datasets and end up having many .xsd files in my solution.
At this point I'am thinking to try to get everything in a seperated libary and add this to my project. This gives me (I hope) the opportunity to edit the reports and re-add them to my application by overwriting a simple dll at the moment I want.
Is there someone who know a good walkthrough or can give me some sample code to do this.... or can tell me that it's a stuppid idea and knows a beter way to do this.
thanks
|
|
|
|
|
We've all seen applications that display a tray icon, which may or may not redraw itself after killing explorer.exe and then restarting it...the app's still running, but it's not aware that explorer got restarted and so its tray icon is missing...
What's the "clean" way of getting a C# app to look for this so it can take appropriate action? Does Windows broadcast some sort of "shell restarting" notification?
|
|
|
|
|
Hi,
I'm not aware of such explorer events, nor have I ever protected an app against explorer restarts. Here is an idea that might help you:
- on app start, get explorer process ID.
- periodically check it, and on a change, remove your NotifyIcon, then add a new one.
Are you sure this is worth it?
FYI: I wrote an article on stray tray icons once. You could use those techniques to check the presence of (exactly) one NotifyIcon for your app.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Luc Pattyn wrote: - on app start, get explorer process ID.
It's not unusual for me to have multiple instances of explorer.exe running. Unless I can determine which one is drawing the taskbar/systray, a list of explorer.exe process IDs wouldn't tell me much
Luc Pattyn wrote: - periodically check it, and on a change, remove your NotifyIcon, then add a new one.
Yeah...the whole reason I inquired about a notification message is that I'd rather avoid polling...seems like such a waste.
Luc Pattyn wrote: Are you sure this is worth it?
Well, if my app is minimized, the only way you can interact with it is through its tray icon...so, if it disappears, pretty much the only thing you can do is kill it in Task Manager and restart it... 
Luc Pattyn wrote: FYI: I wrote an article on stray tray icons once. You could use those techniques to check the presence of (exactly) one NotifyIcon for your app.
Thanks, I'll check it out.
|
|
|
|
|
Not sure about the rest, but unless something changed in Vista/Weven, explorer.exe seems to only run one process, no matter how many instances you have up.
|
|
|
|
|
Ummm...no. I can have multiple instances of explorer.exe showing up in Task Manager, in the Processes tab, each with its own process ID. That's always been the case as far as I can remember.
|
|
|
|
|
Hmm, ok, your system works differently than mine... When I open a new windows explorer, or even do a Start, Run, explorer.exe, it puts it all in the same process.
|
|
|
|
|
Now that I think of it, this is probably due to the fact that I always check the "launch folder windows in a new process" option (Tools, Folder Options).
|
|
|
|
|
hi,
i am trying to access data through named pipes. Data is written in the named pipe from a plugin(written in unmanaged C++);client pipe;. I wanted to make the whole application more easy to handle so I am trying to use C#;server pipe; to take in the data from the named pipe for further processing.
My problem is I can get the client and server connected, but the C# code has hard time reading the data from the named pipe. The c++ code writes the data in the named pipe in LPTSTR format.
the data is basically real-time data from a gaming application.
Any suggestions on how to make the data accessible from the c# code, or on using any other medium besides named pipes to communicate the data between the two application will be highly appreciated.
thanks
letiny
|
|
|
|
|
Are you saying you are putting unmanaged text pointers into the pipe?
if so I guess you will need some kind of Marshal.PtrToString method, something I hope will never happen to me. I tend to get all objects created by managed code, and then pass their pointers to the primitive side for production/consumption.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
the plugin uses WriteFile() function to write in the named pipe. The WriteFile() function takes in the data param in LPTSTR format.
i am using sr.ReadLine() method in the C# code where sr is as follows.
i.e.;
NamedPipeServerStream pipeServer = new new NamedPipeServerStream(.....);
StreamReader sr = new StreamReader(pipeServer);
sr.ReadLine();
|
|
|
|
|
P.S.
I have already tried Marshal but could not find an option. I tried it again, when i use Marshal.PtrToStringUni(sr.ReadLine()), it gives me an error:
-->Error 2 The best overloaded method match for 'System.Runtime.InteropServices.Marshal.PtrToStringUni(System.IntPtr)' has some invalid arguments
-->Error 3 Argument '1': cannot convert from 'string' to 'System.IntPtr'
therefore I am guessing it is not a pointer.
The LPTSTR format is defined as zero-terminated string of TCHAR (TCHAR*) here[^]
|
|
|
|
|
Have you tried reading the bytes manually? ReadLine() returns a string, but Read() with a byte buffer might give you more to work with...
Chances are, if that works, you're going to see one of two things in the buffer:
1) A lot of data = Probably your raw data. You might have to strip out a trailing zero, then do an Encoding.ASCII.GetString()
2) Only a few bytes... That's your pointer... Extract the right number of bytes (4 for a 32-bit system, 8 for a 64-bit - Can probably get that from the framework)... Turn it into an IntPtr and try marshalling it (Or is that unmarshalling?)
Either way, get the data in a buffer so you know what you're dealing with.
|
|
|
|
|
Exactly, look at the raw data, and try and recognize it.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
This looks promising
I will definitely try this and let you know.
Thank you all of you guys for your suggestions!!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
