Generating Connection String........

STEP1:

 Create New Project.... Got To Data Inf Menu Bar. Then Select Add Data Source ..... As Shown In Fig Below........

 STEP 2:
After That Following Data Source Configuration Wizard Will Get Open In That Select Database and Click Next Button.... As Shown In Fig Below.......

STEP 3:
Select New Connection ... As Shown In Fig Below......

Step 4:
Now The Add Connection Dialog Box Gets Open In It Select Change Button..... As Shown In Fig Below

STEP 5:
Now Select Data Source In My Case I am Using Microsoft SQL Server... A s Shown In Fig Below....

STEP 6:
Now Click On Server Name DropDown Box Select Your Server Name... In My Case Its VISHAL\SQLExpress.... And As Per Your Requirements Select Windows Or SQL Authentication.... And Select DataBase Name From The List In My Case DataBase Name Is "AlphaDB"...... As Shown In Fig Below........

Step 8:
Now Click On Test Connection button To See Weather The Connection Is Created Or Not... As Shown In Fig Below......

Step 9:
Now Click on The Plus Sign In Front Of Connection String To See The Connection String ... And If Your Are Using SQL Authentication Don't Front To Select The Radio Button In The Following Fig Which Says "Yes,Include sensitive data in the connection string" so your Password gets attachted to it......