VS2013: VB.Net Windows Form: Save textboxes to MSSQL Server 2012

Hi,
in the following link I have a form with textboxes: I would need the easiset way to save it into MSSQL Server 2012, using Visual Studio 2013 with VB.Net forms. I don't know much abput database programming I have just heard that Entiuty Framework is the new thing. I am open to your solutions, just need a working code.

http://www.experts-exchange.com/Programming/Languages/.NET/Q_28626443.html
LVL 2
José PerezAsked:
Who is Participating?
 
Fernando SotoRetiredCommented:
Hi Oscar;

I Like using the Entity Framework to do my database applications. The following is how to setup a Entity Data Model in your project. Please note that this video is using an older EF designer but the steps are basically the same, Entity Framework Database First. When you create the EF model you will have a choice of which version of EF you wish to use the current version 6, this part is not in the video because it is an older version they are using.

Once you have the database set up and loaded with some test data we can talk about how you wish to proceed.
0
 
Fernando SotoRetiredCommented:
Do you have an existing SQL Server database already created? If not do you have someone who you work with that can help you set up the database?
0
 
José PerezAuthor Commented:
I can create it. I am thinking to use the following:

database: ventas
Tables:
tblProducts
tblProvider

The information to be inserted (btnSave) should be:

to tblProducts
Product_Name
Product_Price
Product_SKU

to tblProvider
Provider_name
Product_Vendor
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
José PerezAuthor Commented:
wow I think I wrongly typed my question... what I really needed is to update the MSSQL Server 2012 database with the xml file.
Should I create a new post with this change?

The xml file is described here:
http://www.experts-exchange.com/Programming/Languages/.NET/Q_28619544.html
0
 
David Johnson, CD, MVPOwnerCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.