How do I code for a compound conditional in the DataView.RowFilter?

[Top Gun]

I am trying to code for a compound conditional in the DataView.RowFilter but
don't quite no how to do the correct syntax for this.

The following code sample chokes on dv.RowFilter:

int batchid = 123456;
int segment = 3;

DataView dv = new DataView(ds.taxBatch);
dv.RowFilter = "BatchID = " + batchid + " && Segment = " + segment;
string agencyid = dv[0]["AgencyID"].ToString();

[AirPete]

Top Gun wrote:

I am trying to code for a compound conditional in the
DataView.RowFilter but don't quite no how to do the correct syntax
for this.

The following code sample chokes on dv.RowFilter:

int batchid = 123456;
int segment = 3;

DataView dv = new DataView(ds.taxBatch);
dv.RowFilter = "BatchID = " + batchid + " && Segment = " + segment;
string agencyid = dv[0]["AgencyID"].ToString();

Try "AND" instead of "&&".

- Pete

[Jay B. Harlow [MVP - Outlook]]

Top Gun,
In addition to the other comments:

The only place I know of where the syntax that expressions (such as
RowFilter) in the DataSet OM
is documented is the DataColumn.Expression help topic:

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

Hope this helps
Jay

"Top Gun" <nf*@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

I am trying to code for a compound conditional in the DataView.RowFilter but don't quite no how to do the correct syntax for this.

The following code sample chokes on dv.RowFilter:

int batchid = 123456;
int segment = 3;

DataView dv = new DataView(ds.taxBatch);
dv.RowFilter = "BatchID = " + batchid + " && Segment = " + segment;
string agencyid = dv[0]["AgencyID"].ToString();