ado.net dataset select statement

[hamking01]

I've filled an datatable with an query from a database. I now need to select data from the datatable. Can I write an sql statement to further sort/find data from the table. Can anyone provide the proper syntax or links on how to do this? Thanx

 

[Veep]

You can use a DataView and filter it:

{
DataView dv = new DataView(YourDataSet.Tables[0]);
dv.RowFilter = "SomeColumnName = " + SomeVariable;
}

For example if SomeColumnName = "UserID" and SomeVariable = 3 the above would translate to: "where UserID = 3". Anyway, a DataView is most likely your solution.

 

[ca8msm]

You can also use the Select method from the dataview table (DataView1.Table.Select) and this will allow you to enter a filter as shown above by Veep, but it will also allow you to sort the data.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.