Create Conection String

hi first u do one thing drag the sql dataSource from tool kit once its draged to ur form u configure the sqldatasouce and it will navigate to some steps once u completed all the steps u can see connection string in the web config file as follows

In webconfig file follow the following code:

<connectionstrings>
    <add name="EmployeeConnectionString" connectionstring="Data Source=.\SQLEXPRESS;Initial Catalog=dbEmployee;Persist Security Info=True;User ID=a;Password=b">
      providerName="System.Data.SqlClient" />
  </add></connectionstrings>

this is for windows authentication mode and once you find this copy the string in the invented commas as follows

in the class u copy as follows

using System.Data;
using System.Data.Sqlclient
class sample
{
    protected void page_Load(object sender,EventArgs e)
    {
         string str="DataSource =the name of server;Initial Catalog=the name of ur database;Integrated Security=True";
         try
         {
             sqlconnection con=new sqlconnection(str);
             con.open();//here Connection takes place
             string commandText="SQl query"; 
             SqlCommand cmd=new Sqlcommand(commadnText,con);//here the command isintialized 
             cmd.ExecuteNonQuery();
         }
         catch(Exception ex)
         {
             lable1.Text=ex.Message;
         }
         finally 
         {
             con.Close();
         }
    }
}

try this and u can do it
[Edit: Added PRE tag]

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace prjConnection
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
sqlCon.StateChange +=new StateChangeEventHandler(sqlCon_StateChange);
sqlCon.InfoMessage +=new SqlInfoMessageEventHandler(sqlCon_InfoMessage);
}

private SqlConnection sqlCon = new SqlConnection("Data Source = ; Initial Catalog = ; Intergrated Security = True ");



# region Exit
private void btnExit_Click(object sender, EventArgs e)
{
Close();
}
# endregion
# region open
private void btnOpen_Click(object sender, EventArgs e)
{
sqlCon.Open();
}
# endregion
# region close
private void btnClose_Click(object sender, EventArgs e)
{
sqlCon.Close();
}
# endregion
# region state
private void btnState_Click(object sender, EventArgs e)
{
txtState.Text = sqlCon.State.ToString();
}
# endregion
# region connectionstring
private void btnconnection_Click(object sender, EventArgs e)
{
txtConnectionString.Text = sqlCon.ConnectionString;
}
# endregion
# region packet
private void btnPacket_Click(object sender, EventArgs e)
{
txtPacketSize.Text = sqlCon.PacketSize.ToString();
}
# endregion
# region Display
private void btnDisplay_Click(object sender, EventArgs e)
{
txtConnectionString.Text = sqlCon.ConnectionString;
txtDataSource.Text = sqlCon.DataSource;
txtDatabase.Text = sqlCon.Database;
txtPacketSize.Text = sqlCon.PacketSize.ToString();
txtState.Text = sqlCon.State.ToString();
txtConnectionTimeOut.Text = sqlCon.ConnectionTimeout.ToString();
txtWorkID.Text = sqlCon.WorkstationId;

}
# endregion
# region state change
private void sqlcon_StateChange(object sender, StateChangeEventArgs e)
{

MessageBox.Show("The state of the connection is: " + e.CurrentState.ToString() + "The original state is: " + e.OriginalState.ToString());

}
# endregion

private void sqlCon_InfoMessage(object sender, SqlInfoMessageEventArgs e)

{

MessageBox.Show(e.Message);

}

private void btnGetInfo_Click(object sender, EventArgs e)
{
sqlCon.FireInfoMessageEventOnUserErrors = true;
sqlCon.ChangeDatabase("");
}


}
}

just a lil sample of a connection to SQL in C# if you need more help drop an email dragonsraveolution@thepub.co.za

There is a site dedicated for that. :)
http://www.connectionstrings.com/sql-server-2008[^]
Edit:
And a tutorial
Tutorials: AdoDotNet[^]

In webconfig file follow the following code
    <connectionstrings>
   
    <add name="EmployeeConnectionString" connectionstring="Data Source=.\SQLEXPRESS;Initial Catalog=dbEmployee;Persist Security Info=True;User ID=a;Password=b">
providerName="System.Data.SqlClient" />
  </add></connectionstrings>