ASP SNIPPETS

Sending Email With BCC and Attachment in ASP.NET

2010-08-07T12:36:00.003+05:30

Let’s see how to send Email with BCC and attachment with ASP.NET.

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Net;

using System.Net.Mail;

using System.IO;

public partial class sendmail : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnmail_Click(object sender, EventArgs e)

{

string mAttach;

MailMessage msg = new MailMessage();

MailAddress ma = new MailAddress("from email-ID", "Name");

msg.From = ma;

if (txtTo.Text.Trim().Length != 0)

{

msg.To.Add(txtTo.Text);

}

if (txtBcc.Text.Trim().Length != 0)

{

msg.Bcc.Add(txtBcc.Text);

}

if (txtCC.Text.Trim().Length != 0)

{

msg.CC.Add(txtCC.Text);

}

Attachment at = new Attachment(FileResume.PostedFile.InputStream, FileResume.FileName);

msg.Attachments.Add(at);

msg.Subject = txtSubject.Text;

msg.Body = txtMessage.Text;

try

{

SmtpClient smpt = new SmtpClient();

smpt.Host = "Your Server Name";

smpt.Send(msg);

}

catch (Exception ex)

{

}

The System.Net.Mail namespace is the one which contains the classes used to send electronic mail to a Simple Mail Transfer Protocol (SMTP) server for delivery.

SmtpClient class is the one which allows applications to send e-mail by using the Simple Mail Transfer Protocol (SMTP).

Mail Message is the one that represents an e-mail message that can be sent using the SmtpClient class.

Attachment is the class that represents an attachment to an e-mail.

Convert Url String to Hyperlinks

2010-08-02T16:47:00.002+05:30

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.IO;

using System.Text;

public partial class ReplaceString : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

string strUrl = MakeUrl("Hello. This is my site http://www.google.com Please Visit.");

Response.Write(strUrl);

}

private static string MakeUrl(string input)

{

var work = input.Split(' ');

var output = new StringBuilder(2 * input.Length);

for (int i = 0; i <>

{

var element = work[i];

if (element.StartsWith("http://"))

{

var site = element.Replace("http://", "");

element = " + element + "'>" + site + "";

}

else if (element.StartsWith("www"))

{

var site = element.Replace("http://", "");

element = " + element + "'>" + site + "";

}

else if (element.EndsWith(".com"))

{

var site = element.Replace("http://", "");

element = " + element + "'>" + site + "";

}

output.Append(element + " ");

}

return output.ToString();

}

AutoComplete Extender Content Overridden Issue

2010-08-02T16:02:00.001+05:30

While using AutocompleteExtender, we could notice where the other controls are been overridden and the autocomplete extender text being overlapped by the other controls near by.This could be overcome by calling the OnClientShown property of the AutocompleteExtender control.

<cc1:AutoCompleteExtender ID="ace" runat="server" OnClientShown="ShowOptions">

cc1:AutoCompleteExtender>

function ShowOptions(control, args) {

control._completionListElement.style.zIndex = 10000001;

}

script>

Enable/Disable Button Based On Empty TextBoxes Using JavaScript

2010-07-28T17:31:00.000+05:30

Add this script to the page

function SetButtonStatus(sender, target)

{

if ( sender.value.length >= 12 )

document.getElementById(target).disabled = false;

else

document.getElementById(target).disabled = true;

}

script>

<asp:TextBox ID="txtText" runat="server" onkeyup="SetButtonStatus(this, 'btnButton')">asp:TextBox>

<asp:Button ID="btnButton" runat="server" Text="Button" Enabled="false" />

This JavaScript validates the textbox and enables the button only if the textbox contains 12 characters.

Set Focus to Textbox in Gridview inside Update Panel

2010-07-28T16:53:00.000+05:30

Let’s see how to set focus to textbox inside Gridview inside Update Panel.

So the Gridview is designed something like this..

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

<asp:GridView ID="gvattend" runat="server" CellPadding="5"

AutoGenerateColumns="false" AllowPaging="true" PageSize="50"

GridLines="none" HeaderStyle-CssClass="tableheadbg" BorderStyle="solid" RowStyle-CssClass="nestedtable" AlternatingRowStyle-CssClass="nestedtable1"

BorderColor="#a3b4a0" BorderWidth="1px" Width="100%" TabIndex="6" >

<asp:TemplateField HeaderText="Marks Obtained" >

<asp:Textbox id="txtmarksobtain" runat="server" Width="150" AutoPostBack="true" OnTextChanged=" txtmarksobtain _TextChanged" >asp:Textbox>

ItemTemplate>

asp:TemplateField>

<asp:TemplateField HeaderText="Percentage" >

<asp:Textbox id="txtpercentage" runat="server" Width="150" Enabled="false" >asp:Textbox>

<asp:CompareValidator ID="cmp3" runat="server" ControlToValidate="txtpercentage" Operator="DataTypeCheck" Type="Double" ErrorMessage="Enter Numeric Value Alone" Display="dynamic" ValidationGroup="subject">asp:CompareValidator>

ItemTemplate>

asp:TemplateField>

Columns>

<tr><td align="center" valign="middle" ><span class="redcolor">No Data Foundspan> td>tr>

table>

EmptyDataTemplate>

asp:GridView>

ContentTemplate>

asp:UpdatePanel>

And in the Code Behind:

Protected Sub txtmarksobtain _TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtmaxmarks.TextChanged

For Each gv As GridViewRow In gvattend.Rows

Dim txtmarksobtain As TextBox = DirectCast(gv.FindControl("txtmarksobtain"), TextBox)

If txtmarksobtain.Text = "" Then

ScriptManager.RegisterStartupScript(Me, Me.GetType(), "selectAndFocus", "$get('" + txtmarksobtain.ClientID + "').focus();$get('" + txtmarksobtain.ClientID + "').select();", True)

End If

End Sub

And thus focus is set to textbox inside Gridview

Prevent Flicker from CollapsiblePanelExtender on PageLoad

2010-07-24T18:24:00.000+05:30

Let’s see how to fix the flickering of the CollapsiblePanelExtender when collapsed is set to true (Collapsed="true")

Here is my CollapsiblePanelExtender

<cc1:CollapsiblePanelExtender ID="CollapsePanel1" runat="server" SuppressPostBack="true" CollapseControlID="btnCancel" Collapsed="true" CollapsedText="Show Time" ExpandControlID="imgPostQuestion" ExpandedText="Hide Time" TargetControlID="panelPost"> cc1:CollapsiblePanelExtender>

Your TargetPanel is here

<asp:Panel ID="panelPost" runat="server" CssClass="cpBody">

<div>

//Ur collapsible Content

div>

asp:Panel>

And now we are preventing the flickering by the CSS style and the style is as follows.

.cpBody

{

height:0px;

overflow: hidden;

}

There we found the solution for the flickering..

Convert String To Title Case in C#

2010-07-24T17:55:00.000+05:30

Here is the code to convert any string to Title Case in C#.

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

using System.Text;

using System.Net.Mail;

using System.Text.RegularExpressions;

public partial class lSample : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

string strInsName;

strInsName = "hello world";

strInsName = strInsName.ToLower();

strInsName = System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(strInsName);

Response.Write(strInsName);

}

First we need to convert the string to lower.. Only then the System.Globalization.CultureInfo.CurrentUICulture class will convert the string to Title Case.

Handling PostBack on Url Rewriting

2010-07-24T17:29:00.000+05:30

So many of us stuck up with the problem of Postback during URL rewriting. During Postback the Url breaks up and throws error. Here is a solution to overcome this. We need to write this script in the last of the page (ie. In The Body Section.)

function NotPostback(sNewFormAction)

{

if(document.layers) //The browser is Netscape 4

{

document.layers['Content'].document.forms[0].action = sNewFormAction;

}

else //It is some other browser that understands the DOM

{

document.forms[0].action = sNewFormAction;

}

NotPostback(document.URL);

script>

This calls the same Url on Postback too and thus it is solved..

Custom SEO Friendly Paging in Datalist like Google

2010-07-24T16:53:00.009+05:30

Let’s see how to do paging with Datalist in as Next, Previous and with customized Page numbers as that of Gridview.

Here I have the following things..

i) A datalist dlCollegeList to which we are to implement the paging

ii) Two Hyperlinks (hyPrevious & hyNext) for navigating backward and forward

iii) Finally, a literal (litPaging) for displaying page numbers.

Here am using the stored procedure to fill my datalist and now let’s move to the implementation.

My datalist and Navigation links markup is as follows.

<div>

<asp:DataList ID="dlCollegeList"runat="server"

OnItemDataBound="dlCollegeList_ItemDataBound"onitemcommand="dlCollegeList_ItemCommand"Width="100%"

<div class="col-photo"><asp:HyperLinkID="hyInstLogo" runat="server"

NavigateUrl='' ><asp:ImageButton ID="imgLogo"ToolTip='' runat="server"Width="63px" Height="60px"CssClass="col-photo-border"/>asp:HyperLink>div>

<h4><asp:Label ID="lblclgId"runat="server" Text=''Visible="false">asp:Label><asp:HyperLink ID="hyinstName"runat="server"

NavigateUrl=''Text=''>asp:HyperLink>h4>

div>

<divclass="cityname"><asp:HyperLinkID="hyCity" runat="server"Text=''>asp:HyperLink><asp:LabelID="lblCity" runat="server" Text=''Visible="false">asp:Label>div>

div>

ItemTemplate>

asp:DataList>

<ul>

<li> <asp:HyperLinkID="hyPrevious"runat="server">Previousasp:HyperLink>li><li><asp:Literal ID="litPaging"runat="server"EnableViewState="true">asp:Literal>li><li><asp:HyperLink ID="hyNext"runat="server">Nextasp:HyperLink>li>

ul>

div>

Stored Procedure :

CREATE PROCEDURE[dbo].[listInstitute]

@startRowIndex int,

@pageSize int,

@totalCount int output,

@category varchar(max)

BEGIN

SET NOCOUNT ON;

SET @totalCount = 0

SET @startRowIndex =@startRowIndex + 1

BEGIN

SELECT * FROM (

Select collegedetails.*,ROW_NUMBER() OVER (ORDER BYcollegedetails.inst_name asc) asRowNum

FROM collegedetails wherecategory like '%' + @category + '%'

) as ArticleList

WHERE

category like '%'+@category+'%'and (RowNum BETWEEN@startRowIndex AND(@startRowIndex + @pageSize) -1)

ORDER BY inst_name DESC

SELECT @totalCount =Count(clgid) FROM collegedetailswhere category like'%'+@category+'%'

END

This is the stored procedure which is used to fill the datalist and lets see the attributes used here.

· The startRowIndex is the one which sets the initial row to display and this calculates the rowindex of records to be displayed in that particular page.

· the pageSize denotes the number of records per page,

· totalCount gets the total number of records returned by the select command

Code Behind :

Declarations:

int _startIndex = 0;

int _thisPage = 1;

int _pageSize = 10;

int _totalNumberOfRows = 0;

string sPage;

SqlConnection con = newSqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ConnectionString);

private void BindGridView ()

{

DataTable dTable = newDataTable();

using (SqlConnection conn = newSqlConnection(connStr))

{

using (SqlCommand dCmd = newSqlCommand())

{

SqlParameter[] prms = newSqlParameter[4];

prms[0] = newSqlParameter("@startRowIndex",SqlDbType.Int);

prms[0].Value = _startIndex;

prms[1] = newSqlParameter("@pageSize",SqlDbType.Int);

prms[1].Value = _pageSize;

prms[2] = newSqlParameter("@totalCount",SqlDbType.Int);

prms[2].Direction =ParameterDirection.Output;

prms[3] = newSqlParameter("@category",SqlDbType.VarChar);

prms[3].Value = Request["category"].Replace("-"," ");

dCmd.CommandText ="listInstitute";

dCmd.CommandType =CommandType.StoredProcedure;

dCmd.Parameters.AddRange(prms);

dCmd.Connection = conn;

using (SqlDataAdapter dAd = newSqlDataAdapter())

{

// assign the select command to the Adapter object

dAd.SelectCommand = dCmd;

// now open the connection

conn.Open();

dTable.Clear();

dAd.Fill(dTable);

conn.Close(); // close the connection

}

_totalNumberOfRows =int.Parse(prms[2].Value.ToString());

}

dlCollegeList.DataSource = dTable;

dlCollegeList.DataBind();

litPaging.Text = GetPaging(_totalNumberOfRows, _pageSize, 10);

//LitPagingTop.Text = GetPaging(_totalNumberOfRows, _pageSize, 10);

}

string GetPaging(int totalRecords,int pageSize, inttotalNumericLinks)

{

if (totalRecords <= pageSize)

{

return "";

}

StringBuilder str = newStringBuilder();

//Get Total no of pages

int totalPages = totalRecords / pageSize + (totalRecords % pageSize > 0 ? 1 : 0);

//Get Current Page no

int currentPageNo = 1;

string pageUrl = Context.Request.Url.AbsolutePath;

if(Context.Request.QueryString["page"] == null)

{

currentPageNo = 1;

}

if(Context.Request.QueryString["page"] != null)

{

currentPageNo = 1 + (Convert.ToInt32(Context.Request.QueryString["page"]) - 1);

}

//Add previous button

if (currentPageNo > 1)

{

str.Append(string.Format("href=\"http://www.yoursite.com/ListInstitute/"+Request["category"].ToString()+ "/{0}\" title=\"Previous page\">", (currentPageNo - 2) + 1));

}

//Add Numeric link

int sp, ep;

if (totalNumericLinks >= totalPages)

{

sp = 1;

ep = totalPages;

}

else

{

if (currentPageNo - totalNumericLinks / 2 > 0)

{

ep = (currentPageNo + totalNumericLinks / 2 - (totalNumericLinks - 1) % 2);

ep = ep <>

}

else

{

ep = totalNumericLinks;

}

sp = ep - totalNumericLinks + 1 > 0 ? ep - totalNumericLinks + 1 : 1;

}

for (int p = sp; p <= ep; p++)

{

//For Current Page, No Link, Bold Text

if (p == currentPageNo)

{

str.Append(String.Format(" {0}", p.ToString()));

}

else

{

str.Append(String.Format(" + Request["category"].ToString() +"/{1}\" title=\"{0}\">{0} ", p, (p - 1) + 1));

}

if (currentPageNo == totalPages)

{

hyNext.Visible = false;

// hyNextTop.Visible = false;

}

if (currentPageNo == 1)

{

hyPrevious.Visible = false;

//hyPreviousTop.Visible = false;

}

if (Request["page"] == null)

{

hyNext.Visible = true;

//hyNextTop.Visible = true;

}

if (currentPageNo > 1)

{

hyPrevious.Visible = true;

//hyPreviousTop.Visible = true;

}

return str.ToString();

}

GetPaging is the function which Is used to perform the paging as per our requirement. Here I have customised the GetPaging function to return only 10 pagenumbers. So the Literal control displays only 10 page numbers in between the Previousand Next links and this can be modified according to your requirement.

You could see the page numbers between the links. This pagenumber will be passed through the query string for calculating the startindex and rowindex of the records to be displayed. Moreover this paging is SEO friendly.

BindGridView is the function which executes the stored procedure.

And now in my PageLoad my function is called as below..

protected void Page_Load(objectsender, EventArgs e)

{

if (!IsPostBack)

{

// check for current index

if (Request["page"] != null)

{

int.TryParse(Request["page"].ToString(), out _thisPage);

s =Convert.ToInt32(Request["page"].ToString());

st = (s - 1) * 10;

string str = Convert.ToString(st);

int.TryParse(str, out _startIndex);

}

int pSer = s - 1;

int nSer = s + 1;

if (s == 0)

{

nSer = 2;

}

BindGridViewArticels(); // bind articles

hyPrevious.NavigateUrl ="http://www.yoursite.com/ListInstitute/"+Request["category"].ToString()+"/" + pSer;

hyNext.NavigateUrl ="http://www.yoursite.com/ListInstitute/"+ Request["category"].ToString() +"/" + nSer;

}

if (_totalNumberOfRows <= 10)

{

hyNext.Visible = false;

hyPrevious.Visible = false;

}

And now with this Custom pagination for Datalist is done. So here is my Datalist with paging implemented.

You can see my Datalist with Pagination implemented

AutoComplete Extender like Google

2010-07-23T17:10:00.001+05:30

You might have noticed while searching in Google, the search keywords will be bold. Let’s see how to perform this in ASP.NET. We can do this using JavaScript

function BoldChildren(){

var behavior = $find('AutoCompleteEx');

var target = behavior.get_completionList();

if (behavior._currentPrefix != null)

{

var prefix = behavior._currentPrefix.toLowerCase();

var i;

for (i = 0; i <>

{

var sValue = target.childNodes[i].innerHTML.toLowerCase();

if (sValue.indexOf(prefix) != -1)

{

var fstr = target.childNodes[i].innerHTML.substring(0, sValue.indexOf(prefix));

var estr = target.childNodes[i].innerHTML.substring(fstr.length + prefix.length, target.childNodes[i].innerHTML.length);

target.childNodes[i].innerHTML = fstr + prefix + '' + estr +'';

}

function aceSelected(sourse, e)

{

var value = e.get_value();

if (!value)

{

if (e._item.parentElement && e._item.parentElement.tagName == "LI")

value = e._item.parentElement.attributes["_value"].value;

else if (e._item.parentElement && e._item.parentElement.parentElement.tagName == "LI")

value = e._item.parentElement.parentElement.attributes["_value"].value;

else if (e._item.parentNode && e._item.parentNode.tagName == "LI")

value = e._item.parentNode._value;

else if (e._item.parentNode && e._item.parentNode.parentNode.tagName == "LI")

value = e._item.parentNode.parentNode._value;

else

value = "";

}

sourse.get_element().value = value;

document.getElementById('<%=btnSearch.ClientID%>').click();

}

script>

The function BoldChildren() is the one which bolds the search content in the Autocomplete textbox and the function aceSelected() makes the search text normal and triggeres the search event

Your AutoComplete Textbox and the Search button Looks like this.

<asp:TextBox ID="txtSearch" runat="server" AutoCompleteType="Disabled"

CssClass="textbox1" Width="410px" ToolTip="Enter Search Term" >asp:TextBox>

<cc1:AutoCompleteExtender runat="server" ID="autoComplete1" CompletionListCssClass="AutoExtender" CompletionListItemCssClass="AutoExtenderList" CompletionListHighlightedItemCssClass="AutoExtenderHighlight" BehaviorID="AutoCompleteEx" OnClientShown="ShowOptions" OnClientPopulated="BoldChildren" OnClientItemSelected="aceSelected" CompletionInterval="1" CompletionSetCount="10" TargetControlID="txtSearch" ServicePath="http://www.Yoursite.com/Autocomplete.asmx" ServiceMethod="GetCountriesList" MinimumPrefixLength="1" EnableCaching="true">cc1:AutoCompleteExtender>

With this we have implemented search similar to Google which bolds the user search keyword.

Disable browser back button using javascript

2010-07-23T16:27:00.000+05:30

In this article let’s see how to disable the browsers back button, to prevent the user navigate back after he had logged out his session. We can do this by JavaScript.

Add this JavaScript to the html section of your logout page

function preventBack(){window.history.forward();}

setTimeout("preventBack()", 0);

window.onunload=function(){null};

script>

And in the code behind you need to clear the session. The code behind page looks like this

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

public partial class logout : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

lblPreURL.Text = Request.UrlReferrer.ToString();

}

DisableBufferingOnPage();

Session.Clear();

FormsAuthentication.SignOut();

}

protected void DisableBufferingOnPage()

{

Response.Buffer = true;

Response.ExpiresAbsolute = DateTime.Now.AddDays(-1);

// set expiry date in the past

Response.Expires = -1;

Response.CacheControl = "no-cache";

Response.Cache.SetNoStore();

Response.AppendHeader("Pragma", "no-cache");

Response.AppendHeader("Cache-Control", "no-cache");

Response.CacheControl = "no-cache";

Response.Expires = -1;

Response.ExpiresAbsolute = new DateTime(1900, 1, 1);

Response.Cache.SetCacheability(HttpCacheability.NoCache);

}

So once the user logs out, the session is cleared and he will be redirected the previous Url. We are not disabling the browsers back button, but we are preventing the user to navigate backward after his session is cleared.

Import .dbf data to gridview and SQL

2010-07-23T16:13:00.001+05:30

In this example am explaining how to insert a .dbf file into a Gridview and to a database table..

To perform this you need to design a table with the structure similar to your .dbf file.

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.OleDb;

using System.Data.Odbc;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

System.Data.Odbc.OdbcConnection oConn = new System.Data.Odbc.OdbcConnection();

Con.ConnectionString = @"Driver={Microsoft dBase Driver (*.dbf)};SourceType=DBF;SourceDB=D:\Sample\;Exclusive=No; Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;";

Con.Open();

System.Data.Odbc.OdbcCommand oCmd = oConn.CreateCommand();

oCmd.CommandText = @"SELECT * FROM D:\Sample\IndiaDB\FileName.dbf";

DataTable dat = new DataTable();

dat.Load(oCmd.ExecuteReader());

Con.Close();

GridView1.DataSource = dat;

GridView1.DataBind();

}

With this your .dbf file data will be imported to the Gridview. Lets see the code for doing the same to a table..

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.OleDb;

using System.Data.Odbc;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["YourConnection"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

DataTableReader reader = dt.CreateDataReader();

conn.Open(); ///this is my connection to the sql server

SqlBulkCopy sqlcpy = new SqlBulkCopy(conn);

sqlcpy.DestinationTableName = "YourTable"; //copy the datatable to the sql table

sqlcpy.WriteToServer(dt);

conn.Close();

}

And now your .dbf data can be imported to both Gridview and SQL table.

Implementing Search In Datalist and Highlight Search Text

2010-07-23T15:49:00.002+05:30

Let us see how to highlight the search keywords to make it easy for the user to identify his search results better. To perform this am using the Regex function to Highlight the search keywords.

This is the function used for highlighting ..

protected string HighlightText(string searchWord, string inputText)

{

if (searchWord != null && searchWord != "")

{

Regex expression = new Regex(searchWord.Replace(" ", "|"), RegexOptions.IgnoreCase);

return expression.Replace(inputText, new MatchEvaluator(ReplaceKeywords));

}

return inputText;

}

public string ReplaceKeywords(Match m)

{

return "" + m.Value + "";

}

To highlight the keyword u need to design your datalist lik this..

<asp:DataList ID="DataList1" runat="server">

<ItemTemplate>

<asp:Label ID="label1" runat="server"

Text='<%# Highlight(Eval("YourField").ToString()) %>'>

asp:Label>

ItemTemplate>

asp:DataList>

This ('<%# Highlight(Eval("YourField").ToString()) %>'>) is the one which highlights your Keyword. This is how we highlight the search keywords..

Asp.Net AJAX AutoComplete Extender From DB

2010-07-22T17:42:00.005+05:30

Here am explaining how you can use the AutoCompleteExtender control from ASP.NET AJAX Control Toolkit.. I have a Autocomplete Textbox which fetches data from the database and this is performed with Web service..

Place a webservice(WebService.asmx) in your AppCode folder. You need to add the ScriptService reference to your Webservice.

The Class function for the Webservice is as follows

using System;
using System.Collections.Generic;
using System.Web.Services;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
[WebService]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class AutoComplete : WebService
{
public AutoComplete()
{
}
[WebMethod]
public string[] GetCompletionList(string prefixText, int count)
{
if (count == 0)
{
count = 10;
}
DataTable dt = GetRecords(prefixText);
List items = new List(count);
for (int i = 0; i < dt.Rows.Count; i++)
{
string strName = dt.Rows[i][0].ToString(); items.Add(strName);
}
return items.ToArray();
}
public DataTable GetRecords(string strName)
{
string strConn = ConfigurationManager.ConnectionStrings["YourConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@Name", strName);
cmd.CommandText = "Select Distinct YourValue from YourTable where YourValue like +@Name+'%' ";
DataSet objDs = new DataSet();
SqlDataAdapter dAdapter = new SqlDataAdapter();
dAdapter.SelectCommand = cmd; con.Open();
dAdapter.Fill(objDs);
con.Close();
return objDs.Tables[0];
}
}

The CSS for the AutoComplete looks like this.

CSS:

.AutoExtender
{
font-family: Verdana, Helvetica, sans-serif;
font-size: .8em;
margin:0px;
font-weight: normal;
border:solid 1px #006699;

line-height:20px;
padding:0px;
background-color:White;
}

.AutoExtenderList
{
border-bottom:dotted 1px #006699;
cursor:pointer;
color:Maroon;
left:auto;
margin:0px;

}

.AutoExtenderHighlight
{
color:White;
background-color:#006699;
cursor:pointer;
margin:0px;
}

And add this properties to your Autocomplete Extender

CompletionListCssClass="AutoExtender" CompletionListItemCssClass="AutoExtenderList" CompletionListHighlightedItemCssClass="AutoExtenderHighlight" BehaviorID="AutoCompleteEx" OnClientShown="ShowOptions" OnClientPopulated="BoldChildren" OnClientItemSelected="aceSelected" CompletionInterval="1" CompletionSetCount="10" TargetControlID="txtSearch" ServicePath="~/Autocomplete.asmx" ServiceMethod="GetCountriesList" MinimumPrefixLength="1" EnableCaching="true">

And finally To enable OnClientItemSelected we need to perform something like this..

Place a hiddenfield and call the event in the script as below

function GetCode(source, eventArgs)

{

$get('<%=this.HiddenField1.ClientID%>').value = eventArgs.get_value();
$get('<%=this.ImageButton1.ClientID%>').click();

}

And now your AutocompleteExtender is done