Need to bind data from SQL server 2000 to textboxes and also be updated when other users cha

I'm trying to move away from working in microsoft access and try and work with SQL Server. I'm going to be storing around 50K records of data in a table within SQL server at first. I tried using the visual studio.net Dataset control to create all my bound fields in the set, but what I noticed is the connection is not continually connected to the source.

I will have several users using this app, and each could be updating any record at any time, and I need and update to take affect on the server right away and the next time someones accesses that record will see the update. What I have found out is that the DataSet created is only a copy of the Data at that moment and then the connection is closed, so no telling if anything was updated. Now I tried making an ADO connection that is always connected and display the recordset in bound textboxes.

I can connect and create the recordset, but how do I bind the columns to the textboxes and make sure they are updated at the source when a change is made. Below is the sample of how I'm connecting, please any help or new ideas would be greatly appreciated. msgboxes at the bottom was for me to make sure I'm making the connection and seeing all the records.

Dim ObjConnAsNew ADODB.Connection

Dim ObjRSAsNew ADODB.Recordset

Dim countrrAsInteger

Dim strRequestAsString

With ObjConn

.ConnectionTimeout = 30

.CommandTimeout = 30

.Provider ="SQLOLEDB"

.ConnectionString ="Driver={SQL Native Client};Server=DV8110US\TEST;Database=ALSQL;UID=AL;PWD=al;"

EndWith

strRequest ="SELECT * FROM dbo.DeskGroupings"

DoWhileNot ObjRS.EOF

countrr = countrr + 1

ObjRS.MoveNext()

Loop

[3251 byte] By [mike11d11] at [2007-12-25]