DataGridView able to display different tables from .mdb?

DataGridView able to display different tables from .mdb?

• elenaar-ms

  CommandBuilder is great if you are using SQL strings, but it doesn't work so well when using stored procedures; it has to be setup manually then.
  

• snipexv

  Gee,
  
  People here are very helpful...
  
  I don't ask much. All I want is an indication, a snippet of code, a link or a good book suggestion to achieve this, IMHO, simple task. Well, I do think it's simple, but after Googleing like never before without any success, I'm not sure anymore if it's that easy...
  
  neilsanner
  
  

• Giri T

  Hey,
  
  OK, that's for the web world; I usually do Refresh(); don't know if necessary.  Glad to hear it's working.
  
  Brian
  

• Christineeve

  Hi Brian! Thank you for your reply.
  
  

  Brian Mains wrote:

  Well, loading all of the database components in the code, when they select the database, you can then piece together the connection string.  Then connect to the db to get the table names (don't know how to do that, did you do that successfully, and if so, how )

  
  Yes, I managed to do that part. Here's how:
  
  

  Private Sub ButtonLoadDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonLoadDB.Click         Dim Cn As ADODB.Connection, Cat As ADOX.Catalog, objTable As ADOX.Table, objKey As Key         Cn = New ADODB.Connection         Cat = New ADOX.Catalog         objTable = New ADOX.Table         ' -- Open the connection         Cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + TextBox1.Text.Trim)         ' -- Open the Catalog         Cat.ActiveConnection = Cn         ' -- Fill the combobox with all the tables name         For Each objTable In Cat.Tables             If Not objTable.Name.ToLower.StartsWith("msys") Then                 ComboBox_Tables.Items.Add(objTable.Name)             End If         Next         '  -- clean up objects         objKey = Nothing         objTable = Nothing         Cat = Nothing         Cn.Close()         Cn = Nothing End Sub

  
  
  

  Brian Mains wrote:

  ..., and then when you get that, create a sql string based on the selected value, load the dataadapter, datatable, and assign the datatable to the datasource.

  
  
  It's that part that I'm really not sure how to do it. Can you or anyone else post a little bit of code showing how to do this please.
  
  

• Grib

  Here's a line of code that I've found very useful and thought to share:
  
  Dim cb As OleDbCommandBuilder = New OleDbCommandBuilder(objAdapter)
  
  This will prevent an error from popping after we make changes to data in the dataGridView and we run this line of code, to write (update) the data in the source table:
  
  objAdapter.Update(objTable)
  
  Cheers!
  neilsanner
  
  

• Ulrich Vogl

  Gee!
  
  It feels good to see it work!!! I'm so happy! Thank you Brian!!!
  
  The only thing that I don't understand is this line:
  datagridview1.DataBind()
  
  If I look in the object browser, it doesn't seem to be a method of dataGridView.
  And the program seems to work good without this line.
  
  Thanks again Brian! You the man!
  neilsanner
  
  
  
  

• Josh Stevens - MSFT

  Hey,
  
  You got the code for the first two, the last is the easiest:
  
  objAdapter = new OledbDataAdapter("select * from " + cboTableDropDown.SelectedText, objConnection)
  objTable = new DataTable
  objAdapter.Fill(objTable)
  
  datagridview1.DataSource = objTable
  datagridview1.DataBind()
  

• David Davis

  Hey,
  
  Well, loading all of the database components in the code, when they select the database, you can then piece together the connection string.  Then connect to the db to get the table names (don't know how to do that, did you do that successfully, and if so, how ), and then when you get that, create a sql string based on the selected value, load the dataadapter, datatable, and assign the datatable to the datasource.
  
  Brian
  
• DataGridView able to display different tables from .mdb?