如何处理IndexOutOfRange异常 [英] how to handle IndexOutOfRange Exception

问题描述

我的代码

My code

string qyery1 = "SELECT Ticket_Id FROM Booking_table WHERE seats = '" + lblseats.Text + "' AND Journey_date = '" + lblDate.Text + "'";
OleDbCommand cmd1 = new OleDbCommand(qyery1, con);
OleDbDataReader dr1 = cmd.ExecuteReader();
while (dr1.Read())
{
    lblTicketNo.Text = dr1["Ticket_Id"].ToString();
    
    //Error IndexOutOfRange Occured
}

Ticket_Id 是来自Booking_table的主键，



发生循环错误 IndexOutOfRange 。

如何处理此异常..

Ticket_Id is primary key from Booking_table,

In side While Loop error occurred IndexOutOfRange.
How to handle this Exception..

推荐答案

我会说，试试这个，

SqlDataReader.IsDBNull [ ^ ]

和

DBNull.Value [ ^ ]

I'd say, try with this,
SqlDataReader.IsDBNull[^]
and
DBNull.Value[^]

while (dr1.Read())
{
    if(rd1["Ticket)Id"] != DBNull.Value)
        lblTicketNo.Text = dr1["Ticket_Id"].ToString();
}

-KR

-KR

更改此代码如



var i = 0

Hi,

Change this code like as

var i=0

while (dr1.Read())
{
    lblTicketNo.Text = dr1[i].ToString();
    //you should mention the index of the reader not in primary key.
    i++;
    //Error IndexOutOfRange Occured
}

试试这个

try this

lblTicketNo.Text = dr1[0].ToString();

这篇关于如何处理IndexOutOfRange异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！