Click here to Skip to main content
15,900,973 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
code:
C#
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();


What I have tried:

checked the database for spelling mistakes...
Posted
Updated 14-Mar-16 21:32pm
Comments
Patrice T 15-Mar-16 3:12am    
Give exact error message.

You should check that rd2 contain something.
 
Share this answer
 
This exception occurred when you don't have requested member in your list, from your code snippet it looks
- your 'City' datable does not contains, "T1_name" column
- Check if you got record in datareader, I mean if your record is not fetched from database and reader is empty then also it will throw same exception

(Here I want to clarify something, When datareader is NULL and you are trying to fetch record from it then it throws "Object reference..." error and if datareader is not null but datareader has not value and you are trying to fetch record from it then it throws "IndexOutOf.." exception)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900