--------------------------------------------------------------------- DATABASE --------------------------------------------------------------------- DATABASE SQL C# SQL Database Tutorial 1:How to Connect and Use Local Database ( sql server ) using C# 2010 IDE https://www.youtube.com/watch?v=1EpYqtSlOr8 2013 IDE https://www.youtube.com/watch?v=HwA-tNvU3hw Data Source=(LocalDB)\v11.0; AttachDbFilename=|DataDirectory|\Database1.mdf; Integrated Security=True Database1ConnectionString Create Local data base { START 1. File -> New -> Project -> Visual C# -> Window Forms Application – [GIVE A SPECIAL NAME ok] 2. –[@Solution Explorer] a. Right click [c#]DataBaseName b. Add c. New Item d. [Visual C# Items] select->Service-data Database e. {give name, add} f. 3. [@Server Explorer] a. Expend b. Right click the Table c. {add New Table} d. Create column names e. {click on Update upper arrow} 4. [@Solution Explorer] a. Click on database.mdf file 5. [@Data Sources] a. Click on {Add New Data Source} b. Follow the wizard c. Click the check box for Tables – finished 6. [@Editor] a. Toggle Form1.cs b. 7. [@Data Sources] a. Click on the Table to expose the drop button b. 8. END } 2012 https://www.youtube.com/watch?v=IZS1CeqNjAM https://www.youtube.com/watch?v=08mvRYUXuxM @setup MySql https://www.youtube.com/watch?v=yPu6qV5byu4 @connection https://www.youtube.com/watch?v=DCgRF4KOYIY [Download orkbench] http://mysqlworkbench.org/ http://dev.mysql.com/downloads/file.php?id=457780