Getting query status while using SQLDataAdapter's Fill Method(Disconnected Mode)?

See more:

ASP.NET

.NET

ADO.NET

C#3.5

.NET4

Hi All,

I have a basic simple problem,i am trying to get the result of query executed or not when i try to insert a row into the database using dataadapter's fill method.
I know i can achieve the same using Connected Mode SqlCommand's ExecuteNonQuery method.
But i do not want to do that way , Is there any chance that i can get the result whether row has inserted into database or not using dataadapter's fill method ..
Below is my code.

using (SqlDataAdapter da = new SqlDataAdapter("SomeInsertQuery"))
{
  using (DataSet ds = new DataSet())
   {
                                        
    da.Fill(ds);
//here i need to check whether insertion is successful or not so that i can display proper error message...

    if (!String.IsNullOrEmpty(successMsg))
    {  
      PSVMsgBox.ShowDALMsgBox(successMsg);
    }
                                        
   }
}
Thanks in Advance.