StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12434318
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-09-15T03:43:16.740
FavoriteCount
0
LastActivityDate
2012-09-15T04:12:34.980
LastEditDate
2012-09-15T04:12:34.980
LastEditorUserId
491243
OwnerUserId
491243
ParentId
12139240
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
I think the best way is to use <code>OleDBAdapter</code> class. You need to first build your database before you proceed this process. As it is needed by the <code>OleDBAdapter</code>. If you recall, you use the DataAdapter's <code>Fill()</code> method to read the contents of a table in a database and fill our locally-cached DataTable object. There are 3 steps to saving data in ADO.Net: <ul> <li>Get a locally cached copy of the data with the <code>Fill()</code> method</li> <li>Write code (or use a control) that makes changes to the locally cached copy</li> <li>Save the changes back to the underlying database with the <code>Update()</code> method</li> </ul> Here's the code, <pre><code>Using conn As New OleDBConnection("connectionString Here") Using comm As New OleDBCommand() With comm .Connection = conn .CommandType = CommandType.CommandText .CommandText = "SELECT * FROM youTableName" End With Using adapter As New OleDBDataAdapter(comm) Dim _dataTable As New DataTable() adapter.Fill(_dataTable) 'add you records here ' ' preferably by using loop ' Dim _dataRow As DataRow _dataRow = _dataTable.NewRow() _dataRow("colNameA") = "valueA" _dataRow("colNameB") = "valueB" '........ ' _dataTable.Rows.Add(_dataRow) Dim dt_changes As DataTable dt_changes = _dataTable.Changes() If Not IsNothing(dt_changes) Then Using commBuild As OleDbCommandBuilder(adapter) Dim rowCount as Integer = adapter.Update(dt_changes) MsgBox(rowCount & " updated") End Using End If End Using End Using End Using </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSaving a Datatable created at runtime to an empty mdb
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USJohn Woo
UserOwnerUserId
1. USJohn Woo
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POSaving a Datatable created at runtime to an empty mdb
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUndeletion
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.