Results 1 to 8 of 8

Thread: [02/03] Simple Access Database Update Program

  1. #1

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    41

    [02/03] Simple Access Database Update Program

    Hey guys, I developed a Multidementional Array to store values and data of clients. Now I need to use a Access Database instead of a array. I need to be able to add clients, add values, and add information to the access database and with the click of a button be able to UPADATE the database and save the information Dynamically.

    I know I need to use Microsoft.Jet.OLEDB.4.0. I was wondering if ya'll had any sites that could help me out. I am doing this for school, and it basically depends on if I graduate college or not this year. Please Help ya'll have been more than helpful in the past. Thanks!

    God Bless - Dave

  2. #2
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    105,436

    Re: [02/03] Simple Access Database Update Program

    There are numerous tutorials in my signature that have information on ADO.NET. The Start VB.NET site has a section dedicated to Access. Any infornation on ADO.NET is relevant though as the changes required for different data sources are minimal.

  3. #3

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    41

    Re: [02/03] Simple Access Database Update Program

    That was helpful, but in my project.... I need to

    Add a record/row
    Move Forwards in the Database (next record)
    Move Backwards in the Database (previous record)
    Delete any record/row
    Modify any record

    I will have text boxes and buttons

    my database name is checkbookDB and the table i will be using is called MasterTable

    thanks!

  4. #4

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    41

    Re: [02/03] Simple Access Database Update Program

    I need to know how to click on a record in the database (through VB.Net) and then the cell under "CoName" to appear in a TextBox on my FORM

  5. #5
    Frenzied Member
    Join Date
    Jul 2005
    Posts
    1,168

    Re: [02/03] Simple Access Database Update Program

    See if this helps:

    http://www.vbforums.com/showthread.php?t=401659

    it uses a datagrid to add, delete, and edit/update a database.

  6. #6

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    41

    Re: [02/03] Simple Access Database Update Program

    but will that put a row or value of a cell into a TextBox.Text for me?

  7. #7

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    41

    Re: [02/03] Simple Access Database Update Program

    I want to be able to MOVE rows up and down in the database, but I cant get it to do so.

    here is my code... I can add items and delete items but only the top row at all times.

    VB Code:
    1. Dim ThisRowIndex As Integer
    2.     Private Sub MoveUp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MoveUp.Click
    3.         If Me.BindingContext(DataSet11, "MasterTable").Position > 0 Then
    4.             Me.BindingContext(DataSet11, "MasterTable").Position -= 1
    5.             ThisRowIndex = Me.BindingContext(DataSet11, "MasterTable").Position
    6.             Label1.Text = ThisRowIndex
    7.         End If
    8.     End Sub

    please HELP!

    not using SQL

  8. #8

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    41

    Re: [02/03] Simple Access Database Update Program

    hello......... bump

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