|
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!!
|
|
|
|
|
by this I meant the idea of using the Read() with a byte buffer.
Thanks again.
|
|
|
|
|
|
I have already gone through these articles you send me.
I was successfully able to create named pipe in c# both client and server and run them.
I was also able to do the same with visual C++ code.
The game plugin is written in visual c++, it outputs some real-time game data that I need. I have written named pipe client in visual c++ within the plugin which writes the data to the named pipe.
My problem is I have to process these data a lot for my final output, so it would make my life easier if I could access them through c# code. So I have programmed the server in C#
I can connect the client and server but c# code is not understanding the data which is in LPTSTR format visual c++ uses (well at least that is my guess). I guessed this because I wrote a server in visual c++ which could successfully access the data from the plugin.
Do you have any suggestions???
letiny
|
|
|
|
|
akhanal wrote: c# code is not understanding the data which is in LPTSTR
I had to do something fairly similar recently. What I did was I wrote a managed C++ dll that reads the data from the named pipe, converts the unmanaged strings to managed strings and then passes the managed strings on to the C# code.
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns
Help humanity, join the CodeProject grid computing team here
|
|
|
|
|
Hi all,
I'm trying to open a SQL Anywhere DB connection and setup a data reader with the data returned, only I keep getting the error:
'oConn.ServerVersion' threw an exception of type 'System.InvalidOperationException'
Here is my code:
string ConnString = "Data Source=***;UID=***;PWD=***";
SAConnection oConn = new SAConnection(ConnString);
oConn.Open();
string SQLStatement = "SELECT * FROM QAS.QAFISET WHERE MAINLVL='T' ORDER BY NAME";
SACommand command = new SACommand(SQLStatement, oConn);
SADataReader DRTest = command.ExecuteReader();
Any feedback would be greatful.
Thank you,
Mel
modified on Friday, July 24, 2009 2:25 PM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
