DataGridView Help... Manual Loading of ACCESS Records into DataGridView

[vbDiggerz]

DataGridView Help... Manual Loading of ACCESS Records into DataGridView I have read such an article and code about mannual loading of records from database into datagridview not by means of "DataReader and FOR LOOP" looping process to each rows and cells to put each corresponding value.. instead? he just use an OleDataAdapter to fill a DataTable and set the "DatagridView.AutoGenerateColumns = false" then he set DataGridView.DataSource = DataTable that he made.. for him it works.. but for me i dont know what's lacking in my code.. there's no error occur but the records doesn't display inside my pre-defined column inside my datagridview.. instead? it just generate a blank row with the same rowCount of my table inside my database.. but when i set my DataGridView.AutoGenerateComlumn = true? then it display on system way.. but not in the way i wanted it to be display inside my custom column inside the datagridview.... here's my sample code... ************ Dim oleDataAdapter1 As OleDbDataAdapter Dim OleCommandBuilder1 As OleDbCommandBuilder Dim dbDataSet As New DataSet() Dim tempDataTable As DataTable = dbDataSet.Tables.Add("tempTable") Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try oleConnection.ConnectionString = dbConnectionString oleConnection.Open() oleCommand = New OleDbCommand("Select * From tempTable", oleConnection) oleDataAdapter1 = New OleDbDataAdapter(oleCommand) OleCommandBuilder1 = New OleDbCommandBuilder(oleDataAdapter1) oleDataAdapter1.Fill(tempDataTable) With DataGridView1 .AutoGenerateColumns = False .DataSource = tempDataTable End With Catch ex As Exception MsgBox(ex.ToString()) Finally oleCommand.Connection.Close() End Try End Sub ************** Note: I have 4 column created inside the datagridview.. columnName(ID,NAME,DATE,AGE) dataType(string,string,date,number) I know.. you can laugh at me.. just can't figured it out.. ehehe... please help... Please anyone there who has much deeper experience and knowledge in vb programming who can help me with this??? please.. a lot of appreciation in advance... please...

[Dave Kreskowiak]

What does the column generation code look like?? You're probably missing setting the DataPropertyName for each column. This tells the column which column in the DataSource to bind to.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007