data view query

  • Thread starter Thread starter tarun.sinha
  • Start date Start date
T

tarun.sinha

Hello All..

I Need Your Help,
I want to set a filter in data set.I am fetching the data from store
Procedure in dataset,
but I want to use data view to filter this data set.how do i do it,
Please consider my poor
Knowledge and reply me.I have search a lot in google but I am unable to
use it.
Let me Clear you the picture again,

dataset = call store procedure()
this data set include the information about username , now i want to
fetch only
those user from dataset whose name is start from alphabet 'P'.

How do I do that ??

Thanks
With Regards
Tarun
 
firstly we need to see how many datatables were returned to us from the
dataset and then if there is only one table in dataset we do something like
this

dataset = call store procedure()
Dataview dv=new Dataview(dataset[0])
dv.RowFilter="User_Name like'P%' "

in RowFilter we can write SQls where clause the same way as we write queries
in SQLServer the Whole where clause could be specified there itself

regards,
Karuna Kant Mishra
 
Back
Top