Aniqa here is complete description of database connection
1.To create your database, launch your C# .NET software. 2. Start a new Windows project by clicking File > New Project.
3. Call it anything you like, because we won't be using this form. 4. From the menu bars at the top of C# .NET, click Project. From the Project menu, select Add NEW ITEM:
4. When you click on Add New Item, you should see the following dialogue box appear:
5. Select Service-based database (or SQL Database for older versions). 6. Name the database e.g. MyWorkers.mdf. (A database of people who work for us, and give them job descriptions. 7. In C# 2010 you're then asked to choose a Database model. Leave it on the default of Dataset and click Next. In C# 2010, you'll see this:
8. Just click Finish to return to the C# design environment.
9. Take a look at the Solution Explorer on the right and you'll see that your database has been added to your project:
10. However, the database is empty at the moment. We need to add a table to it. So right click on MyWorkers.mdf. From the menu that appears, click Open.
11. Right click on Tables to see the following menu:
12. Select Add New Table from the menu, and a new table will appear in your main window:
13. We'll created a very simple table with just four columns:
14. Leave the Allow Null box unchecked, and your screen will look like this:
15. At the bottom of your screen, you'll see a list of Properties. The one we want is Identity Specification. Set Is Identity to Yes, and Identity Increment and Identity Seed will appear:
16. By setting these values, SQL Server Express will add 1 to the Worker_ID column when we add a new worker. 17. Click under Column Name and type the second of our table fields:
18. For the Data Type, select nvarchar(50). The varchar is short for variable-length character string. With nvarchar, the n is short for Unicode, and the data will be stored in the UTF-16 format. Use nvarchar if you're going to be storing non-English characters. Otherwise, use varchar. The same is true of all the n's on the list. 19. Set the following values for the other two Columns in our table: Column Name: last_Name Data Type: nvarchar(50) Allow Nulls: Yes Column Name: job_Title Data Type: nvarchar(50) Allow Nulls: Yes Your table should then look like this: FOR FIRST NAME:
FOR LAST NAME:
FOR JOB TITLE:
20. At this stage, you can set a Primary Key for the table. A Primary Key is one that uniquely identifies a particular row in your table. To set a Primary Key, right click on Worker_ID. From the menu that appears select Primary Key.
21. Click File > Save All to save your work. You will be prompted to enter a name for your new table. Call it tblWorkers:
Click OK and you'll be returned to the main screen and the Database Explorer. Expand the Tables section and you should see your new columns appear:
22. The only thing left to do is to enter some default data into the table. 23. To add some data to your Table, right click on your Table name. You should see the following menu appear:
24. Select Show Table Data and you'll see a new tab appear:
25. All our Column names are there, waiting to be filled in. To enter data, simply click inside a cell and start typing.
26. Notice the warning symbols in the cells. These appear when the cell data has changed. The Worker_ID is still NULL in the image above. When we click in the next row, however, notice that a number will appear in the first Worker_ID cell:
27. Save your work, and you will have created your very first SQL Server Express database!
can you help My Android project
ReplyDeletefahad its c# group but what type of help you need
DeleteThis comment has been removed by the author.
ReplyDeletehelp me in making database connection in C#
ReplyDeleteAniqa here is complete description of database connection
ReplyDelete1.To create your database, launch your C# .NET software.
2. Start a new Windows project by clicking File > New Project.
3. Call it anything you like, because we won't be using this form.
4. From the menu bars at the top of C# .NET, click Project. From the Project menu, select Add NEW ITEM:
4. When you click on Add New Item, you should see the following dialogue box appear:
5. Select Service-based database (or SQL Database for older versions).
6. Name the database e.g. MyWorkers.mdf. (A database of people who work for us, and give them job descriptions.
7. In C# 2010 you're then asked to choose a Database model. Leave it on the default of Dataset and click Next. In C# 2010, you'll see this:
8. Just click Finish to return to the C# design environment.
9. Take a look at the Solution Explorer on the right and you'll see that your database has been added to your project:
10. However, the database is empty at the moment. We need to add a table to it. So right click on MyWorkers.mdf. From the menu that appears, click Open.
11. Right click on Tables to see the following menu:
12. Select Add New Table from the menu, and a new table will appear in your main window:
13. We'll created a very simple table with just four columns:
14. Leave the Allow Null box unchecked, and your screen will look like this:
15. At the bottom of your screen, you'll see a list of Properties. The one we want is Identity Specification. Set Is Identity to Yes, and Identity Increment and Identity Seed will appear:
16. By setting these values, SQL Server Express will add 1 to the Worker_ID column when we add a new worker.
17. Click under Column Name and type the second of our table fields:
18. For the Data Type, select nvarchar(50). The varchar is short for variable-length character string. With nvarchar, the n is short for Unicode, and the data will be stored in the UTF-16 format. Use nvarchar if you're going to be storing non-English characters. Otherwise, use varchar. The same is true of all the n's on the list.
19. Set the following values for the other two Columns in our table: Column Name: last_Name Data Type: nvarchar(50) Allow Nulls: Yes Column Name: job_Title Data Type: nvarchar(50) Allow Nulls: Yes Your table should then look like this:
FOR FIRST NAME:
FOR LAST NAME:
FOR JOB TITLE:
20. At this stage, you can set a Primary Key for the table. A Primary Key is one that uniquely identifies a particular row in your table. To set a Primary Key, right click on Worker_ID. From the menu that appears select Primary Key.
21. Click File > Save All to save your work. You will be prompted to enter a name for your new table. Call it tblWorkers:
Click OK and you'll be returned to the main screen and the Database Explorer. Expand the Tables section and you should see your new columns appear:
22. The only thing left to do is to enter some default data into the table.
23. To add some data to your Table, right click on your Table name. You should see the following menu appear:
24. Select Show Table Data and you'll see a new tab appear:
25. All our Column names are there, waiting to be filled in. To enter data, simply click inside a cell and start typing.
26. Notice the warning symbols in the cells. These appear when the cell data has changed. The Worker_ID is still NULL in the image above. When we click in the next row, however, notice that a number will appear in the first Worker_ID cell:
27. Save your work, and you will have created your very first SQL Server Express database!
thanx alot for helping me out
Delete