my site show error

Question

my site show this error

you can also check online it visit only 4 to 5 pages then http://www.pakcarid.com/

System.Data.OleDb.OleDbException: System resource exceeded.

Source Error:

Line 267:            OleDbDataAdapter dtt = new OleDbDataAdapter(tot);
Line 268:            DataSet dstt = new DataSet();
Line 269:            dtt.Fill(dstt);
Line 270:
Line 271:            this.totalview.Text = dstt.Tables[0

can any one tell my how to solve it

Answer 1

Are you closing your DataAdapters? You need to either explicitly call dtt.Close() or use using blocks (they're IDisposable):

DataSet dstt = new DataSet();
using(OleDbDataAdapter dtt = new OleDbDataAdapter(tot))
{
    dtt.Fill(dstt);
    dtt.Close();
}

etc. The Close() is redundant here because the using block will call dtt.Dispose() but I prefer to leave it in anyway.

Most ADO.NET objects are IDisposable; whereas I doubt some of these matter whether you close and dispose them or not (e.g. Commands) I expect DataAdapters, connections, etc. do.