Share via

ADP_ConnectionRequired_Fill

  • Article
  • 03/27/2008

Question

Thursday, March 27, 2008 3:50 AM | 1 vote

Any idea what causes a System.InvalidOperationException with the message:

The resource ADP_ConnectionRequired_Fill was not found in System.Data

When in generated data set code the Fill is called:

myDBDataSet.client_case_planDataTable dataTable = new myDBDataSet.clientDataTable();
this.Adapter.Fill(dataTable);

Thanks

All replies (3)

Tuesday, April 8, 2008 8:23 AM

Hi

 

I want to know the SQL Server Compact version that you are using and the locale of the application and the Sql Server Compact. Please provide the call stack of the Exception as it would help to resolve the issue.

 

Please also mention the enviorment (OS type,OS locale etc.) in which you see this error.

 

Thanks & Regards

Devesh Anand

Monday, August 18, 2008 9:46 PM | 1 vote

For anyone else who's encountered this error, this typically occurs when you create your SqlCommand object using the constructor (SqlCommand command = new SqlCommand()) instead of creating it using SqlConnection.CreateCommand() like you're supposed to. The error is complaining, in its oblique way, that the command has not been associated with a connection yet.

Derrick Coetzee

Thursday, December 27, 2012 11:35 AM

My Program also produced this error.

PDA OS: wince 6.0 .

      public static DataSet GetDataSet(string Querystr, SqlConnection connStr)
     {
             DataSet ds = new DataSet("SqlDataset");
             SqlDataAdapter da = new SqlDataAdapter(Querystr, connStr);
             try
            {
                     da.Fill(ds);
                     return ds;
            }
            catch (Exception ex)
            {   
                    MessageBox.Show("DAL.SQL.GetDataSet:" + ex.Message,"error");
                    return null;
            }
     }