ASP.NET

CREATE TRIGGER Changed

ON dbo.Products

AFTER INSERT, UPDATE, DELETE

AS

Update  TableChanged Set Changed = 1 WHERE TableName='Products' 

If Not IsPostBack Then            
Dim dv As DataView
            Dim changed As Boolean = Global.CheckChanged("Products")
            If changed Then
                dv = LoadDV()
            Else
                dv = Cache("cachedDV")
                If dv Is Nothing Then 'in case application restarts, changed will be false and dv null
                    LoadDV()
                    dv = Cache("cachedDV")
                End If
            End If

Protected Function LoadDV() As DataView
        Dim dt As DataTable = Product.GetDiscounted
        Dim dv As DataView = New DataView(dt)
        Global.UpdateChanged("Products")
        Cache("cachedDV") = dv
        Return dv
    End Function

ALTER PROCEDURE dbo.TableChangedCheck
	@sTable varchar(20)
AS
	SET NOCOUNT ON
	Select Changed From TableChanged WHERE TableName=@sTable
	RETURN

ALTER PROCEDURE dbo.TableChangedUpdate
	@sTable varchar(20)
AS
	SET NOCOUNT ON
	UPDATE TableChanged SET Changed = 0 WHERE TableName=@sTable
	RETURN

public void SetListViewDataSource(List<BaseBO> data)
{
    this.ListView.DataSource = data;
    this.ListView.DataBind();
}

public void SetListViewDataSource<T>(List<T> data) where T : BaseBO, new()
{
    this.ListView.DataSource = data;
    this.ListView.DataBind();
}

string[] dirs = targetDirectory.Split(Path.DirectorySeparatorChar);
foreach (string dir in dirs)
{
   string adir = "." + Path.DirectorySeparatorChar + dir;
   if (!Directory.Exists(adir))
   {
      Directory.CreateDirectory(adir);
   }
   Environment.CurrentDirectory = adir;
}

protected void Page_Load(object sender, EventArgs e)
        {
            Control ce = LoadControl("TimeEntry.ascx");
            pnlProjects.Controls.Add(ce);

            foreach(Control ctl in pnlProjects.Controls)
                if (ctl.GetType() == typeof(TimeEntry))
                {
                    TimeEntry te = (TimeEntry)ctl;
                    te.LoadControls();
                }
        }

LoadControls();