Data base connection

Hi Smith,

                there are many way for  connect to database and perform oprations....

                here i am giving sample ,hope it will help you......

                

SqlConnection con = dbcon.getcon("Data Source=yourSqlSERVERName;Initial Catalog=Databasename;Persist Security Info=True;User ID=Your ID;Password=xxxxx");

            con.Open();

SqlCommand spcmd = new SqlCommand("Select * from Tablename", con);

SqlDataReader dr = spcmd.ExecuteReader();

while(dr.Read())
{
    //Your Processing
}

Thanks,

Pravin.