Hi
Would anyone be able to advise me on the best way in which i am able to display the information from a Search in sqlce database and allow the results be displayed in a specified location.
An example is in my program there is a list of id which the user can search. They search for a record by id so only one record will return. I would like this information to then be displayed in the textboxes which are on the screen.
Any problems understanding what i am trying to do please ask. Any help would be appreciated
Thanks
accessing records
sutorius
Most of the .NET Compact Framework controls support data binding to an underlying data source which can be a DataTable populated by a SqlCeDataAdapter. Even simpler, you could query SQL CE/SQL Mobile with the ID the user provides, (ExecuteQuery), and use the SqlCeDataReader to extract the values you wish to display in the textbox. I would recommend you have a look at some of the sample applications available here:
http://msdn.microsoft.com/netframework/programming/netcf/netcfsamples/default.aspx
Darren
MCecile