Data Grid coding not working properly!!!

[gautamshaw]

I did this code:

Imports System.Data
Imports System.Data.OleDb
Public Class Form1
    Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Gautam\Documents\Visual Studio 2005\Projects\waste\waste\db1.mdb"
        Dim myConnection As OleDbConnection = New OleDbConnection
        myConnection.ConnectionString = connString
        Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select * from Table1", myConnection)
        Dim ds As DataSet = New DataSet
        da.Fill(ds, "Table1")
        DataGridView1.DataSource = ds.DefaultViewManager
    End Sub
End Class

I get this output on button click:
Attachment 72031

Where does the error lies in my code?

[stanav]

This line of code

DataGridView1.DataSource = ds.DefaultViewManager

Should be changed to this:

DataGridView1.DataSource = ds.Tables("Table1")

[manhit45]

The datasoure of datagridview belong to datatable format.

[gautamshaw]

Sorry Stanav......
a new set of are add on doing this:

DataGridView1.DataSource = ds.Tables("Table1")

the output is:
Attachment 72032
How to rectify this?

[gautamshaw]

The datasoure of datagridview belong to datatable format

Then where should I rectify my code Manhit?

[manhit45]

The datasoure of datagridview belong to datatable format

Then where should I rectify my code Manhit?

Imports System.Data
Imports System.Data.OleDb
Public Class Form1
    Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Gautam\Documents\Visual Studio 2005\Projects\waste\waste\db1.mdb"
        Dim myConnection As OleDbConnection = New OleDbConnection
        myConnection.ConnectionString = connString
        Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select * from Table1", myConnection)
        Dim ds As DataSet = New DataSet
        da.Fill(ds, "Table1")
dim dt as new datatable
da.fill(dt)
        DataGridView1.DataSource = dt
    End Sub
End Class

[gautamshaw]

Sorry manhit.....
again the same problem...
a new set of columns are added and the output looks like the above image that i posted!!!

Code still not working.....

[stanav]

OK. You need to set the datapropertyname property to your datagridview columns.
Add these lines:

DataGridView1.Columns(0).DataPropertyName = "Name"
DataGridView1.Columns(1).DataPropertyName = "Address"
DataGridView1.Columns(2).DataPropertyName = "Roll"

Right before this line

DataGridView1.DataSource = ds.Tables("Table1")

[gautamshaw]

You did not understand my question......Or may be i did not explained it to you properly.......I am sorry for that.....
If my form at design time looks like this then:
Attachment 72033
Your code is perfect
But my design time form is like this:
Attachment 72034
I just want to place the values from the database to the grid columns inspite of adding the entire database columns to the grid.

How to do this?

[stanav]

I knew this from looking at the screenshot in your last post. That's why I told you to set the columns's datapropertyname property.
Did you try what I said in the last post? You can add those 3 lines before or after the line you set the datagridview.datasource property, but adding them before gives you a slight performance advantage. And that's why I told you to add the lines before you bind the datagidview.

[gautamshaw]

yes i added the three lines that you gave and it worked excellently.......

Thanks stanav

Now i want to add a print button so that i can print the datagridview contents.......

How to do this?

[manhit45]

Do you want use crystal report or excel to view.

creat other new thread.