Results 1 to 7 of 7

Thread: [RESOLVED] Access Database write Problem

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member Skatebone's Avatar
    Join Date
    Jan 2009
    Location
    Malta
    Posts
    279

    Resolved [RESOLVED] Access Database write Problem

    Ok i fixed my problem now but what's happening is that the data is always being overwrited. I mean there is only one row which is constantly being overwrited

    Code:
    Public Class Form1
    
        Private Sub UpdateTable(ByVal Details As String())
            Dim DataSet As New LoginServerDataSet
            Dim Adapter As New LoginServerDataSetTableAdapters.DetailsTableAdapter
            Dim Manager As New LoginServerDataSetTableAdapters.TableAdapterManager
    
            Manager.DetailsTableAdapter = Adapter
            DataSet.Details.Rows.Add(Details)
            Manager.UpdateAll(DataSet)
    
        End Sub
    
        Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            UpdateTable({"1", "Name3", "Pass"})
        End Sub
    
    End Class
    Thanks in advance =]
    Last edited by Skatebone; Feb 15th, 2011 at 12:40 PM.
    Life runs on code

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width