> Hi,
>
> My dataview is returning 0 rows however I know there are rows in the
> dataset with the matching data. Do you see anything wrong with my code. Can
> you suggest a way to debug?
>
> Thanks,
>
> Andy
>
> public DataView BindCodeDropDown()
> {
>    SqlConnection oConn = new SqlConnection(DBConnectionString);
>    SqlDataAdapter dadCode = new SqlDataAdapter("sp_web_835_ddl_code",oConn)
> ;
>    DataSet dstCode = new DataSet();
>    dadCode.Fill(dstCode,"CodeTable");
> //    return dstCode;
>           
>    DataView CodeView = new DataView(dstCode.Tables["CodeTables"]);
>    CodeView.RowFilter="type='F'";
>    return CodeView;
> }
>

>> Hi,
>>
>[quoted text clipped - 19 lines]
>>    return CodeView;
>> }
>
>You sure it's called "CodeTable"? try omitting that once.
>Also, you have "CodeTable" and "CodeTables"
>Which is it?
>