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/d...windowsformscontrolclassdatabindingstopic.asp

I hope this helps,

Cor

 

[Christopher Weaver]

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

 

[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
+"'";

 

[Cor Ligthert]

Christopher,

Now I got what you mean.

For this are the odbcdataadapterParameters.
http://msdn.microsoft.com/library/d...temdataodbcodbcdataadapterclassctortopic2.asp

This is the other side around.

I hope this helps,

Cor