[Solved] System.IndexOutOfRangeException: There is no row at position 0 in ASP.Net

KatieNgo...

SOLVED CLOSED ACTIVE ANSWERED
User: KatieNgoc
Posted: on Sep 16, 2019 12:41 AM
Forum: ASP.Net Web Forms
Answer: 2
Views: 2994

I have 2 radio button list boxes, each radiolistbox has 3 radio text options to select, I will select 1 radio text for each. Next time, when i login again, (with session) it will show the selected radio text that I had selected yesterday.

When I try to run the codes as above it shown an error

System.IndexOutOfRangeException: 'There is no row at position 0.'

Do you have any idea to fix this?

<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">
    <br />
    <br />
    <br />
    Test 1
    <asp:RadioButtonList ID="RadioButtonList1" runat="server" RepeatLayout="Table" OnSelectedIndexChanged="RadioButtonList1_SelectedIndexChanged">
         <asp:ListItem Text="*Answer 1*" Value="1" />
        <asp:ListItem Text="*Answer 2*" Value="2" />
        <asp:ListItem Text="*Answer 3*" Value="3" />
    </asp:RadioButtonList>
    <br />
    <br />
    <br />
    Test2
    <asp:RadioButtonList ID="RadioButtonList2" runat="server" RepeatLayout="Table">
        <asp:ListItem Text="*Answer 1*" Value="1" />
        <asp:ListItem Text="*Answer 2*" Value="2" />
        <asp:ListItem Text="*Answer 3*" Value="3" />        
    </asp:RadioButtonList>
    <asp:Button Text="NextPage" runat="server"  OnClick="NextPage"/>
</asp:Content>

namespace Radiolistbutton
{
    public partial class _Default : Page
    {
        public string constr;
        protected void Page_Load(object sender, EventArgs e)
        {
            constr = ConfigurationManager.ConnectionStrings["Citistaff"].ConnectionString;
            if (!this.IsPostBack)
            {
                //  string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
                SqlConnection con = new SqlConnection(constr);
                SqlCommand cmd = new SqlCommand("SELECT Status1, Status2 FROM tblStatusCheck WHERE @Name = @Name", con);
                cmd.Parameters.AddWithValue("@Name", Session["Name"].ToString());
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                da.Fill(dt);
                //   con.Close();
                //   chckStatus.Checked = Convert.ToBoolean(dt.Rows[0]["Status"]);
                RadioButtonList1.SelectedValue = dt.Rows[0]["Status1"].ToString();
                RadioButtonList2.SelectedValue = dt.Rows[0]["Status2"].ToString();
            }
        }
        protected void Save(object sender, EventArgs e)
        {
            string status1 = RadioButtonList1.SelectedValue;
            string status2 = RadioButtonList2.SelectedValue;
            SqlConnection con = new SqlConnection(constr);
            SqlCommand cmd = new SqlCommand("UPDATE tblStatusCheck SET Status1 = @Status1,  Status2 = @Status2 WHERE Name = @Name", con);
            cmd.Parameters.AddWithValue("@Status1", status1);
            cmd.Parameters.AddWithValue("@Status2", status2);
            cmd.Parameters.AddWithValue("@Name", Session["Name"].ToString());
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }

        protected void NextPage(object sender, EventArgs e)
        {
            Response.Redirect("Logout.aspx");
        }

        protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
        {

        }
    }
}

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Sep 16, 2019 12:40 AM
Modified: on Sep 16, 2019 12:42 AM
Report

KatieNgoc says:
da.Fill(dt);

Based on your session value there is no record in the database.

Your Query is not returning any data.

So the error on assigning the SelectedValue.

You can ignore the error by checking the condition like below.

if (dt.Rows.Count > 0)
{
    RadioButtonList1.SelectedValue = dt.Rows[0]["Status1"].ToString();
    RadioButtonList2.SelectedValue = dt.Rows[0]["Status2"].ToString();
}

KatieNgo...

0 3

Reply
User: KatieNgoc
Replied: on Sep 16, 2019 06:51 PM
Report

What's wrong with my syntax? Server is not getting data.

Do I need to add some attribute to RadioButtonList?

        protected void Save(object sender, EventArgs e)
        {
            constr = ConfigurationManager.ConnectionStrings["Citistaff"].ConnectionString;
            string selectValue1 = this.RadioButtonList1.SelectedValue;
            string selectValue2 = this.RadioButtonList2.SelectedValue;
 
 
            SqlConnection con = new SqlConnection(constr);
            SqlCommand cmd = new SqlCommand("INSERT INTO tblStatusCheck (Name, Status1, Status2) VALUES (@Name, @Status1, @Status2)", con);
            if (con.State == ConnectionState.Closed)
 
            con.Open();
             
            cmd.Parameters.AddWithValue("@Name", Session["Name"].ToString());
            cmd.Parameters.AddWithValue("@Status1", selectValue1);
            cmd.Parameters.AddWithValue("@Status2", selectValue2);
 
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            //cmd.ExecuteNonQuery();
            con.Close();
        }

pandeyis...

0 5

Reply
ANSWER
User: pandeyism
Replied: on Sep 17, 2019 01:50 AM
Report

Hi KatieNgoc,

Take reference to below code and change your code.

Namespaces

using System.Data.SqlClient;
using System.Data;
using System.Configuration;

Code

public string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
    constr = ConfigurationManager.ConnectionStrings["Citistaff"].ConnectionString;
    if (!this.IsPostBack)
    {
        SqlConnection con = new SqlConnection(constr);
        con.Open();
        SqlCommand cmd = new SqlCommand("SELECT Status1, Status2 FROM tblStatusCheck WHERE Name = @Name", con);
        cmd.Parameters.AddWithValue("@Name", Session["Name"].ToString().Trim());
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            RadioButtonList1.SelectedValue = dt.Rows[0]["Status1"].ToString();
            RadioButtonList2.SelectedValue = dt.Rows[0]["Status2"].ToString();
        }
        con.Close();
    }
}

protected void Save(object sender, EventArgs e)
{
    constr = ConfigurationManager.ConnectionStrings["Citistaff"].ConnectionString;
    string selectValue1 = this.RadioButtonList1.SelectedValue;
    string selectValue2 = this.RadioButtonList2.SelectedValue;
    SqlConnection con = new SqlConnection(constr);
    SqlCommand cmd = new SqlCommand("INSERT INTO tblStatusCheck (Name, Status1, Status2) VALUES (@Name, @Status1, @Status2)", con);
    con.Open();
    cmd.Parameters.AddWithValue("@Name", Session["Name"].ToString());
    cmd.Parameters.AddWithValue("@Status1", selectValue1);
    cmd.Parameters.AddWithValue("@Status2", selectValue2);
    cmd.ExecuteNonQuery();
    cmd = new SqlCommand("SELECT Name, Status1, Status2 FROM tblStatusCheck WHERE Name = @Name", con);
    cmd.Parameters.AddWithValue("@Name", Session["Name"].ToString());
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    da.Fill(dt);
    if (dt.Rows.Count > 0)
    {
        RadioButtonList1.SelectedValue = dt.Rows[0]["Status1"].ToString();
        RadioButtonList2.SelectedValue = dt.Rows[0]["Status2"].ToString();
    }
    con.Close();
}

protected void NextPage(object sender, EventArgs e)
{
    Response.Redirect("Logout.aspx");
}

[Solved] System.IndexOutOfRangeException: There is no row at position 0 in ASP.Net

Company

Explore

Follow us

Contact Us