Control References in DataAdapter Commands

[Christopher Weaver]

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?

[Cor Ligthert]

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 Weaver]

Thanks. Can you tell me how this would be done in code?
"Cor Ligthert" <no************@planet.nl> wrote in message
news:Os**************@TK2MSFTNGP15.phx.gbl...

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 Weaver]

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" <we*****@verizon.net> wrote in message
news:eZ**************@TK2MSFTNGP15.phx.gbl...

Thanks. Can you tell me how this would be done in code?
"Cor Ligthert" <no************@planet.nl> wrote in message
news:Os**************@TK2MSFTNGP15.phx.gbl...

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

[Cor Ligthert]

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