Error when retrieving Date type

To Be

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 !!!

1 Reply

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

Shubham Kumar10y ago
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... }