using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Data.Odbc;

namespace UACSEmployee

{

/// <summary>

/// Summary description for UAHSInfo.

/// </summary>

public class UAHSInfo : System.Web.UI.Page

{

protected System.Web.UI.WebControls.DataGrid DataGrid1;

protected System.Web.UI.WebControls.Image UAImage;

protected System.Web.UI.WebControls.Button MainButton;

private OdbcConnection mConn;

private void Page_Load(object sender, System.EventArgs e)

{

// Put user code to initialize the page here

if(!IsPostBack)

{

try

{

mConn = new OdbcConnection("DSN=webuacs;UID=bluefish;PWD=111111;");

mConn.ConnectionTimeout = 60;

mConn.Open();

OdbcCommand myComm = new OdbcCommand("{call UAHS(?)}", mConn);

myComm.CommandType = CommandType.StoredProcedure;

OdbcParameterCollection Params = myComm.Parameters;

OdbcParameter myParam = Params.Add("@command", OdbcType.VarChar);

myParam.Value = "UAHSINFO";

OdbcDataAdapter myDA = new OdbcDataAdapter(myComm);

myDA.MissingSchemaAction = MissingSchemaAction.AddWithKey;

DataSet ds = new DataSet();

myDA.Fill(ds, "UAHSINFO");

DataGrid1.DataSource = ds;

DataGrid1.DataMember = "UAHSINFO";

DataGrid1.DataBind();

}

catch(OdbcException ex)

{

Response.Write(ex.Message);

}

finally

{

mConn.Close();

}

}

}

#region Web Form Designer generated code

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: This call is required by the ASP.NET Web Form Designer.

//

InitializeComponent();

base.OnInit(e);

}

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.MainButton.Click += new System.EventHandler(this.MainButton_Click);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

}

}