in this wind form article, we will learn about how to build a C sharp real time projects with source code step by step from scratch
Steps for setting up the existing source code and database
Download the script file, double click on that, it will open script in SQL Server Management studio.
Execute the generated script, by selecting the entire script and click on F5. If you get errors first create a database (Query: Create database ContactsManagerDB) and then select total script except for the above-stated query, you find it in the topmost of the script text and execute.
It will create Contacts Manager Database. You can find it in the Object Explorer -> Databases-> ContactsManagerDB.
Double click on the Database name (ContactsManagerDB) to view the Tables included in the Database.
Here you can find four Tables like Country, State, User, Address.
If the database contains Stored Procedures you can find them in Databases -> ContactsManagerDB -> Programmability -> Stored Procedures.
You can modify the Database as per your requirements.
Steps for setting up the project in Visual Studio and edit App.config file as below
C sharp live project
Download the Zip file and extract it.
Open the folder(ContactsManagerApp)
In the folder, you can find .sln file
Double click on .sln file
It will open the project in Visual studio.
Check all the files or Forms existed in the Solution Explorer or not
Goto -> Solution Explorer-> select App.config -> double click on it-> you will find this:
<connectionStrings> <add name="AddressBookLQEntities" connectionString="metadata=res://*/ContactsManager.csdl|res://*/ContactsManager.ssdl|res://*/ContactsManager.msl;provider=System.Data.SqlClient;provider connection string="data source=UserName\SQLEXPRESS;initial catalog=ContactsManagerDb;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" /> </connectionStrings>
Here edit below attributes to your Data source name i.e., SQL Server instance name you find that when you open SQL Server Management Studio and in the first pop window you have Server name: <Username\SQLEXPRESS>, copy and paste that in the below attribute:
Here in the below attribute in case you may have the same Database name no need to edit that otherwise change that also to your Database name:
Now the total project is ready for execution, build the project make sure that you do not have any errors and debug.
Enter credentials in the Login Form and check all functionalities. Thanks and Best of luck!