Connect Database in (C#)

database1

CONNECT DATABASE IN VISUAL STUDIO IN C#.NET

                                         Everyone who uses the Visual Studio needs to connect to a database at some time for their elaborate  purposes. Database can be connected in 11 different methods with Visual Studio. Here i made a simple connectivity method by adding a .mdf file to you Windows Application form.

STEP 1:

On the File menu, point to New and then click Project.

database-connectivity-1

STEP:2

In the New Project dialog box, click Windows Forms Application, and then click OK.

A new Windows Forms project opens.

database-connectivity-2

STEP:3

On the Data menu, click Add New Data Source.

  The Data Source Configuration Wizard opens.

database-connectivity-3

STEP:4

Click Database and then click Next.

database-connectivity-4

Select Dataset

STEP:5

Click New Connection.

The Add Connection dialog box opens.

database-connectivity-5

STEP:6

In the Add Connection dialog box,  click Change and select Microsoft SQL Server Database file from the Change Data Source dialog box. Click Continue.

database-connectivity-6

STEP:7

Browse for the database file with .mdf extension and click Test Connection

database-connectivity-7

STEP:8

If the test connection is succeeded press ok and click next in the Data source configuration wizard and click Next in the next screen. Select the tables list from your database.

database-connectivity-8

STEP:9

Now click Finish to connect with your database file.

And you can view tables on the Data Source menu .

database-connectivity-9

STEP:10

After connecting database to your form you have to link it to your application by  copy the connection string from the properties of the database.

database-connectivity-10

STEP:11

Now paste it to your sql connection. And its done. You have successfully connected your database….

Advertisements

One thought on “Connect Database in (C#)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s