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.