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...
Problem is that I'm new to Visusal Basic and the documentation talks about dataadapters but not readers all that much.
Would you mind telling me a bit about datareaders and the difference in implimentation? Any doco and or samples where I could start to look at?
How does the...
Hi, Thank you again for your input.
It is a payroll application with over 600 employees and growing. The employees are being paid on commission from various sources and as such there are numerous people updating the data.
What was confusing about my post? Please give the chance to...
I don't think it is that unusual...
here is the seniario.
you have 2 data entry clerks,
1 employee maint program.
you do a fill to an dataadapter. the table has 100 rows.
clerk 1 updates emp number 1 and clerk 2 updates emp number 2
but, the record set that clerk 1 has does not...
I'm an Oracle guy and just started using VB. I've developed on Access for many years.
I'm confused with this new way of loading all the data into a form (object) and then writing it all out.
What happens in multiuser applications where mulitiple people update the same data? If 2 people...