hello to all
i am finding my self in confusing problem.

everyay log file of my application increase by 10 GB.
every time i found more than 100 connections open in SDQL Server 2005 under my database.

i an using SQLHELPER Class by microsoft.i ma not putting my code in try-catch block. example

of one of my frequently used function is as follows:

        protected Int64 GetMemberID()
        {
            String SqlSelect = "SELECT * FROM MemberMaster WHERE MemberUserName= '" +

Session["UserName"].ToString() + "'";
            SqlDataReader dr1 =

SqlHelper.ExecuteReader(ConfigurationManager.Conne ctionStrings["CowcallConnectionString2"].T

oString(), CommandType.Text, SqlSelect);
            while (dr1.Read())
            {
                CurrentMemberID = Int64.Parse(dr1["MemberID"].ToString().Trim());
            }
            return CurrentMemberID;
        }

well i doubt i am opening connection and do not closing it. moreover i do not know how to close connection in above code when i am using sql helper class.
please give me yours suggestion regarding my code even if it is not solving above two problems.

thanks......

__________________
thanks......

hi there.. I don't know how the helper class work, but when you use a reader you have a connection object and a command object open.. so after you use the reader you have to dispose them somewhere.. so maybe you have a method to do that???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Supporting Gonzalo, there is a property with datareader as "CommandBehavior.CloseConnection" which automatically closes the connection once data is fetched, so study that...

Regards
Mike

thanks i try this.
i want to know if i am not to use sqlhelper class. what's other way to access connection string and use SQL query. is i am to write again and again

thanks......