Dataview returns 0 rows

[Andy Sutorius via DotNetMonster.com]

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;
}

 

[Curt_C [MVP]]

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;
}

You sure it's called "CodeTable"? try omitting that once.
Also, you have "CodeTable" and "CodeTables"
Which is it?

 

[Andy Sutorius via DotNetMonster.com]

Curt,

Thank you! Misspelling. Ugh!

Andy

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?