HI I m trying to sort the rows in my datatable using select method I know that i can say datatable select col1 test which in effect is a where clause and will return n rows that satisfy the condition I was wondering can i do the following datatable select ORDER BY col1 ---col1 is the name of hte column I tried datatable defaultview sort but didnt work Any ideas on how to get around this issue thanks

You can use the below simple method of sorting datatable DefaultView Sort Col2 ASC Col3 ASC Col4 ASC By the above method you will be able to sort N number of columns

Have you tried using the DataTable Select filterExpression sortExpression method

[.net] Datatable select method ORDER BY clause

Use

datatable.select("col1='test'","col1 ASC")

Then before binding your data to the grid or repeater etc, use this

datatable.defaultview.sort()

That will solve your problem.

Examples related to .net

• You must add a reference to assembly 'netstandard, Version=2.0.0.0 • How to use Bootstrap 4 in ASP.NET Core • No authenticationScheme was specified, and there was no DefaultChallengeScheme found with default authentification and custom authorization • .net Core 2.0 - Package was restored using .NetFramework 4.6.1 instead of target framework .netCore 2.0. The package may not be fully compatible • Update .NET web service to use TLS 1.2 • EF Core add-migration Build Failed • What is the difference between .NET Core and .NET Standard Class Library project types? • Visual Studio 2017 - Could not load file or assembly 'System.Runtime, Version=4.1.0.0' or one of its dependencies • Nuget connection attempt failed "Unable to load the service index for source" • Token based authentication in Web API without any user interface

Examples related to select

• Warning: Use the 'defaultValue' or 'value' props on <select> instead of setting 'selected' on <option> • SQL query to check if a name begins and ends with a vowel • Angular2 *ngFor in select list, set active based on string from object • SQL: Two select statements in one query • How to get selected value of a dropdown menu in ReactJS • DATEDIFF function in Oracle • How to filter an array of objects based on values in an inner array with jq? • Select unique values with 'select' function in 'dplyr' library • how to set select element as readonly ('disabled' doesnt pass select value on server) • Trying to use INNER JOIN and GROUP BY SQL with SUM Function, Not Working

Examples related to datatable

• Can't bind to 'dataSource' since it isn't a known property of 'table' • How to get a specific column value from a DataTable in c# • Change Row background color based on cell value DataTable • How to bind DataTable to Datagrid • Find row in datatable with specific id • Datatable to html Table • How to Edit a row in the datatable • How do I use SELECT GROUP BY in DataTable.Select(Expression)? • How to fill a datatable with List<T> • SqlBulkCopy - The given value of type String from the data source cannot be converted to type money of the specified target column

Examples related to methods

• String method cannot be found in a main class method • Calling another method java GUI • ReactJS - Call One Component Method From Another Component • multiple conditions for JavaScript .includes() method • java, get set methods • includes() not working in all browsers • Python safe method to get value of nested dictionary • Calling one method from another within same class in Python • TypeError: method() takes 1 positional argument but 2 were given • Android ListView with onClick items

Examples related to sql-order-by

• Laravel Eloquent: Ordering results of all() • SQL for ordering by number - 1,2,3,4 etc instead of 1,10,11,12 • SQL ORDER BY multiple columns • How to use Oracle ORDER BY and ROWNUM correctly? • MySQL order by before group by • Ordering by specific field value first • MySQL ORDER BY multiple column ASC and DESC • How can I get just the first row in a result set AFTER ordering? • SQL order string as number • Order by multiple columns with Doctrine