protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack == false)
        {
            SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\userside.mdf;Integrated Security=True;User Instance=True");

            string str;
            str = "select * from Screen_managment where screenname = 'Screen_1'";


            SqlCommand cmd = new SqlCommand(str, con);

            con.Open();

            SqlDataReader dr;
            dr = cmd.ExecuteReader();

            //DataList1.DataSource = dr;
            //DataList1.DataBind();

            drptheatre.DataSource     = m.GetDataReaderQuery("select * from TheatreMaster");
            drptheatre.DataValueField = "TheatreId";
            drptheatre.DataTextField  = "TheatreName";
            drptheatre.DataBind();
            drptheatre.Items.Insert(0, "Select Theatre");

            drpcity.DataSource     = m.GetDataReaderQuery("select * from City");
            drpcity.DataValueField = "CityId";
            drpcity.DataTextField  = "CityName";
            drpcity.DataBind();
            drpcity.Items.Insert(0, "Select City");
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack == false)
        {
            drptheater.DataSource     = m.GetDataReaderQuery("select * from TheatreMaster");
            drptheater.DataValueField = "TheatreId";
            drptheater.DataTextField  = "TheatreName";
            drptheater.DataBind();
            drptheater.Items.Insert(0, "Select Theatre");

            drpcity.DataSource     = m.GetDataReaderQuery("select * from City");
            drpcity.DataValueField = "CityId";
            drpcity.DataTextField  = "CityName";
            drpcity.DataBind();
            drpcity.Items.Insert(0, "Select City");
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        SqlDataReader dr = m.GetDataReaderQuery("select * from Seat_Master,Screen_managment where Seat_Master.Seattype = '" + DropDownList1.SelectedItem.Text + "' and Screen_managment.movieid=" + Session["movieid"] + " and Screen_managment.TheatreId=Seat_Master.TheatreId");

        while (dr.Read())
        {
            lblSeatType.Text = dr["Price"].ToString();
            lblRate.Text     = dr["Price"].ToString();
        }

        if (IsPostBack == true)
        {
            int a = Convert.ToInt32(lblSeatType.Text);
            int b = Convert.ToInt32(DropDownList2.SelectedItem.Text);

            int c = a * b;
            lblRate.Text = Convert.ToString(c);
        }
        if (DropDownList1.SelectedItem.Text == "Club")
        {
            DataList5.Visible = false;
            DataList8.Visible = false;
            DataList7.Visible = true;
        }


        else if (DropDownList1.SelectedItem.Text == "Gold")
        {
            DataList7.Visible = false;
            DataList8.Visible = false;
            DataList5.Visible = true;
        }

        else
        {
            DataList7.Visible = false;
            DataList5.Visible = false;
            DataList8.Visible = true;
        }
    }