[RESOLVED] Data Sets - Databases

[NPassero]

Alright I have a project where I load a database table into a DataSet and DataAdapter using SQLClient.SqlConnection. I am using this to create reports and I am trying to add dynamic filters to the report ( Only view certain items, select by name, things like that ). Now, currently I have to use a whole new query and grab that from the database every time I change the output specifications. Is there a way I can skip going through the database and just Query the original DataSet that I have created ?

   Dim oConn As SqlClient.SqlConnection = New SqlClient.SqlConnection(cString)
   Dim tAdap As SqlClient.SqlDataAdapter
   Dim sQuery As String = "SELECT * FROM ReportView"
   Dim dSet As DataSet
 
   ' Code in here that adds to the query when specific items are selected
   ' ex. WHERE fieldA = 1 AND name = 'Nick'
 
   tAdap = New SqlClient.SqlDataAdapter(sQuery, oConn)
   dSet = New DataSet()
   tAdap.Fill(dSet, table)

   ' Using the DevExpress Framework (.repx is a report file)
   rep = XtraReport.FromFile("reportView.repx", True)
   rep.DataSource = dSet
   rep.DataAdapter = tAdap
   rep.DataMember = table

Thanks for your help..

[thecow95]

Have you tried filtering the defaultview of the dataset? Not sure if reports look at this but I know most controls do.

dSet.Tables(0).DefaultView.RowFilter = "(fieldA = 1) AND (name = 'Nick')"

[NPassero]

Thank you for that, that helps a lot with the views...
Now is there any way to do that with the sort order ? asc ? desc ?

thanks.

[TirRaven]

yes, in a similar fashion to filtering the data it can be sorted with the RowFilter property of the datatable.

'sort ascending
        dSet.Tables(0).DefaultView.RowFilter = "MyColumnName ASC"
'sort descending
        dSet.Tables(0).DefaultView.RowFilter = "MyColumnName DESC"

[NPassero]

Thanks for all the help.

[NPassero]

yes, in a similar fashion to filtering the data it can be sorted with the RowFilter property of the datatable.

'sort ascending
        dSet.Tables(0).DefaultView.RowFilter = "MyColumnName ASC"
'sort descending
        dSet.Tables(0).DefaultView.RowFilter = "MyColumnName DESC"

Just for Reference:

'sort Ascending
        dSet.Tables(0).DefaultView.Sort = "MyColumnName ASC"
'sort Descending
        dSet.Tables(0).DefaultView.Sort = "MyColumnName DESC"

Use the Sort function instead of the Row Filter for sorting by columns.

-NP

[TirRaven]

Use the Sort function instead of the Row Filter for sorting by columns.

-NP

oops haha, yea thats what i ment to post...