Filtering Data without using Dataview

[jeva39]

Please: How I can Filtering Data (records) in VB.NET without using Dataview? Thanks!!

Jorge Villamizar

 

[TPM]

In you SQL select statment use WHERE.

TPM

 

[jeva39]

I need another solution

Thanks for your help but this solution, in general Database Management work very well but I need to use seven different ways to permit the user filtering data by buttons clicks including Music Categories, Find Specific Data, Authors, Arrangements, Rythms, Songs, etc, etc. What is the solution without using Dataview?
Thanks!!!

 

[Paszt]

Why wouldn't you want to use a dataView?
Sorting & Filtering the main purpose of a dataView.

 

[cjaymcmeans]

use inner join.. in your sql statement.. then use the where statement..

 

[jeva39]

I find the solution. Problem solved....