Sharing the goodness…
Beth Massi is a Senior Program Manager on the Visual Studio team at Microsoft and a community champion for business application developers. Learn more about Beth.
More videos »
This how-to video series is dedicated to getting Visual Basic developers productive on areas of data-based Windows Application development. The series starts with the basics of database development with SQL-Server 2005 Express then walks through the details of connecting to and querying databases, and Windows Forms development basics using the built-in designers in Visual Basic 2005.
I'm very excited to see the content I'm producing finally coming online! This series is aimed at VB.NET Winforms and database beginners but stay tuned for more intermediate and advanced topics coming out of the Massi brain....Enjoy the series!
I want more, more and more please
Thanks for the compliment! What would you like to see next? If you would like the source code that I built in the videos, then just follow this post: http://blogs.msdn.com/bethmassi/archive/2007/05/05/forms-over-data-video-series-what-next.aspx
Bravo on your videos!
1. Information on how to use the DataAdapters and BindingSources beyond just the simple drag-and-drop on the Form is really needed. I was not aware that there was so much flexability in these components.
2. Thank you for presenting the information in the video format. It much easier to learn from a video rather than reading several pages of text.
3. Thank you for showing how to use the data from more than one related file rather than just using one file. I dont remember ever seeing samples using more than one file.
What else would we like to see? Do you have any DataGridView tips and tricks?
Keep up the good work!
I'll add your requests to the list :-) A lot of people have responded privately with a lot of great feedback. I'll tally up the requests and post my next set of plans soon!
Excellent content, just what beginners like me are looking for. Many of my co-workers are enjoying them also. We Look forward to the next series.
Your videos are GREAT!
How about a video on how to Bind a SQL 2005 database to a TreeView, & show the data in a few textbox, etc... in VB 2005?
Thanks for all the great video, you have already posted! :)
Hi, fist of all ¡¡¡THANKS!!!
Great videos, I learn a lot of them.
I noticed that you use Vista, How do you capture the video?
Continue your great work. :)
Wow! This is awesome. Visual Basic IS actually visual!
Makes me want to go out and make a thank you video.
Beth, you rock...
Hey - I just discovered your "Forms Over Data - How Do I?" video series. You've got a really to the point presentation style and I find it's a good way to learn / confirm my understanding of ADO.NET capabilities with Visual Studio.
Halfway through your series (I've viewed segments 1-7), I thought I'd give you this feedback:
I thought the first 6 videos were very good / easy to follow; however...
I thought video #7 left out some necessary detail with regard to populating the data table with items from the Products table and then populating the ComboBox with Product Names from the same table. You totally glossed over that.
In Video #3, you left out any discussion of deleting records from the child (detail) data table (the datagrid). It is possible to delete items from the parent (master) data table, but only if there are no children. An explanation of how to do this is the #1 thing I would really love to see covered!!!
Anyway, thanks for doing this.
Thanks for the feedback Ian.
Regarding populating tables with data, I cover how to add data to tables you create in the first video -- #1.
Regarding the deleting of children, you can do that by selecting the child row in the grid and hitting the delete key. WRT the cascading delete on the parent, if you want to enable that scenario, the easiest way to do it is set the foreign key relationship in the database to CASCADE deletes. Just right click on the parent table in server explorer, select "Open Table Definition", right-click on any column and select "Relationships", select the relation and expand the "INSERT and UPDATE Specification" and for the Delete Rule set it to CASCADE.
The other way to do this is to control the order of update, insert, and deletes with the TableAdapters. I'll post a sample on how to do that (inside a transaction) next post. :-)
Great videos, very very usefull. I have question about relations between two tables. I create master/detail form, and follow the steps on your video create search on same form , it works fine. When i try to create delete action on same form, i get error. If i change the type of relation from RELATION ONLY to BOTH RELATION AND FOREIGHN KEY CONSTRAINT, delete action work but search fall. Any sugestion ?
The order you fill the tables matters when you enable FK constraints. You need to fill in parent-child order because a child cannot exist without a parent when you set FK constraints. Take a look at the video that shows how to update multiple related tables. http://msdn2.microsoft.com/en-us/vbasic/bb725826.aspx?wt.slv=topsectionsee
Hi Beth an thank Y for your fantastic videos!
Question: When deleting a parent row with children I get an error when running my app. Thats ok, but how to provide a more "meaningful" error for my users?
(prowided by me, not the default from sys)
I assume you are using the BindingNavigator? If so just select the BindingNavigator in the properties window and set the DeleteItem property to (none). Then double-click on the delete button to add a Click handler and you can write all the code to perform the check and delete. i.e.:
Private Sub BindingNavigatorDeleteItem_Click() Handles BindingNavigatorDeleteItem.Click
If Me.CategoriesBindingSource.Position > -1 Then
'your code here.....
'When you're ready to delete the current row then call this line:
This how-to video series is dedicated to getting Visual Basic developers productive on areas of data-based Windows Application development. The series starts with the basics of database development with SQL-Server 2005 Express then walks through the detail