The database option would be fine with me. I think that the text file that my application will be supplied with will be updated only once a day and my application is used throughout the day with only 1 or 2 log in events per 8 hour shift, so if I retrieve the information from the database only on log in, I should be OK.
Another question I have, though, is how to optimize retrieving the information from the text file. I would need some sort of BULK INSERT utility with MS Access. I know SQL Server has a BULK INSERT command, but unfortunately I do not have the luxury of using SQL Server at present. Is there a way to get the same functionality from Access?
Thanks, Luc. Yes, I understand that, but "my application" is not truly my application. I work for a company and they decide what database gets used. So, for now I'm stuck making this work with MS Access and need a solution using MS Access.
I also think that you should try sql server 2005.
Store your text files in the database and build some good search store procedures.
With C#,Trigger the SP on an event and display it in a datagridview object.
IMHO using a database is overkill for this application. A simple hash table will do the job easier and faster than a database.
1. Create a hash table with size around 120,000 (prime numbers work best).
2. Read (key, value) pairs from the text file and insert them into the hash table.
3. While you probably can't read and process a text file that size in under a second, you can retrieve an entry from the hash table in less than a hundredth of a second.
Thank you. That was the answer I needed. I have implemented the hash table into the application and it does the trick. The application I'm working with is well established and this particular feature, which happens to be a search for a serial number based on a bar code value, is a specific request by one customer. I can't redo the application simply to fit one customer need, and so I wanted something that works with the existing application architecture, which you have provided.
if you mean to reset the controls to its a default value for a property i.e Text you may follow this step
1. create list to buffer a property value for each controls in your form
2. get property value back to controls according its index
In .NET 3.+ WPF, spell-checking is built into either the textbox, richtextbox, or both. As for other capabilities their are a few articles on this site that can assist you. Do a quick search.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
I need to call a business logic class via web servicing without using reflection. I pass the class name and method as string parameters in the web service. But it doesn't work the conversion from string to an object.
If I pass the object class then it works but I don't want to do that as the webservice must run independently
The code I use is,
public object ExecuteMethod(string ClassName, string MethodName, params object arguments)
object obj = null;
Type type = Type.GetType(ClassName);
In searching for a solution to my problem below (http://www.codeproject.com/script/Forums/View.aspx?fid=1649&msg=2645163[^]) about stopping the MS dialog boxes in the WebBrowser control, I've discovered that the IWebBrowser2 interface has a property called Silent that seems to fit the bill. WebBrowser doesn't seem to implement IWebBrowser2 out of the box and embarrassingly, my COM background is in C++ rather than C# so I find myself fumbling a bit.
I'm hoping it's only minor rocket science to derive a new WebBrowser control & implement this interface so that I can get to the Silent property. All I'm using the browser control for is to navigate to a site & then save off an image capture of it to a jpeg. Everything is working fine, but I'm getting hammered by MS messages boxes complaining of scripting errors, unknown publishers, etc. (and I've tried all the browser control properties and IE options to no avail). I'm hoping Silent works as advertised.
Apologies for such a newbie question, but a little guidance in this area from the more experienced hands would be most appreciated. What's the quickest path to getting IWebBrowser2 implemented on the WebBrowser control?
Thanks for the link, I appreciate it. I actually downloaded and looked at that around 4 AM this morning. He'd done a really nice job on his control, but for both the problem I'm trying to solve and as a simple tutorial on implementing IWebBrowser2, it's major overkill for my needs. He's implementing the interface, but it's buried in with a ton of other stuff and I just don't have the time to dig for it.
I was hoping to find a quicker, simpler, more to the point article entitled, "How to implement IWebBrowser2 when you're just too plain stupid to use COM in C#, in three easy steps." Or something of that sort. One can dream.
I do normally enjoy going through a good book or article, especially of this quality, but it's crunch time on this project (i.e. code till you fall asleep at the keyboard, wake up, code some more) and I'm currently just trying to put out the fire at my feet as quickly as possible. You know how it goes...