SQL and C#
Posted on 2014-04-04
Hi Guys ,
I have implemented windows form application with C# and used sql2012 server.
I connect my application to one database and use one table. Now I would like to change the way I connect to the table and separate it to two tables and build between them relationship then connect my application to this tables for example:
table name = sales - columns - ID, customer, account, deposit, time
table name = history - columns - ID, history1, history2, history3, history4
1.I would like to know how can I build these tables and make between them relationship in order to work with the application.
2. I would like to know how to connect the application to the new structure.
basically I need two things to create the tables in the sql database server and point my app to the new structure.