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