Data bound form controls, selecting 1 record only

[Guern]

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.

 

[merlinGLX]

Guern,

I have a question - How did you manage to get VB.net to open the Access database and bind the values to textboxes?

 

[Guern]

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.