SQLdataAdapator

2005-09-05
2013-04-15
  • Can this be used with VB.net?

    If so how?

     
    • Robert Simpson
      Robert Simpson
      2005-09-05

      The SqlDataAdapter is for SQL Server.  SQLite's ADO.NET wrapper has a SQLiteDataAdapter.  Download the binaries from this website, go into your VB.NET program, right-click the project and Add Reference.  Browse for the SQLite.NET.DLL and add it.

       
    • Hi Robert,

      Thanks for the reply. Excuse my poor spelling. I didn't expect anyone to get back to me.

      I have done as you said. When I create a new SQLiteDataAdapator I get the following error on build:

      Reference required to assembly 'System.Data.Common' containing the base class 'System.Data.Common.DbDataAdapter'. Add one to your project.

      Now if I add a reference to System.Data.Common, I get the following error on build:

      Unable to load DLL (coredll)

      I can't understand it or find any information on the problem!

       
      • Robert Simpson
        Robert Simpson
        2005-09-06

        coredll is for the Compact Framework.  Perhaps we should start with the basic question:

        Are you writing for the Compact Framework or for the desktop (Full Framework) ?

        Robert

         
    • IDIOT!!!!

      Sorry Robert and thanks for your time.

      I was using the wrong dll!!!