Call Static method and sets value to Static variables from Global.asax using C# in ASP.Net

iammann says:

I have a table in which there are many columns for a specific purpose. so i want to store that table value in static variable from global.asax file. there are multiple static variable in my class.and in all those variables i want to store that table value.for each variable a single column is fixed.

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

using System; using System.Collections.Generic; using System.Linq; using System.Web;   /// <summary> /// Summary description for clsFileSize /// </summary> public class clsFileSize {     public clsFileSize()     {         //         // TODO: Add constructor logic here         //     }     public static int TenderSize;     public static int TenderCorigendumSize;     public static int CircularSize;     public static int GovtOrderSize;     public static int AuctionSize; }

 

1 2 3 4 5 6 7 8 9 10

CREATE TABLE T_FileSize (  FileSizeId INT IDENTITY(1,1) PRIMARY KEY,  TenderSize INT ,  TenderCorigendumSize INT,  CircularSize INT,  GovtOrderSize INT,  AuctionSize INT   )

 Hi iammann,

You can create the Properties for one static method in same clsFileSize class. And in global.asax call it and make instance of clsFileSize onces you get the values from database you can provide the instance values to static variable. Also if your table contains more than one record then you can make one static variable as List of clsFileSize class and assign value by calling records from database using method and call the method in Application_Start Event

Refer the below Test sample for your reference.

clsFileSize.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data.SqlClient;

/// <summary>
/// Summary description for clsFileSize
/// </summary>
public class clsFileSize
{
    public clsFileSize()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    public static int TenderSize;
    public static int TenderCorigendumSize;
    public static int CircularSize;
    public static int GovtOrderSize;
    public static int AuctionSize;

    public static List<clsFileSize> FileSize;

    int _fileSizeId;
    public int fileSizeId
    {
        get
        {
            return _fileSizeId;
        }
        set
        {
            _fileSizeId = value;
        }
    }

    int _tenderSize;
    public int tenderSize
    {
        get
        {
            return _tenderSize;
        }
        set
        {
            _tenderSize = value;
        }
    }

    int _tenderCorigendumSize;
    public int tenderCorigendumSize
    {
        get
        {
            return _tenderCorigendumSize;
        }
        set
        {
            _tenderCorigendumSize = value;
        }
    }

    int _circularSize;
    public int circularSize
    {
        get
        {
            return _circularSize;
        }
        set
        {
            _circularSize = value;
        }
    }

    int _govtOrderSize;
    public int govtOrderSize
    {
        get
        {
            return _govtOrderSize;
        }
        set
        {
            _govtOrderSize = value;
        }
    }

    int _auctionSize;
    public int auctionSize
    {
        get
        {
            return _auctionSize;
        }
        set
        {
            _auctionSize = value;
        }
    }

    public static clsFileSize PopulateFileSize()
    {
        string constring = ConfigurationManager.ConnectionStrings["ConStr2"].ConnectionString;
        clsFileSize clsFileSize = new clsFileSize();
        using (SqlConnection con = new SqlConnection(constring))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM T_FileSize where FileSizeId = 1", con))
            {
                con.Open();
                using (SqlDataReader sdr = cmd.ExecuteReader())
                {

                    sdr.Read();
                    clsFileSize.fileSizeId = Convert.ToInt32(sdr["FileSizeId"]);
                    clsFileSize.tenderSize = Convert.ToInt32(sdr["TenderSize"]);
                    clsFileSize.tenderCorigendumSize = Convert.ToInt32(sdr["TenderCorigendumSize"]);
                    clsFileSize.circularSize = Convert.ToInt32(sdr["CircularSize"]);
                    clsFileSize.govtOrderSize = Convert.ToInt32(sdr["GovtOrderSize"]);
                    clsFileSize.auctionSize = Convert.ToInt32(sdr["AuctionSize"]);
                }
            }
        }
        return clsFileSize;
    }


    public static List<clsFileSize> PopulatesFileSize()
    {
        string constring = ConfigurationManager.ConnectionStrings["ConStr2"].ConnectionString;
        List<clsFileSize> clsFileSize = new List<clsFileSize>();
        using (SqlConnection con = new SqlConnection(constring))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM T_FileSize", con))
            {
                con.Open();
                using (SqlDataReader sdr = cmd.ExecuteReader())
                {
                    while (sdr.Read())
                    {
                        clsFileSize.Add(new clsFileSize());
                        clsFileSize[clsFileSize.Count - 1].fileSizeId = Convert.ToInt32(sdr["FileSizeId"]);
                        clsFileSize[clsFileSize.Count - 1].tenderSize = Convert.ToInt32(sdr["TenderSize"]);
                        clsFileSize[clsFileSize.Count - 1].tenderCorigendumSize = Convert.ToInt32(sdr["TenderCorigendumSize"]);
                        clsFileSize[clsFileSize.Count - 1].circularSize = Convert.ToInt32(sdr["CircularSize"]);
                        clsFileSize[clsFileSize.Count - 1].govtOrderSize = Convert.ToInt32(sdr["GovtOrderSize"]);
                        clsFileSize[clsFileSize.Count - 1].auctionSize = Convert.ToInt32(sdr["AuctionSize"]);
                    }
                }
            }
        }
        return clsFileSize;
    }
}

Global.asax

    void Application_Start(object sender, EventArgs e) 
    {
        // Code that runs on application startup
        
        clsFileSize c = clsFileSize.PopulateFileSize();
        clsFileSize.TenderSize = c.tenderSize;
        clsFileSize.TenderCorigendumSize = c.tenderCorigendumSize;
        clsFileSize.CircularSize = c.circularSize;
        clsFileSize.GovtOrderSize = c.govtOrderSize;
        clsFileSize.AuctionSize = c.auctionSize;

        clsFileSize.FileSize = clsFileSize.PopulatesFileSize();
    }
    

Screenshot