I want to write a program not not use the default behaviour of ADO.NET and datasets.
What I'd like to do is to have a combo box at the top of the form that a user could use to select a record out of the database. The form would fetch the data and lock the record and then the user would...
No sir, you are not out of context. Your suggestion was bang on. I ended up calling Microsoft Tech Support late last week to discuss this and the gentleman there discussed this Optimistic Concurrency setting with me. It looks like just what I need. Thank you for your...
If I use the data explorer to create the binding controls, etc.
When the program runs in production mode (at the client), it is still going to use my local connection strings used at design time, correct? How do you get around this?
What I mean is by setting up a...
Thank you, it is one line of code but the code has to work on my comptuer at home and my clients. They have sql running on a dedicated server and mine runs from my desktop.
Do you have sample code to read the config file?
The client uses active directories so I don't need a pasword. I just need to store the computer name and the database name. Active directories will do the rest.
I thought I'd read it in in the start up form and put it in a global variable as my connect string and then use it as I needed...
thank you. live got the list control attachment and will look at it in detail.
one question, why did you use OLEDB rather then sqldata reader. Are you suggesting that I should use OLEDB rather then SQLDataReader?
reading a config file
Since I'm going to deploy at the client's site, would you have any sample code on reading a config file to build a connect string on the fly?
That way I have a config file for remote development and another for the end user.
To keep it simply, say I have a form. Say only text boxes.
I want to have a combo box control that I can use to select the employee that I am looking for. Then, I want to be able to bring up this record on the screen. If the user starts to edit the record, it would be nice if...