How to find the maximum value among a list of alpanumeric characters in a database in asp.net query?

How to find the maximum value among a list of alpanumeric characters in a database in asp.net query?

May 22, 2010 James 2 comments

ASP.NET alpanumeric, among, ASP.NET, Characters, database, Find, list, Maximum, query, value

Comments

Leave a comment Trackback

Written by a_non_a_miss_2000 about 2 years ago.

When you try to sort or pull a max value from a TEXT field, sorting won’t be the same as a numeric field. A text sort will sort by ranking on a per character basis.

So, ser9 will be a “higher” value than ser11 because the function considers “ser9″ higher than “ser1xxxxxxxxx….”.

The Data Analyst – http://www.squidoo.com/thedataanalyst
Written by v-1 about 2 years ago.

Yes that is possible.you can use Compute(“MAX)

connection.Open();
OleDbCommand mycommand = new OleDbCommand();
mycommand.Connection = connection;
DataTable categories = GetDataTable(“categories”, “SELECT * FROM categories”, connection);
string orders = categories.Compute(“MAX(id_category)”, “”).ToString();

Comment Pages:

Leave a Comment

You must be logged in to post a comment.

Win Web Hosting Home Page

Cheap Windows Hosting

Archives

Recent Posts

Categories

Meta