import mdb to dataset ! RSS

• • Reply
  

  nazeri

  Member

  85 Points

  87 Posts

  import mdb to dataset !

  Sep 11, 2010 02:55 PM|LINK

  hi

  i have a mdb file in local disk >>  c:\test.mdb

  and i have a dataset file in my project >> "~/app_code/test_ds.xsd"

  how i can make a TableAdapter in my dataset  for importing data from this  mdb file ?

  
  

  mdb datase datasource ado

  • Moved by MetalAsp.Net on Sep 11, 2010 03:07 PM
• • Reply
  

  CandorZ

  Participant

  1346 Points

  275 Posts

  Re: import mdb to dataset !

  Sep 11, 2010 06:36 PM|LINK

  Simple steps:

  
  1. Go to Server Explorer (Ctrl +Alt + S)
  2. Right Click on Data Connections -> Add Connection
  3. Data source -> Change -> MS Access DB file -> OK
  4. Database Filename -> Browse -> Select "c:\test.mdb"
  5. Fill Username, pass if any -> Test Connection
  6. If OK, you will have the test.mdb connection in your Server Explorer
  7. Select the table and drag and drop in the xsd
  8. Ready to GO!

  • Marked as answer by nazeri on Sep 13, 2010 10:54 AM