Sort technique in AJAX

Sorting : Sorting is the process of putting a list or a group of items in a specific order. Sorting algorithm is an algorithm that puts elements of a list in a certain order.The most-used orders are numerical order. Efficient sorting is important for optimizing the use of algorithms that require sorted lists to work correctly; it is also often useful for the data and for producing human-readable.Sorting can also be done in ascending order (A-Z) or descending order (Z-A).

Condition : The Sorting Technique satisfies two condition.

The output is in non decreasing order.
The output is permutation or reordering of the input.

Step 1 : Open Visual Studio 2011.

Select File>New->WebSite.
Select ASP.NET WebSite.

Step 2 : Go to Solution Explorer and right-click.

Select Add->NewItem.
Select WebForm.
Default.aspx page open.

Step 3 : Now drag and drop controls from Toolbox.

Drag ScriptManager, UpdatePanel, GridView.

Define DataSource :

Step 4 : Go to Solution Explorer and right-click.

Select Add->NewItem.
Select SqlServer Database.

Step 5 : Go to Server Explorer and click in Database option.

Create Table for particular application.
Define the Data Field Property.

Step 6 : Go to Table option and right-click.

Select Show Table Data Option.
Define all field value.

Data Bind :

Step 7 : Go to Default.aspx Design option.

Select GridView Control.
Click in Arrow option of GridView.
Select Choose Data Source option.
Select New Data Source.

Add Connection String :

Step 8 : After Select of New Data Source option and select Sql DataBase.

Define SQL DataSource Name.

Step 9 : After that we click in Connection String option and select our Database and Established Connection.

Step 10 : Go to Default.aspx page and write the below code.

Code :

<div style="background-color: #00FF00">
<asp:ScriptManager ID="ScriptManager" runat="server" />
Search: <asp:TextBox ID="txtSearch" runat="server"
ontextchanged="txtSearch_TextChanged" />
<br />
<br />
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="search" />
<br />
<br />
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div class GridView>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
AllowSorting = "True" AllowPaging ="True" Width="540px" CssClass="yui"
DataKeyNames="ID" DataSourceID="SqlDataSource3">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="FIRSTNAME" HeaderText="FIRSTNAME"
SortExpression="FIRSTNAME" />
<asp:BoundField DataField="LASTNAME" HeaderText="LASTNAME"
SortExpression="LASTNAME" />
<asp:BoundField DataField="DEPARTMENT" HeaderText="DEPARTMENT"
SortExpression="DEPARTMENT" />
<asp:BoundField DataField="LOCATION" HeaderText="LOCATION"
SortExpression="LOCATION" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
SelectCommand="SELECT * FROM [RAJESH]"></asp:SqlDataSource>
</div>
<br />
<br />
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="txtSearch" EventName="TextChanged" />
</Triggers>
</asp:UpdatePanel>

Step 11 : Go to Default.aspx page and write the code for sorting and searching.

Code :

public partial class _Default : System.Web.UI.Page
{
string searcstring = "";
protected void Page_Load(object sender, EventArgs e)
{
txtSearch.Attributes.Add("onkeyup", "setTimeout('__doPostBack(\'" + txtSearch.ClientID.Replace("_", "$") + "\',\'\')', 0);");
if (!IsPostBack)
{
GridView1.DataBind();
}
}
protected void txtSearch_TextChanged(object sender, EventArgs e)
{
string srch= txtSearch.Text;
if (GridView1.HasAttributes.Equals(srch))
{
GridView1.SelectedValue.Equals(srch);
}
searcstring = txtSearch.Text;
}
public string HighlightText(string InputTxt)
{
string Search_Str = txtSearch.Text.ToString();
// Setup the regular expression and add the Or operator.
Regex RegExp = new Regex(Search_Str.Replace(" ", "|").Trim(), RegexOptions.IgnoreCase);
// Highlight keywords by calling the
//delegate each time a keyword is found.
return RegExp.Replace(InputTxt, new MatchEvaluator(ReplaceKeyWords));
// Set the RegExp to null.
RegExp = null;
}
public string ReplaceKeyWords(Match m)
{
return "<span class=highlight>" + m.Value + "</span>";
}
protected void Button1_Click(object sender, EventArgs e)
{
GridView1.Visible = true;
}

Step 12 : Now we press F5 and run the application.

Step 13 : Click on the Id and the data in the grid view will sort in ascending order.