Class to make connection to database

HI Nethra,

yes you can make it abstract but then you need to implement method of abstract class in every class where you inherit that abstract class.
see, normally we use abstract class where processing of derived class for method of base changes in every derived class......

so in our case ,if you want to use different database connection for in diff scinario....
i guess that, you are going to declare more that connection string in web.config and will use perticular in perticular class....
if so,
then i have 2 solution
1] use abstract class inwhich declare method getconnection (use same class i given in my previous reply just make it abstract)
   and in every class where you want to open connection just inherit that abstract class n override method in that method  code you can change line that set connection string i.e

dbConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["commonconnection"].ToString());

here you can give any name you want instead of "commonconnection"

2] second way is somwhat simple
     dont use abstract class use simple class and in that class use simple method which takes 1 parameter i.e Connectioname n you will pass name of connection you given in web.config.....
here is example.....
public class Dbconnection
    {
        public SqlConnection getcon(string strcon)
        {
            SqlConnection dbConn = null;
            try
            {
                dbConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["+strcon+"].ToString());
              

            }
            catch (Exception e1)
            {
             
            }
            return dbConn;
        }
    }
 
and wherever you want any connection to open just create object of above class and call that method with parameter as value you set in web.config...

suppose, this is web config file

   
       
       
                  
if you want open con1
      then Dbconnection db1=new Dbconnection();
                  db1.getcon("con1");
if you want open con2
      then Dbconnection db1=new Dbconnection();
                  db1.getcon("con2");
like that........

so nethra ,i recomend you 2nd solution

Thanks ,
Pravin.

Hi,

Make a class as public for encrypt the connection string, in that use,

           con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connection"].ToString());

Now you make another class take it as public and to use this class to connect to db. In that get connection string from above class.

public class Dbconnection
    {
        public SqlConnection getcon()
        {
            SqlConnection dbConn = null;
            try
            {
                dbConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["commonconnection"].ToString());
              

            }
            catch (Exception e1)
            {
             
            }
            return dbConn;
        }
    }