I never got an anwer on this: Whose UserName and Passwords would be hard coded in the web.config? Wouldn't each user need to login with their own UserName and Password to gain access? Do you add Keys for each? That would seem very inefficient if you had lots of users.

I have one question.

If I am using a datareader, should I close that in the try block or the finally block?

when you use datareader first declare as null

dataReader dr=null;

and use using because using is the combination of try and finally.

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Summary description for Cls_DataAccess
/// </summary>
    public class Cls_DataAccess
    {
        private SqlConnection con;
        public bool blnIsError;
        public string strErrorMessage;
        public Cls_DataAccess()
        {
            //
            // TODO: Add constructor logic here
            //
            blnIsError = false;
            strErrorMessage = "";
        }

        /// <summary>
        /// Returns Error Message
        /// </summary>
        /// <param name="ResetError">Boolean value to specify if error needs to be reset</param>
        /// <returns></returns>
        public string GetErrorMessage(bool ResetErrorStatus)
        {
            string strReturn = strErrorMessage;

            if (ResetErrorStatus == true)
            {
                ResetError();
            }

            return strReturn;
        }

        /// <summary>
        /// Initilaizes the error message of the class
        /// </summary>
        /// <param name="ErrorMessage"></param>

        private void InitializeError(string ErrorMessage, string Function)
        {
            blnIsError = true;
            strErrorMessage = ErrorCodes.ReturnError(this.ToString(), Function, ErrorMessage);
        }

        /// <summary>
        /// Resets the error
        /// </summary>
        public void ResetError()
        {
            blnIsError = false;
            strErrorMessage = "";
        }

        /// <summary>
        /// Returns an open database connection
        /// </summary>
        /// <returns>Connection Object</returns>
        public SqlConnection GetConnection()
        {
           

            //olecon.ConnectionString = ConfigurationManager.ConnectionStrings["tempStoreConnString"].ConnectionString;

            string strConnectionString = ConfigurationManager.ConnectionStrings["tempConnString"].ConnectionString;

            strConnectionString = strConnectionString.Replace("App_Data/", @""+AppDomain.CurrentDomain.BaseDirectory+@"App_Data/");

            con = new SqlConnection();
           
            con.ConnectionString = strConnectionString;
           
            try
            {
                if (olecon.State != System.Data.ConnectionState.Open)
                {
                    con.Open();
                }
                return con;
            }
            catch (Exception errOlecon)
            {
                InitializeError(errOlecon.Message, "GetConnection");
                return null;
            }
        }

        /// <summary>
        /// Close the database connection if opened
        /// </summary>
        public void CloseConnection()
        {
            if (con.State == System.Data.ConnectionState.Open)
            {
                con.Close();
            }
        }
    }

Keeping connection open for bunch of operation or open/close connection for every operation depends on application behavior and usage.

I always use connection pool  which have multiple connections and always colse connection for each operation. But sometimes I use same connection from pool for multple operation.

Hi Sriya,

 Replying to a very old post :)

Use the code as below in your try block.

SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

if (rdr.Read())
{
   str = rdr[0].ToString();
}

rdr.Close();

hi all,

whenever i try 2 execute the connection code.A server error is gettin displayed "cannot open the database "projdb.mdf"requested .login failed..login failed for the user "YOGESH\Owner"