OledbDataReader is not retriving all the colums
<p>hey guys i'm have little problem in retrieving the data from a table here's the code: if the column in the db table is empty then the exception is thrown...</p>

<pre>
<code>
                string cmdText = "select member_id,disp_id,mobile_no,tm,pm,lm,due_date from Recharge";
                string UpdateStatus = "",hepUpdateStatus="";
                OleDbCommand cmdFinalUpdate = new OleDbCommand(cmdText, conn);
                OleDbDataReader updateReader = cmdFinalUpdate.ExecuteReader();
                if (!updateReader.HasRows) // this condition is creating problem
                    MessageBox.Show("No Data Pending For Updation");
                else
                {
                    try
                    {
                        while (updateReader.Read())
                        {
                            Program.MemberID = Convert.ToInt64(updateReader.GetInt32(0));
                            Program.DispID = updateReader.GetString(1);
                            Program.Mobile = updateReader.GetString(2);
                            Program.Tm = updateReader.GetString(3);
                            Program.Pm = updateReader.GetString(4);
                            Program.Remarks = updateReader.GetString(5);
                            Program.DueDate = updateReader.GetString(6);
                       }
                    }
                    catch (Exception) { }
                    finally
                    {
                        updateReader.Close();
                    }

                  }
</code>
</pre>

<p>The Problem is, it is giving error on Forth Column  i.e <code>Program.Pm = updateReader.GetString(4);</code> the error is <code>specified cast is not valid</code> (actually after the 3rd column it is giving exception) but im pretty sure that casting is not the issue, coz When i remove the <code>if condtion</code> at the top i.e <code>if (!updateReader.HasRows)</code> then the code works perfectly fine, i wanna know what is the problem with that reader if m checkin' that reader has rows or not ?</p>
