Access db to ado.net data type conversions?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Brian Henry
    #1

    Access db to ado.net data type conversions?

    is there info about data type conversions between access to ado.net? I have
    tried a lot of the ones that say oledb data types should work for and get a
    lot of "data type mismatch" errors using them.. is there a sheet somewhere
    or a refrence for them? all i really need to know is

    Access ADO.NET
    Numeric Integer/numeric?
    Memo VarWChar?
    Text VarWChar?
    Date/Time ? (dbdate never seems to work)
    Yes/No Boolean

    what are the correct conversions of oledb.oledbtype ? thanks!


    Tags: None
    • WizyDig
      #2
      Re: Access db to ado.net data type conversions?

      I'll give a very simple way to solve your problem and hopefully help you
      stream line your develpment. Open a connection to you access mdb using the
      server expolerer. Drag the table you want to use onto your form this will
      create a connection object and a data adpater. Look on the tool bar for the
      Data menu item click on it the click generate dataset. This will give you a
      strongly type dataset that you can use through out your app.

      FYI you can even specify which column you want by opening up the table and
      highlighting specific fields. You can also change these by opening the data
      adapters select commands text attribute. it will open a query builer that
      will allow to build what ever type of query make you happy.

      Hope this helps you!

      -Wiz



      "Brian Henry" <brianiup@adelp hia.net> wrote in message
      news:uBjD5dcjDH A.2244@TK2MSFTN GP12.phx.gbl...[color=blue]
      > is there info about data type conversions between access to ado.net? I[/color]
      have[color=blue]
      > tried a lot of the ones that say oledb data types should work for and get[/color]
      a[color=blue]
      > lot of "data type mismatch" errors using them.. is there a sheet somewhere
      > or a refrence for them? all i really need to know is
      >
      > Access ADO.NET
      > Numeric Integer/numeric?
      > Memo VarWChar?
      > Text VarWChar?
      > Date/Time ? (dbdate never seems to work)
      > Yes/No Boolean
      >
      > what are the correct conversions of oledb.oledbtype ? thanks!
      >
      >[/color]


        Comment

        • Paul Clement
          #3
          Re: Access db to ado.net data type conversions?

          On Wed, 8 Oct 2003 14:10:34 -0400, "Brian Henry" <brianiup@adelp hia.net> wrote:

          ¤ is there info about data type conversions between access to ado.net? I have
          ¤ tried a lot of the ones that say oledb data types should work for and get a
          ¤ lot of "data type mismatch" errors using them.. is there a sheet somewhere
          ¤ or a refrence for them? all i really need to know is
          ¤
          ¤ Access ADO.NET
          ¤ Numeric Integer/numeric?
          ¤ Memo VarWChar?
          ¤ Text VarWChar?
          ¤ Date/Time ? (dbdate never seems to work)
          ¤ Yes/No Boolean
          ¤
          ¤ what are the correct conversions of oledb.oledbtype ? thanks!
          ¤

          OLE fields are System.Data.Ole Db.OleDbType.Lo ngVarBinary

          You can compare the System.Data.Ole Db.OleDbType enum with ADOX.DataTypeEn um in order to determine
          the corresponding data column types.


          Paul ~~~ pclement@amerit ech.net
          Microsoft MVP (Visual Basic)

            Comment

            Previous template Next
            Working...