using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Text.RegularExpressions;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ListBoxMeetings.Items.Clear();
        GetMeetings();
    }
    public int MeetingID;

    public void GetMeetings()
    {
        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

        SqlConnection conn;
        SqlCommand cmd;

        string sql = "SELECT MeetingName, Date, Time FROM Users, Meetings, Occasions WHERE Meetings.OccasionID=Occasions.OccasionID";
        conn = new SqlConnection(connStr);
        conn.Open();
        cmd = new SqlCommand(sql, conn);
        SqlDataReader myReader;
        myReader = cmd.ExecuteReader();
        while (myReader.Read())
            ListBoxMeetings.Items.Add(myReader["MeetingName"].ToString() + " | Datum: " + myReader["Date"].ToString() + " | Tid: " + 		myReader["Time"].ToString());
        conn.Close();

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        TextBoxAndraNamn.Visible = true;
    }