dcsimg
Results 1 to 2 of 2

Thread: How to Avoid Temporary Tables in ComboBOX?

  1. #1

    Thread Starter
    Member
    Join Date
    May 2019
    Posts
    39

    How to Avoid Temporary Tables in ComboBOX?

    Its Hard to see that some of the Temporary Tables is loaded with User added tables, how to avoid that even after adding the restriction property.

    Name:  temp table.jpg
Views: 149
Size:  32.1 KB



    Code:
      Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            DataGridView1.EditMode = False
            txtID.ReadOnly = True
            da.MissingSchemaAction = MissingSchemaAction.AddWithKey
            cnn.ConnectionString = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Projects\Library Frontend\Database\Backup\Mentor_DX_Library_Database.accdb;Persist Security Info=False;")
            Try
                cnn.Open()
                'Filter out the temporary tables
                Dim restrictions() As String = New String(3) {}
                restrictions(3) = "Table"
                Me.ComboBox1.DisplayMember = "TABLE_NAME"
                Me.ComboBox1.DataSource = cnn.GetSchema("Tables", restrictions)
                DataGridView1.BeginEdit(False)
            Catch ex As Exception
                MessageBox.Show(ex.ToString)
                cnn.Close()
            End Try

  2. #2
    Frenzied Member ChrisE's Avatar
    Join Date
    Jun 2017
    Location
    Frankfurt
    Posts
    1,992

    Re: How to Avoid Temporary Tables in ComboBOX?

    does look strange (from what I can see on that Image), did you try a compact and repair on the Database?
    to hunt a species to extinction is not logical !
    since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.

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