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.
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;
}
CREATE TABLE T_FileSize
(
FileSizeId INT IDENTITY(1,1) PRIMARY KEY,
TenderSize INT ,
TenderCorigendumSize INT,
CircularSize INT,
GovtOrderSize INT,
AuctionSize INT
)