protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (IDbConnection conn = installer.GetConnection())
{
conn.Open();
string discriminator = GetDiscriminator(conn, int.Parse(Request["id"]));
string itemsSql = string.Format("select * from {0}item where Type = '{1}'", tablePrefix, discriminator);
using (IDbCommand cmd = installer.GenerateCommand(CommandType.Text, itemsSql))
{
cmd.Connection = conn;
dgrItems.DataSource = cmd.ExecuteReader();
}
ddlType.DataSource = N2.Context.Definitions.GetDefinitions();
DataBind();
}
}
}
protected void btnTest_Click(object sender, EventArgs e)
{
try
{
InstallationManager im = Installer;
using (IDbConnection conn = im.GetConnection())
{
conn.Open();
lblStatus.CssClass = "ok";
lblStatus.Text = "Connection OK";
}
}
catch (Exception ex)
{
lblStatus.CssClass = "warning";
lblStatus.Text = "Connection problem, hopefully this error message can help you figure out what's wrong: <br/>" +
ex.Message;
lblStatus.ToolTip = ex.StackTrace;
}
}
