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