DataView to DataGridView binding problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I bind my DataView to my DataGridView control? Here's the scenario:
because I want to make my first column a check box, I have defined a
collection for my data grid in the designer. I also had to specify the
columns for my dataTable (see code below). After I did that, there were 8
columns displayed in the grid (the first 4 from my collection (they were
empty) and the last 4 populated with the DataView data). I set the grid's
AutoGenerateColumns property to False so that I see only 4 columns (those
defined in the collection) instead of 8, but how do I get them populated
witht the DataView data? dgvTables.DataSource = myDataView doesn't do the
trick, I don't know what I'm doing wrong.

dgvTables.AutoGenerateColumns = False
Dim dt As New DataTable
dt.Columns.AddRange(New DataColumn(3) {New DataColumn("Copy"), New
DataColumn("Source Table"), New DataColumn("Destination Table"), New
DataColumn("Columns")})
....
Dim dr1 As DataRow = dt.NewRow
....
dr1.ItemArray = New Object(2) {checked, table.Name, table.Name} ' NOTE:
checked can be either "T" or "F"
....
dt.Rows.Add(dr1)
....
Dim myDataView As DataView
myDataView = New DataView(dt)
myDataView.Sort = ""
dgvTables.DataSource = myDataView
dgvTables.Refresh()
 
Hi,

Eve said:
How do I bind my DataView to my DataGridView control? Here's the scenario:
because I want to make my first column a check box, I have defined a
collection for my data grid in the designer. I also had to specify the
columns for my dataTable (see code below). After I did that, there were 8
columns displayed in the grid (the first 4 from my collection (they were
empty) and the last 4 populated with the DataView data). I set the grid's
AutoGenerateColumns property to False so that I see only 4 columns (those
defined in the collection) instead of 8, but how do I get them populated
witht the DataView data? dgvTables.DataSource = myDataView doesn't do the
trick, I don't know what I'm doing wrong.

dgvTables.AutoGenerateColumns = False
Dim dt As New DataTable
dt.Columns.AddRange(New DataColumn(3) {New DataColumn("Copy"), New
DataColumn("Source Table"), New DataColumn("Destination Table"), New
DataColumn("Columns")})
...
Dim dr1 As DataRow = dt.NewRow
...
dr1.ItemArray = New Object(2) {checked, table.Name, table.Name} ' NOTE:
checked can be either "T" or "F"
...
dt.Rows.Add(dr1)
...
Dim myDataView As DataView
myDataView = New DataView(dt)
myDataView.Sort = ""
dgvTables.DataSource = myDataView
dgvTables.Refresh()
Click to expand...

If i understand it correctly, then you need to set a DataPropertyName on
each DataGridViewColumn (using column editor or from code), which maps to
each column name in the DataTable/DataView.

HTH,
Greetings
 
It worked. Thank you very much!!!

Bart Mermuys said:
Hi,



If i understand it correctly, then you need to set a DataPropertyName on
each DataGridViewColumn (using column editor or from code), which maps to
each column name in the DataTable/DataView.

HTH,
Greetings
Click to expand...
 
Back
Top