Handling DataTable Error: There is no row at position 0 in C# and VB.Net

micah

SOLVED CLOSED ACTIVE ANSWERED
User: micah
Posted: on Nov 14, 2018 10:55 PM
Forum: Data Controls
Answer: 1
Views: 25097

Hi i have a dropdown select that selects and updates label, my challenge is that if there is no roll when the dropdown is selected it will show this error

Server Error in '/' Application.
There is no row at position 0.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: There is no row at position 0.

Source Error:


Line 70:         Panel pn = (Panel)ddlCategory.FindControl("Panel2");
Line 71:         pn.Visible = true;
Line 72:         lblMessage2.Text = dt.Rows[0]["Quantity_Remaining"].ToString();
Line 73:         //Label lblMessage2 = (Label)ddlitem.FindControl("ltText");
Line 74: 

code

so my question is how do i display a nice message to the user that there is no item row to display instead of showing this error

code

    protected void ddlCategory_SelectedIndexChanged(object sender, EventArgs e)
    {
        DataTable dt = GetDataTable("SELECT Quantity_Remaining FROM MainWareHouse WHERE Category = '" + ddlCategory.SelectedItem.Text.Trim() + "'");
        // DataTable dt2 = GetDataTable("SELECT Debt FROM CustomerDetail WHERE CustomerPhone = '" + ddlcustomerphone.SelectedItem.Text.Trim() + "'");
        // lblOlDebt.Text = dt.Rows[0]["Debt"].ToString();

        //lblQuantityAvailable.Text = dt.Rows[0]["Rows_In_Carton"].ToString();
        Panel pn = (Panel)ddlCategory.FindControl("Panel2");
        pn.Visible = true;
        lblMessage2.Text = dt.Rows[0]["Quantity_Remaining"].ToString();
        //Label lblMessage2 = (Label)ddlitem.FindControl("ltText");

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Nov 14, 2018 11:01 PM
Modified: on Nov 14, 2018 11:53 PM
Report

Hi micah,

There may be records in database but the query you are firing is not returning records hence the error. Please verify the SQL Query and then run it in SQL Server.

You can handle this error by checking row count condition.

protected void ddlCategory_SelectedIndexChanged(object sender, EventArgs e)
{
    DataTable dt = GetDataTable("SELECT Quantity_Remaining FROM MainWareHouse WHERE Category = '" + ddlCategory.SelectedItem.Text.Trim() + "'");
    Panel pn = (Panel)ddlCategory.FindControl("Panel2");
    pn.Visible = true;
    if (dt.Rows.Count > 0)
    {
        lblMessage2.Text = dt.Rows[0]["Quantity_Remaining"].ToString();
    }
    else
    {
        lblMessage2.Text = "No value found, please check again";
    }
}

VB.Net

Protected Sub ddlCategory_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
    Dim dt As DataTable = GetDataTable("SELECT Quantity_Remaining FROM MainWareHouse WHERE Category = '" & ddlCategory.SelectedItem.Text.Trim() & "'")
    Dim pn As Panel = CType(ddlCategory.FindControl("Panel2"), Panel)
    pn.Visible = True
    If dt.Rows.Count > 0 Then
        lblMessage2.Text = dt.Rows(0)("Quantity_Remaining").ToString()
    Else
        lblMessage2.Text = "No value found, please check again"
    End If
End Sub

Handling DataTable Error: There is no row at position 0 in C# and VB.Net

Company

Explore

Follow us

Contact Us