Results 1 to 5 of 5

Thread: Access table in DBGrid [Please resolve]

Threaded View

  1. #1

    Thread Starter
    Fanatic Member pvbangera's Avatar
    Join Date
    Sep 2001
    Location
    Mumbai, India
    Posts
    961

    Access table in DBGrid [Please resolve]

    I use the following code to list all the tables in an mdb file.



    VB Code:
    1. dbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBName & ";Persist Security Info=False")
    2. dbConnection.Open()
    3. lstObjects.DataSource = dbTable

    The code is working fine. But I dont want to list all the columns (like Table_Catalog, Table_Schema, etc). I just want only 4 cols (Name, Description, Date created and Date modified)

    Also, after listing the tables, how to open a selected table from the list in DBGrid? I am finding ADO.Net very much confusing.

    Please guide.

    Regards
    Last edited by pvbangera; Mar 5th, 2004 at 02:29 AM.

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