SQLdataAdapator

2005-09-05
2013-04-15
  • Nobody/Anonymous

    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.

       
    • Nobody/Anonymous

      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

         
    • Nobody/Anonymous

      IDIOT!!!!

      Sorry Robert and thanks for your time.

      I was using the wrong dll!!!

       

Log in to post a comment.