Hi, has anyone probably solved the following issue:
I want to create a datagridview with a combobox displaying value from a
datatable.
This work fine as long as I 'hardcode' the necessary properties into the
datagridcolumn. Is there any way to get the property information from a
database which sort of "configures" the datagridcolumn.
ie I do a:
       Dim newcol As New DataGridViewComboBoxColumn
        countrytableadapter.Fill(countrytable)
        newcol.DataSource = countrytable
        newcol.DisplayMember = "country_name"
        newcol.HeaderText = "New col"
        newcol.ValueMember = "country_code"
        newcol.DisplayIndex = 0
        newcol.DataPropertyName = "ccy_country"
        dg.Columns.Add(newcol)

all except lines 2 and 3 can be put in an sql table, but how would a make a
proper reference to object "countrytable" to instruct the grid that I want to
read from that datatable?
Any help is highly appreciated.

Thanks

ctk_at wrote:
Show quoteHide quoteI'm a bit confused on your question.  Aren't you always going to fill it
from some table?

Dim T as DataTable
countrytableadapter.Fill(T)
newcol.DataSource = T

What is the issue with hardcoding that?

The issue is that my app has many datatables which are presented via a DGV,
which I did not programm each individually but let .net populate the DGV
columns from the respectiv table for me.
(ie dgv.datasource = dataset .........)
This generates standard dgv columns with colheaders from the datatable fields.

I a second run through the dgv I change the col headers, color and so on and
on some fields I want to restrict the possible input to a list of values that
come from an other table. In other word each column of each table get
properties set which again do come from a table. But again instead of
hardcoding these restrictions in the application I would want to read the
setting from my columnproperty table.

The problem is that I very well can say ie
dg.column(0).width = valueofsomefieldinmydatabase
or
dg.column(0).columnheader = somedatafieldfrommycolumnsdatatable
because one expect integer the other string datatype

but I can not say
dim newcol as new datagridviewcombobox
newcol.datasource = valueofsomefieldinmydatabase

because newcol.datasource expects an object of type datatable which is not
something that I can store in an sql table. The question is if I can convert
valueofsomefieldinmydatabase into a reference to a datatable that was
already defined an filled in the application.

I not sure if these is clear enough.

Thanks,








Show quoteHide quote

[VB.NET] How to store/load XML schema internally...
Passing values bewteen user controls is separate web forms
Best way to implement 2 controls on one window
Coding a TimeSpan
Best value Help file builder
Best way to output form information
Newbee ASP.NET Questions
Write to an existing ASCII file
How to programmatically change directory attributes
Can't Change Installation Drive for new install of Visual Studio Professional 2005