Select query on datatable

[lidds]

Hi,

 

At the moment I am using the following code to populate a datatable using a stroed procedure, which return a large amount of information from my MS SQL table. What I would like to do is then apply an SQL select statement to the datatable so that I can filter down the data in the datatable further. The reason why I want to do this is instead of having a large number of stored procedures for each senario, is this possible

 

Dim myDA As New OleDb.OleDbDataAdapter("spQryParentComments", myDB.myConn)
           myDA.SelectCommand.CommandType = CommandType.StoredProcedure
           myDA.SelectCommand.Parameters.Add(New OleDb.OleDbParameter("@projName", OleDb.OleDbType.VarChar)).Value = RISData.Instance.ProjectName
           myDA.SelectCommand.Parameters.Add(New OleDb.OleDbParameter("@userID", OleDb.OleDbType.VarChar)).Value = RISData.Instance.UserID

           Dim dataParentTable As DataTable = New DataTable("Parent")

' e.g.
dataParentTable.selectcommand("SELECT * WHERE [column] = [XYZ]")

           myDA.Fill(dataParentTable)

 

Thanks in advance

 

Simon

[PlausiblyDamp]

Have you tried using a DataView? These allow you to filter or sort a datatable without having to requery the database.