System Out of Memory Exception

Hi

I am having an application running on production server. There are around 100 domains running on that server though we are not getting muhc traffic right now we are getting 2,500 unique Visitors. Now twice a day I get system out of memory exception ..and by applying so many things ..I am unable to solve it .. The structure of my application is 3 Tier .. and following is the code for classes I am using ...I want to know is anything in classes I am doing wrong which is causing it. Please see the code below. This is just a sample class.

For further information. I am using Idisposable for all my classes and also using supressfinalize in dispose method. For access all classes I am USING keyword .. May be i missed it for some classes ..but I don't think it really affect ?

Also I have checked my all SQL connections are getting closed properly. using sp_who command .. generally I see around 2500 connections among 7 databases which I am using in my application ..as my application is a portal.

using System;
using System.Data;
using System.Collections;
 
/// <summary>
/// Summary description for clsCarPayments
/// </summary>
public class clsCarPayments : IDisposable
{
    #region --Declare Variables --
    int intAgentId = 0;
    Hashtable HTable = new Hashtable();
    clsCarDb objDatabase;
    #endregion
 
 
    #region --Declare Properties --
 
  
    public int AgentId
    {
        get { return intAgentId; }
        set { intAgentId = value; }
    }
 
    #endregion
    public clsCarPayments()
	{
		//
		// TODO: Add constructor logic here
		//
	}
 
    //~clsCarPayments()
    //{
    //    
    //}
    public void Dispose()
    {
        GC.SuppressFinalize(this);
    }
 
    public DataTable getAgentPayments()
    {
        using (objDatabase = new clsCarDb())
        {
            HTable.Clear();
            HTable.Add("AgentId", intAgentId.ToString());
            return objDatabase.procFetchRecord_DS("uspSelectAgentPayments", HTable).Tables[0];
 
        }
    }
}
 
 
------------------------------------------------------ Following is the database class function------
 
 public DataSet procFetchRecord_DS(string procname, Hashtable Htab)
    {
        try
        {
 
            sqlCmd = new SqlCommand();
            sqladp = new SqlDataAdapter();
            sqlds = new DataSet();
 
            sqlCmd.Connection = con;
            sqlCmd.CommandType = CommandType.StoredProcedure;
            sqlCmd.CommandText = procname;
            IDictionaryEnumerator ObjEnumerator = Htab.GetEnumerator();
 
            while (ObjEnumerator.MoveNext())
            {
                sqlCmd.Parameters.Add(new SqlParameter("@" + (ObjEnumerator.Key).ToString(), ObjEnumerator.Value));
            }
            sqladp.SelectCommand = sqlCmd;
            sqladp.Fill(sqlds);
 
        }
        catch (Exception ex)
        {
            sRetVal = ex.Message.ToString();
            //     sqlTran.Rollback();
        }
        finally
        {
            closeDBConnection();
        }
        return sqlds;
 
    }

Select allOpen in new window