Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

VB Express 2008 - Loading Data


  • Please log in to reply

#1
notquiteanexpert

notquiteanexpert

    Member

  • Member
  • PipPip
  • 17 posts
Hi guys,

I'm experienced with VBA, but new to VB.net. I'm using VB express 2008 and want to know how to read/write from a local database (.sdf) using the equivalent of recordsets etc.

I have checked forums everywhere & sample code and can't find exactly what I'm after. Most sample code show you how to output data in the db table to the datagridview and allow you to modify directly from there. Rather than this, I want to read all records from a table into a recordset or array, then be able to add additional records or modify existing ones all from the recordset or array.

Can someone please help me with the above (supposedly) relatively simple request?? I don't know a lot about TableAdapters etc, so it would be appreciated if you could be simple with your response!!

Thanks so much in advance.
  • 0

Advertisements


#2
notquiteanexpert

notquiteanexpert

    Member

  • Topic Starter
  • Member
  • PipPip
  • 17 posts
Hi guys,

Please disregard - I've worked it out through trial and error.

For those interested, I used tableadapters and datasets...(this is probably very simple for those who know what they're doing!!).

Cheers
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP