Use of "fillby"

[Guest]

Can someone help me understand how to use this example from MS in my code:

string cityValue = "Seattle";
customersTableAdapter.FillByCity(northwindDataSet.Customers, cityValue);

I am not sure where "FilByCity" comes from or is referenced? I only se
"fill" as a choice for the tableadapter.

What I am triying to do is programmatically return a value based on another
but I am not sure how to assign a AQL statement in C#. In VB is was easy. I
want to do something liek this:

SELECT CommandString from Commands where Command = "Armed Away"

 

[Guest]

Can someone help me understand how to use this example from MS in my code:

string cityValue = "Seattle";
customersTableAdapter.FillByCity(northwindDataSet.Customers, cityValue);

I am not sure where "FilByCity" comes from or is referenced? I only se
"fill" as a choice for the tableadapter.

What I am triying to do is programmatically return a value based on another
but I am not sure how to assign a AQL statement in C#. In VB is was easy. I
want to do something liek this:

SELECT CommandString from Commands where Command = "Armed Away"

There is some problem with some of Microsofts servers, so I can't see
the walkthrough, only the cached version that Google keeps:

http://64.233.183.104/search?q=cach...ity&hl=sv&ct=clnk&cd=1&gl=se&client=firefox-a

I assume that it's the same example as the one that you are talking
about. If you had linked to it, it would have been easier to find...

FillByCity is a query that you added to the adapter in the section "To
add a query to the CustomersTableAdapter".

 

[Guest]

THank you. I missed the WHERE = ? for Access.mdb.

But once I run this, how can I programatically get a value out of one of the
fields in the table?
I have this code now. It returns one row of data. Now I need to get the
value of one field frm this fillby. Any ideas?

commandCol = scriptDataGridView[4, rowNum].FormattedValue.ToString();
this.commandsTableAdapter.FillByCommandName(this.fixed1DataSet.Commands,
commandCol);