471,319 Members | 1,020 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,319 software developers and data experts.

Converting dataset to dataview and sorting?

I have a dataset with one table, which has four columns. All are of
type INT. I need to convert this dataset into a dataview so I can sort
on the last three columns. I may sort one of the three or all three at
once. This dataview will display its results in a winform datagrid.

Right now, I create the dataset from a datareader:

while(dr.Read())
{
drow = _filteredCriteriaDataSet.Tables[0].NewRow();
drow[0] = dr.GetValue(0);
drow[1] = dr.GetValue(1);
drow[2] = dr.GetValue(2);
drow[3] = dr.GetValue(3);
_filteredCriteriaDataSet.Tables[0].Rows.Add(drow);
}

How do I convert the dataset to a dataview then take the three criteria
and apply them to the new created dataview?

Thanks,
Brett

Dec 31 '05 #1
7 8220
KJ
Where "dt" represents your table and "foo" the column name to sort on:

DataView dv = new DataView(dt);
dv.Sort = "foo";

Dec 31 '05 #2
I did that but need to sort this way:

"col1 = " + col1criteria + " and col2 = " + col2criteria + " and col3 =
" + col3criteria

I apply that to the sortfilter but always get the same results in the
grid, which don't match the above sorting. I can look at "dv" in the
debugger and see its "Items". The row values are matching the criteria
I'm sending in. What could be causing it not to match the query?

Thanks,
Brett

Dec 31 '05 #3
KJ
OK, maybe you are thinking of the .Select method of DataTable?:

(from MSDN)

public DataRow[] Select(
string filterExpression,
string sort,
DataViewRowState recordStates
);

Dec 31 '05 #4
I did try .Select but get the same thing - nothing. For some reason,
none of the sorting or querying has any affect.

Brett

Dec 31 '05 #5
Brett,

Sorting is a way of ordering results.

What you are doing is trying to filter the results. You want to set the
RowFilter property to this string, and then it should filter your results
out appropriately.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Brett Romero" <ac*****@cygen.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
I did that but need to sort this way:

"col1 = " + col1criteria + " and col2 = " + col2criteria + " and col3 =
" + col3criteria

I apply that to the sortfilter but always get the same results in the
grid, which don't match the above sorting. I can look at "dv" in the
debugger and see its "Items". The row values are matching the criteria
I'm sending in. What could be causing it not to match the query?

Thanks,
Brett

Dec 31 '05 #6
RowFilter is what I'm setting.

Jan 3 '06 #7
I have what I believe to be a similar or the same problem.

I populate a DataSet with the results of an SQL query, and then apply a
DataView to this DataSet. I then iterate through the DataView Rows to create
an XML file.

My problem is, no matter what I do, the way the data is sorted is always the
same. so if I sort on "x, y, z" I have unsorted data in my XML file when it
is saved.

I don't think this has anything to do with RowFilter properties.

Thanks in advance

"Nicholas Paldino [.NET/C# MVP]" wrote:
Brett,

Sorting is a way of ordering results.

What you are doing is trying to filter the results. You want to set the
RowFilter property to this string, and then it should filter your results
out appropriately.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Brett Romero" <ac*****@cygen.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
I did that but need to sort this way:

"col1 = " + col1criteria + " and col2 = " + col2criteria + " and col3 =
" + col3criteria

I apply that to the sortfilter but always get the same results in the
grid, which don't match the above sorting. I can look at "dv" in the
debugger and see its "Items". The row values are matching the criteria
I'm sending in. What could be causing it not to match the query?

Thanks,
Brett


Jan 17 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Nikki | last post: by
4 posts views Thread by Deepa | last post: by
4 posts views Thread by suzy | last post: by
3 posts views Thread by Björn | last post: by
2 posts views Thread by Carl Summers | last post: by
6 posts views Thread by Ramakrishnan Nagarajan | last post: by
3 posts views Thread by Freeon | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.