Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data bound form controls, selecting 1 record only

Status
Not open for further replies.

Guern

Programmer
Jun 22, 2001
91
GB
Hello,

I'm using the vb Oledbconnection, oledbadapter, and vb.net generated dataset to bind my text boxes to an access database. Currently the default select statement selects all the records. What I want is to just display 1 record on this particluar form and have no record navigation.

I tried modifying the sql statement to include a 'where x=y', and that works fine, but as soon as you change anything on the form the designer re writes that code and breaks the modification.

Does anyone have a suggestion as to how best to do this without manually coding all the update and inserts myself?

Thanks.
 
Guern,

I have a question - How did you manage to get VB.net to open the Access database and bind the values to textboxes?
 
Pretty much as I said above really. Add an oledbconnection, then the oledbadapter, then the dataset, then just bind the text boxes to it. I was doing this all manually before. This looks like a fantastic time saving feature if only I could resolve this one issue. It must be possible, I just don't know the best way to do it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top