Error when retrieving Date type

Question

Hi  I have one application return Customer details . I can view all customers details except one customer it will gives me always this error there is no row at position 0 code : txtOrderDate.Text = System.DBNull.Value.ToString txtOrderDate.Text = Convert.ToDateTime(MyDs.Tables(OO).Rows(0)( OrderDate )).ToString(dd / MM / yyyy) . I checked all Orderdate in the Database it's all same format but i don't know why it's happening for this customer only !!!

Shubham Kumar · Answer

Hi You're not checking if your tables have got any content. The message is clear - there is no row at position 0. It is probably being thrown on this line or one if ( MyDs.Tables .Rows.Count > 0) { // Fetch the data... } else { // Handle missing data in an appropriate way... }