Hi,

i'm trying to learning how to manipulate the DataGridView with database.
So, i added a 2 databasebound DataGridViewComboBoxColumn ("VehicleBrand", "VehicleModel")
so what i want to happen is to make the "VehicleModel" Column dependent on the selection of the "VehicleBrand" column. so, if i chose porsche then the model of porsche would be available in the "VehicleModel" column. and then everything inside the DataGridView will be saved and loaded from the database.
So, how am i suppose to do this?

How are you loading the data into the gridview?

I'm planning to use OLEDB for the connection.
I'm still not sure. since i don't know if it would work better using typed dataset or untyped dataset. i'm still doing a lot of research.
and frankly, i'm lost.

So, could give a suggestion to put me in the right direction.?

I would probably populate a dataset. Then use a dataview to populate the grid. I use the dataview because with a dataview you can use sorting and paging. You can also use the built-in features of the gridview in VS 2005.
As far as the SQL statement I would use. If you are trying to combine two columns in a table then you should use a JOIN statement.

I hope this helps. I will try to put up some code by the end of the day that will show how to bind a datagrid with a join statement.

have a good day

notrosh

www.nwadnug.org

so the JOIN statement is the key to make the 2 DataGridViewComboBoxColumn work?

I am already able to connect to the database and load it to datagridview using the binding source. the only thing missing is how i am going to make each VehicleModel Cell Row dependent to it's corresponding VehicleBrand Cell row.

is the gridview ur talking about different from the datagridview?

thank you. i'll be waiting for your example codes. :)