Sunday 26 June 2016

Filter Dataset without hiting database using Dataview.

DataSet ds = (DataSet)ViewState[“dsChannel”];// get your dataset
DataView dv = ds.Tables[0].DefaultView;
dv.RowFilter = “ChannelId in (” + channelId + “)”; //  filter string
return  dv.table // it return  filtered row(s)  from dataset
If  you want to selcet single value from  returned datarow
string str= dv[0][“ChannelCode”].ToString()

No comments:

Post a Comment