473,385 Members | 1,764 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Use of "fillby"

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"

Feb 13 '07 #1
2 5231
Chris wrote:
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=cache...ient=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".

--
Göran Andersson
_____
http://www.guffa.com
Feb 13 '07 #2
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.f ixed1DataSet.Commands,
commandCol);

"Göran Andersson" wrote:
Chris wrote:
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=cache...ient=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".

--
Göran Andersson
_____
http://www.guffa.com
Feb 14 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.