what you may wish to start with is a BindingNavigator/TableAdapter. Then later on, should you want more flexibility look at doing it manually programmatically:
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=753872&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=964164&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=728535&SiteID=1
if you havent, watch the e-videos that you recieve apperently when you register VBExpress. It guides you through the process with a sample app in the video which you can use in your application for example.
basically if you were doing it via the manual (in most ways better) approach as above, then you would need a couple of forms (like add record, delete record, search record) then perform your commands
lets take the search record form.....
you would fill a dataset with data from the database (examples included in the links above) then bind that dataset (holds our records) to a datagridview which you can view records.
you can also update records by editing it in the datagridview, which commits changes to the datasource (dataset) and finally call the Update() method in the DataAdapter to finally commit changes to the database. you also need to implement the correct insertcommand, updatecommand and deletecommand on the dataAdapter to make the update() work correctly.
does this help you
|