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-exchang
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-exchang
Fernando Soto
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?
ASKER
I can create it. I am thinking to use the following:
database: ventas
Tables:
The information to be inserted (btnSave) should be:
to tblProducts
to tblProvider
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
since you are a newbie perhaps this example (http://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-application) will assist you
ASKER
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-exchang
Should I create a new post with this change?
The xml file is described here:
http://www.experts-exchang
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can use a sql to do this
https://msdn.microsoft.com/en-us/library/ms191184.aspx?f=255&MSPPError=-2147217396
or use the SQL data import / export wizard https://msdn.microsoft.com/en-us/library/ms140052.aspx
https://msdn.microsoft.com/en-us/library/ms191184.aspx?f=255&MSPPError=-2147217396
or use the SQL data import / export wizard https://msdn.microsoft.com/en-us/library/ms140052.aspx