private void ShowJoke() { SqlConnection conn = new SqlConnection(dbconn.Configuration()); SqlCommand cmd = null; SqlDataReader rdr = null; string sqlsel = "select caption, picture from selection, joke where fk_joke = joke.id"; try { conn.Open(); cmd = new SqlCommand(sqlsel, conn); rdr = cmd.ExecuteReader(); RepeaterJoke.DataSource = rdr; RepeaterJoke.DataBind(); } catch (Exception ex) { //LabelMessage.Text = ex.Message; } finally { conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(@"data source = .\sqlexpress; integrated security = true; database = CMS;"); SqlCommand cmd = null; SqlDataReader rdr = null; string sqlsel1 = "SELECT mainItem, category, headline, picture, text FROM Selection, Items WHERE Selection.mainItem = Items.itemID "; string sqlsel2 = "SELECT secondItem, category, headline, picture, text FROM Selection, Items WHERE Selection.secondItem = Items.itemID "; string sqlsel3 = "SELECT thirdItem, category, headline, picture, text FROM Selection, Items WHERE Selection.thirdItem = Items.itemID "; string sqlsel4 = "SELECT Selection.jokeId, Jokes.caption, Jokes.img FROM Selection, Jokes WHERE Selection.jokeId = Jokes.jokeID"; try { conn.Open(); cmd = new SqlCommand(sqlsel1, conn); rdr = cmd.ExecuteReader(); RepeaterMainItem.DataSource = rdr; RepeaterMainItem.DataBind(); } catch (Exception ex) { LabelFooter.Text = ex.Message; } finally { conn.Close(); } try { conn.Open(); cmd = new SqlCommand(sqlsel2, conn); rdr = cmd.ExecuteReader(); RepeaterSecond.DataSource = rdr; RepeaterSecond.DataBind(); } catch (Exception ex) { LabelFooter.Text = ex.Message; } finally { conn.Close(); } try { conn.Open(); cmd = new SqlCommand(sqlsel3, conn); rdr = cmd.ExecuteReader(); RepeaterThird.DataSource = rdr; RepeaterThird.DataBind(); } catch (Exception ex) { LabelFooter.Text = ex.Message; } finally { conn.Close(); } try { conn.Open(); cmd = new SqlCommand(sqlsel4, conn); rdr = cmd.ExecuteReader(); RepeaterJoke.DataSource = rdr; RepeaterJoke.DataBind(); } catch (Exception ex) { LabelFooter.Text = ex.Message; } finally { conn.Close(); } }