ComboBoxes in DataGridViews bound to DataSources

[jjsavage]

Hi all,
I've got a DataGridView bound to a DataTable, and I need to make
some of the columns into ComboBoxColumns . I've tried some of the
solutions listed here, but I can't seem to make them work. They might
not be the solutions I'm looking for; I just want to have a few
arbitrary values for a combo box and make sure everything in that row
is one of those values. My boss won't let me just leave them as text
boxes. How do I tell the DataTable to tell the DataGridView to display
a ComboBox?

Thanks,
John

[Thierry]

Hi

Why don"t you use the extended properties of Datacolumn of the Datatable ?
<jj******@gmail .coma écrit dans le message de news:
11************* *********@j72g2 00...legr oups.com...

Hi all,
I've got a DataGridView bound to a DataTable, and I need to make
some of the columns into ComboBoxColumns . I've tried some of the
solutions listed here, but I can't seem to make them work. They might
not be the solutions I'm looking for; I just want to have a few
arbitrary values for a combo box and make sure everything in that row
is one of those values. My boss won't let me just leave them as text
boxes. How do I tell the DataTable to tell the DataGridView to display
a ComboBox?

Thanks,
John

[jjsavage]

It needs to be automatic; it takes 45 seconds to load 5,000 rows
without binding, but only 6 seconds with binding. Somehow, I need to
have the DataSource create a ComboBox column automatically.

- John

Thierry wrote:

Hi

Why don"t you use the extended properties of Datacolumn of the Datatable ?
<jj******@gmail .coma écrit dans le message de news:
11************* *********@j72g2 00...legr oups.com...

Hi all,
I've got a DataGridView bound to a DataTable, and I need to make
some of the columns into ComboBoxColumns . I've tried some of the
solutions listed here, but I can't seem to make them work. They might
not be the solutions I'm looking for; I just want to have a few
arbitrary values for a combo box and make sure everything in that row
is one of those values. My boss won't let me just leave them as text
boxes. How do I tell the DataTable to tell the DataGridView to display
a ComboBox?

Thanks,
John

[RobinS]

In Brian Noyes' databinding book, he has one example where
he creates a DataGridView, and has different kinds of columns
in it. One of them is a dropdown combo box. He says this is
one of the most complicated to implement.

I recommend that you go to his website
www.softinsight.com/databindingbook
and download the code and look at the project in Chapter6
called ColumnTypes.

I'd post some of it here, but there's a lot of it,
tied to different events (like editing the grid).

If you want to run it, you will need to set up the database
he's using; those scripts are on the same webpage.

Then you should buy this book; it's invaluable.

Robin S.
---------------------------

<jj******@gmail .comwrote in message
news:11******** **************@ l12g2000cwl.goo glegroups.com.. .
It needs to be automatic; it takes 45 seconds to load 5,000 rows
without binding, but only 6 seconds with binding. Somehow, I need to
have the DataSource create a ComboBox column automatically.

- John

Thierry wrote:

Hi

Why don"t you use the extended properties of Datacolumn of the Datatable ?
<jj******@gmail .coma écrit dans le message de news:
11************* *********@j72g2 00...legr oups.com...

Hi all,
I've got a DataGridView bound to a DataTable, and I need to make
some of the columns into ComboBoxColumns . I've tried some of the
solutions listed here, but I can't seem to make them work. They might
not be the solutions I'm looking for; I just want to have a few
arbitrary values for a combo box and make sure everything in that row
is one of those values. My boss won't let me just leave them as text
boxes. How do I tell the DataTable to tell the DataGridView to display
a ComboBox?

Thanks,
John

[jjsavage]

Ah ha! Thanks, that had what I needed. In case anyone else is
wondering, here's what you do:
1. Create a DataGridView with the columns and column types (text,
combobox, checkbox, etc) that you want.
2. Set DataGridView.Au toGenerateColum ns to false.
3. Create and fill a DataTable with your data.
4. The important (and non-obvious) part: each existing column in the
DataGridView must be individually connected to its corresponding column
in the DataTable:
DataGridView.Co lumns[0].DataPropertyNa me = "Column0";
DataGridView.Co lumns[1].DataPropertyNa me = "Column1";
...
5. Set DataGridView.Da taSource to the DataTable from 3.

You would think that if AutoGenerateCol umns is false, the grid would
automatically connect its columns to the columns of its DataSource, but
I guess it would be too hard to figure out if it's supposed to match
them by position or name or something else, so they left it up to the
programmer.

- John

RobinS wrote:

In Brian Noyes' databinding book, he has one example where
he creates a DataGridView, and has different kinds of columns
in it. One of them is a dropdown combo box. He says this is
one of the most complicated to implement.

I recommend that you go to his website
www.softinsight.com/databindingbook
and download the code and look at the project in Chapter6
called ColumnTypes.

I'd post some of it here, but there's a lot of it,
tied to different events (like editing the grid).

If you want to run it, you will need to set up the database
he's using; those scripts are on the same webpage.

Then you should buy this book; it's invaluable.

Robin S.
---------------------------

<jj******@gmail .comwrote in message
news:11******** **************@ l12g2000cwl.goo glegroups.com.. .
It needs to be automatic; it takes 45 seconds to load 5,000 rows
without binding, but only 6 seconds with binding. Somehow, I need to
have the DataSource create a ComboBox column automatically.

- John

Thierry wrote:

Hi

Why don"t you use the extended properties of Datacolumn of the Datatable ?
<jj******@gmail .coma écrit dans le message de news:
11************* *********@j72g2 00...legr oups.com...

Hi all,
I've got a DataGridView bound to a DataTable, and I need to make
some of the columns into ComboBoxColumns . I've tried some of the
solutions listed here, but I can't seem to make them work. They might
not be the solutions I'm looking for; I just want to have a few
arbitrary values for a combo box and make sure everything in that row
is one of those values. My boss won't let me just leave them as text
boxes. How do I tell the DataTable to tell the DataGridView to display
a ComboBox?
>
Thanks,
John
>

[RobinS]

But don't you also have to connect the column of the combobox
to the list of values you want to see in it?

Robin S.
--------------------------
<jj******@gmail .comwrote in message
news:11******** *************@7 9g2000cws.googl egroups.com...
Ah ha! Thanks, that had what I needed. In case anyone else is
wondering, here's what you do:
1. Create a DataGridView with the columns and column types (text,
combobox, checkbox, etc) that you want.
2. Set DataGridView.Au toGenerateColum ns to false.
3. Create and fill a DataTable with your data.
4. The important (and non-obvious) part: each existing column in the
DataGridView must be individually connected to its corresponding column
in the DataTable:
DataGridView.Co lumns[0].DataPropertyNa me = "Column0";
DataGridView.Co lumns[1].DataPropertyNa me = "Column1";
...
5. Set DataGridView.Da taSource to the DataTable from 3.

You would think that if AutoGenerateCol umns is false, the grid would
automatically connect its columns to the columns of its DataSource, but
I guess it would be too hard to figure out if it's supposed to match
them by position or name or something else, so they left it up to the
programmer.

- John

RobinS wrote:

In Brian Noyes' databinding book, he has one example where
he creates a DataGridView, and has different kinds of columns
in it. One of them is a dropdown combo box. He says this is
one of the most complicated to implement.

I recommend that you go to his website
www.softinsight.com/databindingbook
and download the code and look at the project in Chapter6
called ColumnTypes.

I'd post some of it here, but there's a lot of it,
tied to different events (like editing the grid).

If you want to run it, you will need to set up the database
he's using; those scripts are on the same webpage.

Then you should buy this book; it's invaluable.

Robin S.
---------------------------

<jj******@gmail .comwrote in message
news:11******** **************@ l12g2000cwl.goo glegroups.com.. .
It needs to be automatic; it takes 45 seconds to load 5,000 rows
without binding, but only 6 seconds with binding. Somehow, I need to
have the DataSource create a ComboBox column automatically.

- John

Thierry wrote:

Hi

Why don"t you use the extended properties of Datacolumn of the Datatable
?
<jj******@gmail .coma écrit dans le message de news:
11************* *********@j72g2 00...legr oups.com...

Hi all,
I've got a DataGridView bound to a DataTable, and I need to make
some of the columns into ComboBoxColumns . I've tried some of the
solutions listed here, but I can't seem to make them work. They might
not be the solutions I'm looking for; I just want to have a few
arbitrary values for a combo box and make sure everything in that row
is one of those values. My boss won't let me just leave them as text
boxes. How do I tell the DataTable to tell the DataGridView to
display
a ComboBox?
>
Thanks,
John
>