Results 1 to 2 of 2

Thread: Store Datagridview in Access.

  1. #1

    Thread Starter
    Join Date
    Jan 2013

    Store Datagridview in Access.


    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
    Sydney, Australia

    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
    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


Click Here to Expand Forum to Full Width