Stephen,
Your code looks right. There maybe something going on with retrieving the records. Try adding "ikeyclient = 11583" to a where clause of your Select statement and see if you fetch any records in your DataTable.
>Hi Cathi
>
>It was actually my question. Here is my code:
>
>This line return no result:
>ldvAddr.RowFilter = "ikeyclient = 11583";
>
>This line return 1 row:
>ldvAddr.RowFilter = "cgreet = 'Ilene'";
>
>Database:
>
>SELECT * FROM ADDR
>
>ikeyid ikeyclient cgreet
>----------- ----------- ----------------------------------------
>10869 11583 Ilene
>
>Thanks
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi