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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David Johnson, CD, MVPOwnerCommented:
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.