DropDown in .NET DataGrid produces OnDataGridUpdate error

[Les Matthews]

I have a DropDownList in a DataGrid EditItemTemplate region. The
DropDownList is populated by a dataset different than the one specificied as
the DataSource for the DataGrid. The DataSource for the DataGrid is
"dsCompanies", while the picklist in the EditItemTemplate region is
"dsCompanyTypes".

Whenever I update a row in the DataGrid, I receive the following error:

System.Exception: Control not found in DataGrid column: typeCode
at DreamweaverCtrls.DataSet.OnDataGridUpdate(Object Src,
DataGridCommandEventArgs E)

The field "typeCode" exists in both datasets. It is the PK for companyTypes
table and an FK in the companies table.

How should I go about populating a dropdown in a DataGrid with a dataset
other than the primary datasource for the DataGrid?

Thanks

[Calvin Willman]

Load the Company Types Table into the dsCompanies DataSet. I don't see why
you need to create separate DataSets for the two.


On 18/4/05 5:06 pm, in article d40lr6$9v6$1@forums.macromedia.com, "Les
Matthews" <LesAMatthews@yahoo.com> wrote:

> I have a DropDownList in a DataGrid EditItemTemplate region. The
> DropDownList is populated by a dataset different than the one specificied as
> the DataSource for the DataGrid. The DataSource for the DataGrid is
> "dsCompanies", while the picklist in the EditItemTemplate region is
> "dsCompanyTypes".
>
> Whenever I update a row in the DataGrid, I receive the following error:
>
> System.Exception: Control not found in DataGrid column: typeCode
> at DreamweaverCtrls.DataSet.OnDataGridUpdate(Object Src,
> DataGridCommandEventArgs E)
>
> The field "typeCode" exists in both datasets. It is the PK for companyTypes
> table and an FK in the companies table.
>
> How should I go about populating a dropdown in a DataGrid with a dataset
> other than the primary datasource for the DataGrid?
>
> Thanks
>
>

[Calvin Willman]

You can then also Add the DataRelation object passing in the two columns
try...

DataRelation dRel = new DataRelation("CompaniesCompanyTypes",
dsCompanies.Tables["Companies"].Columns["typeCode"],dsCompanies.Tables["dsCo
mpanies"].Tables["CompanyTypes"].Columns["typeCode"]



On 18/4/05 5:06 pm, in article d40lr6$9v6$1@forums.macromedia.com, "Les
Matthews" <LesAMatthews@yahoo.com> wrote:

> I have a DropDownList in a DataGrid EditItemTemplate region. The
> DropDownList is populated by a dataset different than the one specificied as
> the DataSource for the DataGrid. The DataSource for the DataGrid is
> "dsCompanies", while the picklist in the EditItemTemplate region is
> "dsCompanyTypes".
>
> Whenever I update a row in the DataGrid, I receive the following error:
>
> System.Exception: Control not found in DataGrid column: typeCode
> at DreamweaverCtrls.DataSet.OnDataGridUpdate(Object Src,
> DataGridCommandEventArgs E)
>
> The field "typeCode" exists in both datasets. It is the PK for companyTypes
> table and an FK in the companies table.
>
> How should I go about populating a dropdown in a DataGrid with a dataset
> other than the primary datasource for the DataGrid?
>
> Thanks
>
>

[Calvin Willman]

sorry.. Type error seconf line I types 'Tables["dsCompanies"]' which is
rubbish.

DataRelation dRel = new DataRelation("CompaniesCompanyTypes",
dsCompanies.Tables["Companies"].Columns["typeCode"],dsCompanies.Tables["Comp
anyTypes"].Columns["typeCode"]

But you probably don't need this anyway... so wouldn't worry about it

On 18/4/05 5:06 pm, in article d40lr6$9v6$1@forums.macromedia.com, "Les
Matthews" <LesAMatthews@yahoo.com> wrote:

> I have a DropDownList in a DataGrid EditItemTemplate region. The
> DropDownList is populated by a dataset different than the one specificied as
> the DataSource for the DataGrid. The DataSource for the DataGrid is
> "dsCompanies", while the picklist in the EditItemTemplate region is
> "dsCompanyTypes".
>
> Whenever I update a row in the DataGrid, I receive the following error:
>
> System.Exception: Control not found in DataGrid column: typeCode
> at DreamweaverCtrls.DataSet.OnDataGridUpdate(Object Src,
> DataGridCommandEventArgs E)
>
> The field "typeCode" exists in both datasets. It is the PK for companyTypes
> table and an FK in the companies table.
>
> How should I go about populating a dropdown in a DataGrid with a dataset
> other than the primary datasource for the DataGrid?
>
> Thanks
>
>

[Les Matthews]

I have it worked out now.
Thanks for your help, Calvin.
I'm not familiar with the DataRelation object - I'll have to look into it.

"Calvin Willman" <calvinwillman@orange.net> wrote in message
news:BE89A82D.86E%calvinwillman@orange.net...

> You can then also Add the DataRelation object passing in the two columns
> try...
>
> DataRelation dRel = new DataRelation("CompaniesCompanyTypes",
> dsCompanies.Tables["Companies"].Columns["typeCode"],dsCompanies.Tables["dsCo
> mpanies"].Tables["CompanyTypes"].Columns["typeCode"]
>
>
>
> On 18/4/05 5:06 pm, in article d40lr6$9v6$1@forums.macromedia.com, "Les
> Matthews" <LesAMatthews@yahoo.com> wrote:
>

>> I have a DropDownList in a DataGrid EditItemTemplate region. The
>> DropDownList is populated by a dataset different than the one specificied
>> as
>> the DataSource for the DataGrid. The DataSource for the DataGrid is
>> "dsCompanies", while the picklist in the EditItemTemplate region is
>> "dsCompanyTypes".
>>
>> Whenever I update a row in the DataGrid, I receive the following error:
>>
>> System.Exception: Control not found in DataGrid column: typeCode
>> at DreamweaverCtrls.DataSet.OnDataGridUpdate(Object Src,
>> DataGridCommandEventArgs E)
>>
>> The field "typeCode" exists in both datasets. It is the PK for
>> companyTypes
>> table and an FK in the companies table.
>>
>> How should I go about populating a dropdown in a DataGrid with a dataset
>> other than the primary datasource for the DataGrid?
>>
>> Thanks
>>
>>

>