ASP.NET

Response.Buffer = True
Response.ExpiresAbsolute = Now() - 1
Response.Expires = 0
Response.CacheControl = "no-cache"

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];

}
}
}