Data base connection

Question

As i am working on a project in which i required to connect my database but i am unable to find connection class.. Plzz help me out as soon as possible!!!!!

Pravin More · Answer

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.