SqlCommand cmd;
    static string connString =     System.Web.Configuration.WebConfigurationManager.ConnectionStrings["conn"].ConnectionString;
    DbCommand dbcommand;
    SqlDatabase db = new SqlDatabase(connString);
    public static SqlConnection scon = new SqlConnection(connString);





 #region Connection function
    public void CreateConnection()
    {
        if (scon.State != ConnectionState.Open)
        {
            scon.Open();
        }
    }
    public void CloseConnection()
    {
        scon.Close();
    }
    #endregion





 #region Common Function
    public DataSet GetDataSet(string SQL)
    {
        DataSet dsInv = new DataSet();
        dbcommand = db.GetSqlStringCommand(SQL);
        dsInv = db.ExecuteDataSet(dbcommand);

        return dsInv;
    }
    public DataTable GetDataTable(string SQL)
    {
        DataTable dtInv = new DataTable();
        dbcommand = db.GetSqlStringCommand(SQL);
        ds = db.ExecuteDataSet(dbcommand);
        if (ds.Tables.Count > 0)
        {
            dtInv = ds.Tables[0];
        }
        return dtInv;
    }




 public int ExecuteQuery(string qur)
    {
        int Retval = 0;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = db.ExecuteNonQuery(dbcommand);
        return Retval;
    }
    public int ExecuteScalar(string qur)
    {
        int Retval = 0;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = Convert.ToInt32(db.ExecuteScalar(dbcommand));
        return Retval;
    }
    public int ExecuteIntScalar(string qur)
    {
        int Retval = 0;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = Convert.ToInt32(db.ExecuteScalar(dbcommand));
        return Retval;
    }
    public string ExecuteStringScalar(string qur)
    {
        string Retval = string.Empty;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = Convert.ToString(db.ExecuteScalar(dbcommand));
        return Retval;
    }



 <add name="conn" connectionString="Data Source=; Initial Catalog=;User ID=;Password=;MultipleActiveResultSets=True;Connect TimeOut=100000;Pooling=true;Max Pool Size=250;Min Pool Size=100;"/>