Jayesh
I just tested your code. First of all, if you are binding the controls to the dataset, changing the ds.DefaultView.RowFilter does not change the records are viewing at all. If you bind your controls to the View then you will see what I meant.
When I look at ds.DefaultView in the debugger, I saw the same result as my previous test.
When ds.DefaultView.RowFilter = "iKeyClient = 11583", ds.DefaultView.recordCount = 0.
When ds.DefaultView.RowFilter = "cGreet = 'Ilene'", ds.DefaultView.recordCount = 1.
I am beginning to think this is a bug in ADO.NET.
Stephen Lee
--------------------------------
Too much to code
Too little time
--------------------------------