Store Datagridview in Access.-VBForums
Results 1 to 2 of 2

Thread: Store Datagridview in Access.

  1. #1

    Thread Starter
    Member
    Join Date
    Jan 2013
    Posts
    58

    Store Datagridview in Access.

    Hello,

    I have a form that contains some Text strings (customer name, date etc.) and a Datagridview (15 columns and sometimes 100 records). I need to be able to store this information and bring it back into the form at a later date, I can think of several ways of doing this but probably not standard. I wish to use Access/

    My question is, without getting too detailed, How would others approach this problem ?

    Thank you.

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

    Re: Store Datagridview in Access.

    You're looking at this the wrong way around. It's not a case of storing what's in the grid in a database. It's a case of displaying what's in the database in the grid. This is standard data access so you should approach it as such. Follow the Database FAQ link in my signature below and check out the .NET resources there. In short, use a data adapter to query the database and populate a DataTable and bind that to your grid. After modifgying the data as required, use the same data adapter to save the changes back to the database.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    MSDN "How Do I?" Videos: VB | C#
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

Tags for this Thread

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.