Database

santoshsan wrote:

"SELECT subcat_id,subcat_name FROM temp_subcat WHERE cat_id = 'get_cat' "

get_cat is a long variable, but when i enclose it in ' ' qoutes SQL or ODBC treats it as string and does not uses the value inside it which I wanted to.

DalFactory fact = new DalFactory();

fact.GetDal();


then in the factory class:


GetDal()
{
  IDal aDataLayerClass;

  switch (source)
  {
      case "SqlServer":

         aDataLayerClass = new SqlServerDal();
         break;

      case "Oracle":

         aDataLayerClass = new OracleDal();
         break;

      etc...
  }
   
  return aDataLayerClass;
}