System.OutOfMemoryException" exception when you execute a query c#

DatabaseConnector connector = new DatabaseConnector();
            connector.OpenConnection();
            try
            {
                DataTable dt = new DataTable();
                SqlDataAdapter da = new SqlDataAdapter(queryString, connector.Connection);
                da.SelectCommand.CommandTimeout = 0;
                da.Fill(dt);
                return dt;
            }
            catch (SqlException ex)
            {
                return null;
             
            }
            catch (Exception ex)
            {
                return null;
            }
            finally
            {
                connector.CloseConnection();
            }



Clear the temp of computer..................




Comments

Popular posts from this blog

How to use DbFunctions.TruncateTime

Provision AWS EC2 Instance and RDS with Terraform, and Deploy Spring Boot App to EC2 Instance via GitHub Action Pipeline

Microsoft Access Connectivity from C#