Default.aspx:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" Debug="true" %>
Database Test Page
User Data
<%= presentationData[0] %>
<%= presentationData[1] %>
Default.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected String[] presentationData;
//Main controller
protected void Page_Load(object sender, EventArgs e)
{
DataAccessObject dao = new DataAccessObject();
BusinessLogic bl = new BusinessLogic(dao);
presentationData = bl.computeData();
}
}
class BusinessLogic
{
private DataAccessObject dao;
public BusinessLogic(DataAccessObject d)
{
dao = d;
}
public String[] computeData()
{
String[] data = dao.getUserData();
return data;
}
}
class DataAccessObject
{
public String[] getUserData()
{
string DataSource = "isel.cs.unb.ca";
string Database = "cs4025a2";
string UserID = "wdu";
string Password = "cs4025";
string MyConString = "Data Source=" + DataSource + ";Database=" + Database + ";User ID=" + UserID + ";Password=" + Password;
MySqlConnection mycon = new MySqlConnection(MyConString);
mycon.Open();
MySqlCommand cmd = new MySqlCommand("select * from userinfo", mycon);
MySqlDataReader reader = cmd.ExecuteReader();
String[] resultData = new String[2];
int i = 0;
while (reader.Read())
{
resultData[i] = reader.GetString(0);
resultData[i] = resultData[i] + " " + reader.GetString(1);
resultData[i] = resultData[i] + " " + reader.GetString(2);
i++;
}
return resultData;
}