No data exists for the row/column error

honar abubakr

i have an error in this peace of code in my project in c# and access 2010
update_st_card is a textbox for card_id

         ol_com.CommandText = "select [card_id] from student_info where [card_id] NOT IN ('"+update_st_card.Text+"')";
                reader = ol_com.ExecuteReader();
                //current_card_id = Convert.ToInt32(update_st_card.Text.ToString());
                if ((string)reader["[card_id]"] == update_st_card.Text)
                {
                    up_st_lbl2.Text = "error card_id is entered before";
                }//end check for card id repeate or not if

                else
                {
                 //here i do update operation
                  }

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

13y ago
Always reader.HasRows to determine whether the data reader has return records from database or not.
If reader.HasRows== false then there're no records returned from the database.
If reader.HasRows== true means, the data reader contains atleast one record to read.
Iftikar Hussain13y ago
try like this

ol_com.CommandText = "select card_id from student_info where [card_id] NOT IN ('"+update_st_card.Text+"')";
reader = ol_com.ExecuteReader();
while(reader.Read())
{
if (Convert.ToString(reader["card_id"]) == update_st_card.Text)
{
up_st_lbl2.Text = "error card_id is entered before";
}//end check for card id repeate or not if
else
{
//here i do update operation
}
}
reader.close();

Regards,
Iftikar
honar abubakr13y ago
thank you iftikar for your help ... i try this also gives me an error like image in this link
http://s13.postimg.org/e7wybusgn/Capture.png
Iftikar Hussain13y ago
try like this

ol_com.CommandText = "select card_id from student_info where [card_id] NOT IN ('"+update_st_card.Text+"')";
reader = ol_com.ExecuteReader();
while(reader.Read())
{
if (Convert.ToString(reader["card_id"]) == update_st_card.Text)
{
up_st_lbl2.Text = "error card_id is entered before";
}//end check for card id repeate or not if
else
{
//here i do update operation
}
}

Regards,
Iftikar
honar abubakr13y ago
i get error like image in this link
http://s21.postimg.org/elotgvivb/Capture.png
Iftikar Hussain13y ago
Hi,
What error you are getting?

Regards,
Iftikar