Search results

  1. D

    Updating data through Transaction Control

    Thank you. I've been doing allot of research lately. Would you have a sample with datasets but not with stored procedures? Thanks
  2. D

    Updating data through Transaction Control

    Hi Bhar, What would you suggest ? Thanks Dave
  3. D

    Record Locking

    Hi, I was looking at the code sample you told me about Listview project.. I don't see any code to actually save the invoice. Does this project save the invoice? Thanks
  4. D

    Updating data through Transaction Control

    Hi, 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...
  5. D

    Record Locking

    Hi Zekeman, 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...
  6. D

    Record Locking

    new question.. Hi, 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...
  7. D

    Record Locking

    Hi, 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? thank you!
  8. D

    Record Locking

    I don't understand why you don't like that idea. Would you be suggesting the database name / location be hard coded in code? Dave
  9. D

    Record Locking

    Hi, 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...
  10. D

    Record Locking

    Hi again, I was wondering if you had an example of use CONFIG to store the DB name and location... thanks Dave
  11. D

    Record Locking

    thank you!
  12. D

    Record Locking

    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? take care
  13. D

    Record Locking

    reading a config file Hi, 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. thank you.
  14. D

    Record Locking

    Thank you. 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...
  15. D

    Record Locking

    Hi, I read the msdn articles on data reader. data reader has to do with selecting rows in code and cycling through them. This helps thank you. But what about data bound controls and forms.. Thanks
  16. D

    Record Locking

    Thank you, 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...
  17. D

    Record Locking

    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...
  18. D

    Record Locking

    Hi, 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...
  19. D

    Record Locking

    Hi, 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...
Top Bottom