Video: How Do I: Modify the Database?

Presenter:Beth Massi


Visual Basic beginners will learn how to add a new column to a SQL Server database table and make the necessary changes to the application in order to work with this new column using the Server Explorer and the DataSet Designer.

Click here to go to original video page


Minute 0
Play my name is Beth Massey and welcome to the Windows forms of her data video series in its next video I d show you how we can add a column to our table in a database and what changes we need to make the application in order to see those changes saw an application already open in Visual Studio I ve created a form and a data set called customer is built upon the OMS database that we created in the previous videos when I m going to do is add a column to our customer table so that we can get it into our database into a data set as well as displayed on our form so the first thing we need to do is we need to come to our customer table and add our new field summoner right click and go to open table definition to the field we want to add anything other address line so instead of just allowing one address Linux ad to sell a menace call this address to an emergency of our char
Minute 1
50 and images less safe now at order to get his address to into our data set and we ended onto a form we first need to modify our data set some ago over to our data set and will right click on it and the customer data set select add column in a missing call this address to 80 is the property sheet to make changes to the data type we are to have this as a setup as a string that s the default so the next thing we need to do is we need to reconfigure our select statement so that it now pulls in the address to from our database table so many now go to the customer table adapter and right click and select configure and this will open up the select statement solemnity do is just add our address to
Minute 2
Will pull it from our database so now that s all that s left to do is to go back to our form and then go to the data sources window and you see addressed to hear and we can just go ahead and drag and drop the new field onto her form day and now you can just hit F5 to run it occasionally can just go ahead and Anderson data inherent and press the looks like it went let s check it will hit F5 or hard time and their dosages fade into a database so that s how you get do you add a new column he added to your table in your database first thing you make the changes to your data set and you can drop the new fields on your form so I d like to thank you for your time if you d like to check out the Visual Basic developer Center will be posting updates needs to
Minute 3
Is there please also check out the Visual Basic team blog and my blog for more information basic