public partial class Movie : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Admin\Documents\Visual Studio 2010\WebSites\WebSite1\App_Data\Database.mdf;Integrated Security=True;User Instance=True"); con.Open(); SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select * from Movies where M_name='"+Session["M_name"]+"'"; cmd1.Connection = con; SqlDataReader rd1 = cmd1.ExecuteReader(); rd1.Read(); lbl1.Text = rd1["M_name"].ToString(); Image1.ImageUrl = rd1["M_image"].ToString(); lbl2.Text = rd1["M_genre1"].ToString(); lbl3.Text = rd1["M_genre2"].ToString(); lbl4.Text = rd1["M_genre3"].ToString(); lbl5.Text = rd1["M_genre4"].ToString(); lbl6.Text = rd1["M_genre5"].ToString(); lbl7.Text = rd1["M_genre6"].ToString(); lbl8.Text = rd1["M_director"].ToString(); lbl9.Text = rd1["M_cast1"].ToString(); lbl10.Text = rd1["M_cast2"].ToString(); lbl11.Text = rd1["M_cast3"].ToString(); lbl12.Text = rd1["M_cast4"].ToString(); lbl13.Text = rd1["M_plot"].ToString(); rd1.Close(); if (Session["C_name"] != null) { SqlCommand cmd2 = new SqlCommand(); cmd2.CommandText = "select * from City where C_name='" + Session["C_name"] + "'"; cmd2.Connection = con; SqlDataReader rd2 = cmd1.ExecuteReader(); rd2.Read(); lbl14.Text = rd2["T1_name"].ToString();//index out of range exception from this line... lbl15.Text = rd2["T1_address"].ToString(); lbl16.Text = rd2["T2_name"].ToString(); lbl17.Text = rd2["T2_address"].ToString(); lbl18.Text = rd2["T1T1"].ToString(); lbl19.Text = rd2["T1T2"].ToString(); lbl20.Text = rd2["T1T3"].ToString(); lbl21.Text = rd2["T2T1"].ToString(); lbl22.Text = rd2["T2T2"].ToString(); lbl23.Text = rd2["T2T3"].ToString();
rd2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)