This is a rehash of a response question I made down below.
I am playing with the NorthWind database. I have created a DataSet and
loaded the Employees table into it. I have created a DataView on that
table.
Now, I am having trouble putting all the parts together to retrieve a single
row of that DataView. For instance, if I want to retrieve the row where
EmployeeId='2' and display the FirstName of that employee, what steps do I
need to perform? What I've tried keeps getting syntax errors or exceptions.
For instance, both
dataView1.RowFilter="EmployeeId != '2'";
dataView1.RowFilter="EmployeeId != 2"; // No single quotes
Gives me the error:
Cannot interpret token '!' at position 12.
Since the filter removes the rows that match the contition, I have to
negate the condition to get the data I want.
I'd appreciate some help.
Thanx,
Bill