ASP.NET

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
namespace Supply_Chain
{
public partial class _Default : System.Web.UI.Page
{

// connString=@/"Driver={IBM DB2 ODBC DRIVER};Database=DB2data;Hostname=serverName;Port=446; Protocol=TCPIP;Uid=DB2data;Pwd=DB2data";
OleDbConnection conn = new OleDbConnection();

//conn.ConnectionString = @\"Driver=DB2OLEDB;Initial Catalog=BBTFILEA;User id=KSUNDER;Port=23;Hostname=10.140.201.21;Password=welcome1;"); 

//DataBase=BBTFILEA;Protocol=TCPIP;Port=23;Hostname=10.140.201.21;Uid=KSUNDER;Pwd=welcome1;";
// public string connString = ConfigurationManager.ConnectionStrings["DB2LOGIN"].ConnectionString;


protected void Page_Load(object sender, EventArgs e)
{
string connString = @"Provider=IBMDADB2;Database=BBTFILEA;Uid=KSUNDER;Protocol=TCPIP;Port=23;Hostname=10.140.201.21;Pwd=welcome1;"; 
DataTable dt = new DataTable();
dt = DB2data(null, null, connString);
}
public DataTable DB2data(OleDbParameter[] Params, string spName, string connString)
{

DataSet ds = new DataSet();

using (OleDbConnection DBConn = new OleDbConnection(connString))
{
DBConn.Open();
Response.Write("CONNECTED TO DB2");
DBConn.Close();
}



return ds.Tables[0];

}
}
}

        public ViewResult Index()
        {
var observations = db.Observations
                .Include("Claim").Include("Defect").Include("InspectionType")
                .Include("Location").Include("Property");
            ViewBag.defectId = new SelectList(db.Defects, "id", "displayId");
            return View(observations.ToList());
        }
        public ViewResult Search(int defectId)
        {
var observations = db.Observations
                .Include("Claim").Include("Defect").Include("InspectionType")
                .Include("Location").Include("Property").Where(o => o.defectId == defectId);
            return View(observations.ToList());
        }

@Html.DropDownList("defectId", String.Empty)
@Html.ActionLink("Search","Search", new { defectId=??????????????})

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