How do I reference one of the properties of a form control within a SQL
Command of a DataAdapter? Do I have to do this dynamically within code or
can it be done within the CommandText property editor?

Christopher,

From your text I assume that you use the designer. Using that you can use
the databinding tab of the control.

By instance with a textbox you bind the "Text" to a column of your
datatable.

You can use as well code of course.

http://msdn.microsoft.com/library/de...dingstopic.asp

I hope this helps,

Cor

Thanks. Can you tell me how this would be done in code?


"Cor Ligthert" <(E-Mail Removed)> wrote in message
news:OsO$(E-Mail Removed)...
> Christopher,
>
> From your text I assume that you use the designer. Using that you can use
> the databinding tab of the control.
>
> By instance with a textbox you bind the "Text" to a column of your
> datatable.
>
> You can use as well code of course.
>
> http://msdn.microsoft.com/library/de...dingstopic.asp
>
> I hope this helps,
>
> Cor
>
>
>

Never Mind! I got it.

This works if you ignore the line breaks. (And, for those who don't
recognize it, I'm in dialect 3, hence all the quotes.)

string sCategory = cbCategoryLookUp.Text;
odbcDA_SubCategoryLookUp.SelectCommand.CommandText = "SELECT DISTINCT
\"SubCategory\" FROM \"tblSubCategory\" WHERE \"Category\" = '" + sCategory
+"'";


"Christopher Weaver" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks. Can you tell me how this would be done in code?
>
>
> "Cor Ligthert" <(E-Mail Removed)> wrote in message
> news:OsO$(E-Mail Removed)...
>> Christopher,
>>
>> From your text I assume that you use the designer. Using that you can
>> use the databinding tab of the control.
>>
>> By instance with a textbox you bind the "Text" to a column of your
>> datatable.
>>
>> You can use as well code of course.
>>
>> http://msdn.microsoft.com/library/de...dingstopic.asp
>>
>> I hope this helps,
>>
>> Cor
>>
>>
>>
>
>

Christopher,

Now I got what you mean.

For this are the odbcdataadapterParameters.
http://msdn.microsoft.com/library/de...ctortopic2.asp

This is the other side around.

I hope this helps,

Cor