How to have a DataView Row Filter by <> Operator

[Paramu]

Hi,

I have head hunting problem with the below codes...Really it tooks my holeday, but still not clear...

Any superiors can help me to clear?


Thanks


My Codes

MyDtb1 = MyOriginalDtb;
DataView MyDtbView = MyDtb1.DefaultView;
MyDtbView.Sort = "prn_no,sheet_no,prn_date,pty_name";
MyDtbView.RowFilter = nullptr;
//MyDtbView.RowFilter = "prn_status<>'CLOSED'"; ?????????????????

From the above code DataView RowFilter is not showing all rows, means it omits the last rows.. And hence I achieved by the following code has working good....

for (int T2 = 0; T2 <= MyDtbView.Count-1; T2++) {
if (Convert.ToString(MyDtbView[T2]["prn_status"].ToString()) != "CLOSED") {
// Good and not skipped any rows
}
}

Thanks for the helps


U.PARANTHAMAN

Continue reading...