SqlConnection conn;
        public  static SqlConnection getConnection(){
 
            SqlConnection con=new SqlConnection("Data Source=Test_PP;Initial Catalog=Test_T;User ID=test;Password=test");
 
            return con;
        }
 
        public static SqlDataReader getdatareader(string str){
 
 
            SqlConnection conn = dbEngin.getConnection();
            //logclass.WriteTOLOG(DateTime.Now.ToString() + '\t' + "Establish the  Sql Database connectivity");
            SqlConnection.ClearPool(conn);
 
            conn.Close();
           //logclass.WriteTOLOG(DateTime.Now .ToString()+ '\t' + "Close the SQL connectivity");
           conn.Open();
          // logclass.WriteTOLOG(DateTime.Now.ToString()+ '\t' + "Open the SQL connectivity");
           SqlCommand command = new SqlCommand(str, conn);
          // logclass.WriteTOLOG(DateTime.Now.ToString() + '\t'+ "Executing the SQL query"+str);
            return command.ExecuteReader();
 
        }