<div>
Looks like you are sorting using text data. You need to use the Integer sorting. Can I see the code you using.?
</div>

<div>
Thank you Pawan for your response. &nbsp;I am trying to generate Serial Number (intSN ) in the loop and populate the Grid View. &nbsp;Here I am converting it to string before it is displayed. &nbsp;But it fails during Sorting. 
 
&nbsp; &nbsp; if (objSqlReader.HasRows == true) 
&nbsp; &nbsp; { 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RecordFound = true; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;string strCustInfo = string.Empty; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;string[] arrCustInfo = null; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;int intSN = 0; 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while (objSqlReader.Read()) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;strCustInfo = objSqlReader.GetValue(objSqlReader.GetOrdinal(&quot;CUSTOMER&quot;)).ToString().Trim(); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;if (strCustInfo.IndexOf('|') != -1) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;intSN += 1; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;objOptNode1.Attributes[&quot;SN&quot;].InnerText = intSN.ToString(); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;objOptNode1.Attributes[&quot;LASTNAME&quot;].InnerText = arrCustInfo[0].Trim(); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;objOptNode1.Attributes[&quot;FIRSTNAME&quot;].InnerText = arrCustInfo[1].Trim(); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;. 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;. 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;. 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;} 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;objFailureReasonOutXml.DocumentElement.AppendChild(objOptNode1); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;objOptNode1 = objOptNode.CloneNode(true); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} 
&nbsp; &nbsp; }
</div>

<div>
You need to implement a natural sort comparer. &nbsp;From a previous EE PAQ - <a href="https:/Q_28586081.html#a40515582" rel="ugc">https:/Q_28586081.html#a40515582</a>
<pre><code class="code-10 nolinks" id="code-20-42358649-1">	public class NaturalComparer : Comparer&lt;string&gt;, IDisposable
	{
		private Dictionary&lt;string, string[]&gt; table;

		public NaturalComparer()
		{
			table = new Dictionary&lt;string, string[]&gt;();
		}

		public void Dispose()
		{
			table.Clear();
			table = null;
		}

		public override int Compare(string x, string y)
		{
			if (x == y)
			{
				return 0;
			}
			string[] x1, y1;
			if (!table.TryGetValue(x, out x1))
			{
				x1 = Regex.Split(x.Replace(&quot; &quot;, &quot;&quot;), &quot;([0-9]+)&quot;);
				table.Add(x, x1);
			}
			if (!table.TryGetValue(y, out y1))
			{
				y1 = Regex.Split(y.Replace(&quot; &quot;, &quot;&quot;), &quot;([0-9]+)&quot;);
				table.Add(y, y1);
			}

			for (int i = 0; i &lt; x1.Length &amp;&amp; i &lt; y1.Length; i++)
			{
				if (x1[i] != y1[i])
					return PartCompare(x1[i], y1[i]);
			}

			if (y1.Length &gt; x1.Length)
				return 1;
			else if (x1.Length &gt; y1.Length)
				return -1;
			else
				return 0;
		}

		private static int PartCompare(string left, string right)
		{
			int x, y;
			if (!int.TryParse(left, out x))
				return left.CompareTo(right);

			if (!int.TryParse(right, out y))
				return left.CompareTo(right);

			return x.CompareTo(y);
		}
	}
</code></pre>
 
Usage -
<pre><code class="code-10 nolinks" id="code-20-42358649-2">	class Program
	{
		private static List&lt;UserPrincipal&gt; users = new List&lt;UserPrincipal&gt;();

		static void Main(string[] args)
		{
			PrincipalContext context = new PrincipalContext(ContextType.Domain);
			UserPrincipal user = new UserPrincipal(context);
			PrincipalSearcher searcher = new PrincipalSearcher(user);
			foreach (Principal result in searcher.FindAll())
			{
				UserPrincipal upe = result as UserPrincipal;
				if (upe != null)
					users.Add(upe);
			}

			using (NaturalComparer comparer = new NaturalComparer())
				users.Sort((a, b) =&gt; comparer.Compare(a.SamAccountName, b.SamAccountName));

			foreach (UserPrincipal up in users)
				Console.WriteLine(&quot;User: {0}; SamAccount: {1}&quot;, up.Name, up.SamAccountName);

			Console.ReadLine();
		}
	}
</code></pre>
 
-saige-
</div>

<div>
Hello it_saige, 
Please look at my code and apply a fix. &nbsp;That would be very helpful. 
 
Thank you!
</div>

<div>
Hi RadhaKrishnaKiJaya; 
 
To your statement, &quot;But, I have a numeric column (Serial Number) not working as expected.&quot;, It is because the characters being sorted are text character and are representing numeric data which they are not. As you stated, &quot;I am trying to generate Serial Number (intSN ) in the loop and populate the Grid View. &nbsp;Here I am converting it to string before it is displayed. &nbsp;But it fails during Sorting.&quot;. If you need to convert to a string you should pad the beginning of the string with leading zeros as many as the largest serial number that can be created or to not convert to text characters and just use as integer values.
</div>

<div>
Fernando Soto, 
Thank you for your reply. &nbsp;I tried to populate the column without converting it to string (see code below). &nbsp;But got the error &quot;cannot implicitly convert type int to string&quot; during coding. &nbsp;If I use leading zeros, I don't want to display them in the column as I just want to display 1, not 001. &nbsp;Please let me know if there is a way to hide it. &nbsp;Thank you again! 
 
objOptNode1.Attributes[&quot;SN&quot;].InnerText = intSN;
</div>

<div>
Hi RadhaKrishnaKiJaya 
 
In order to help with this question I need to know what the data type of objOptNode1 is so please post the class definition as well as how you load the DataGrid. 
Are you loading a XML document and loading the DataGrid with it?
</div>

<div>
Fernando Soto, 
Yes, we are loading the XML document to the DataGrid directly. &nbsp;Please see below code. &nbsp; 
 
Thank you! 
 
 
XmlDocument objFailureReasonOutXml = new XmlDocument(); 
XmlNode objOptNode1; 
 
. 
if (objSqlReader.HasRows == true) 
&nbsp; &nbsp; { 
&nbsp; &nbsp; &nbsp; RecordFound = true; 
&nbsp; &nbsp; &nbsp; string strCustInfo = string.Empty; 
&nbsp; &nbsp; &nbsp; string[] arrCustInfo = null; 
&nbsp; &nbsp; &nbsp; int intSN = 0; 
 
&nbsp; &nbsp; &nbsp; while (objSqlReader.Read()) 
&nbsp; &nbsp; &nbsp; { 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strCustInfo = objSqlReader.GetValue(objSqlReader.GetOrdinal(&quot;CUSTOMER&quot;)).ToString().Trim(); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (strCustInfo.IndexOf('|') != -1) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; { 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; intSN += 1; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; objOptNode1.Attributes[&quot;SN&quot;].InnerText = intSN.ToString(); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; objOptNode1.Attributes[&quot;LASTNAME&quot;].InnerText = arrCustInfo[0].Trim(); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; objOptNode1.Attributes[&quot;FIRSTNAME&quot;].InnerText = arrCustInfo[1].Trim(); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; . 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; . 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; . 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; objFailureReasonOutXml.DocumentElement.AppendChild(objOptNode1); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; objOptNode1 = objOptNode.CloneNode(true); 
&nbsp; &nbsp; &nbsp; } 
&nbsp; &nbsp; } 
. 
 
objFailureReasonOutXml.DocumentElement.AppendChild(objOptNode1);
</div>

<div>
Go to the page load 
add 
 

<pre><code class="code-1 nolinks" id="code-20-42358881-1">yourGridviewId.SortCompare += YourSorting; 
</code></pre>
 
Add the below function- 
 

<pre><code class="code-1 nolinks" id="code-20-42358881-2">private void YourSorting(object sender, DataGridViewSortCompareEventArgs e)
{
 int FirstCellValue = int.Parse(e.CellValue1.ToString())
	, SecondCellValue = int.Parse(e.CellValue2.ToString());
 e.SortResult = FirstCellValue.CompareTo(SecondCellValue);
 e.Handled = true;
}
</code></pre>
</div>

<div>
Hello Pawan Kumar, 
This is a Web project. &nbsp;DataGridViewSortCompareEventArgs can be used in Windows Forms. &nbsp;Please let me know if I am missing anything. 
 
Thank you!
</div>

<div>
Hi RadhaKrishnaKiJaya 
 
The XML attribute is a text value and so when directly assigned to a DataGrid it does not convert it to numeric data. I am not a web developer so I need to see how you create the DataGrid and how you initialize it and how you assign the XML to the DataGrid so I can see if there is a way to do what you need.
</div>

<div>
I added the leading zeros manually during reading the lines as below. &nbsp;I did not find any better solution. 
 
objOptNode1.Attributes[&quot;SN&quot;].InnerText = intSN.ToString(&quot;000&quot;); 
 
Thank you all.
</div>

<div>
Hi RadhaKrishnaKiJaya; 
 
As I stated in my post #42358684 to do what you ended up doing but you did not assign the points to my solution.
</div>

<div>
Hello Fernando, 
I totally forgot about your post. &nbsp;Yes, you are 100% right. &nbsp;I missed that. 
 
Thank you again!
</div>

<div>
Not a problem RadhaKrishnaKiJaya, all is good.
</div>

<div>
<div class="content wysiwyg-content">
Hello Experts, 
I am trying to sort few columns in a Gridview. &nbsp;All the Alpha columns working as expected. &nbsp;But, I have a numeric column (Serial Number) not working as expected. &nbsp;Please see below and let me know how to fix it. 
 
Thank you very much in advance. 
 
Serial Number (when page loaded) 
1 
2 
3 
4 
5 
6 
7 
8 
9 
10 
11 
12 
13 
14 
15 
 
Serial Number (when sorted) 
1 
10 
11 
12 
13 
14 
15 
2 
3 
4 
5 
6 
7 
8 
9
</div>
</div>

Hello Experts,
I am trying to sort few columns in a Gridview.  All the Alpha columns working as expected.  But, I have a numeric column (Serial Number) not working as expected.  Please see below and let me know how to fix it.

Thank you very much in advance.

Serial Number (when page loaded)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Serial Number (when sorted)
1
10
11
12
13
14
15
2
3
4
5
6
7
8
9

Sort Gridview columns in C#

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).