>I think you mean "if loData is a Dataset"....loDT is your data adapter.

Thanks, I will adjust.

>If the query returns no records, you can probably determine that by checking for the table count or row count of loData (depending on how many tables were in your result set) example... if (MyDataSet.Tables.Count>0)...or if(MyDataSet.Tables[0].Rows.Count > 0)

Yes, this is working.

Thanks