AutoCompliet of jquery

   <script type="text/javascript" src="js/jquery-1.7.2.min.js"></script>
  <script type="text/javascript" src="js/jquery-ui.js"></script>
 <script type="text/javascript">
        var availableTags;
        $(function () {
            var cValue = document.getElementById("hdnList").value
            var list = cValue.split(",");
            availableTags = list;
            $("#txtProjectname").autocomplete({
                source: availableTags
            });
        });
    </script>


<asp:HiddenField ID="hdnList" runat="server" />
     <input type="text" id="txtProjectname" class="inputBox" value="Type project name" onfocus="this.value=''" />

void BindProjectName()
    {
        System.Text.StringBuilder sb = new System.Text.StringBuilder();
        DataSet ds = Project_Master.GetAllProjectName();
        List<string> lstProjectName = new List<string>();
        foreach (DataRow dr in ds.Tables[1].Rows)
        {

            lstProjectName.Add(dr["ProjectName"].ToString().Trim().Replace("'", "") + " - " + dr["locationarea"].ToString().Trim().Replace("'", ""));
        }

        //sb.Append("[");
        foreach (string s in lstProjectName)
        {
            sb.Append(s + ",");
        }
        //sb.Append("]");
        hdnList.Value = sb.ToString();
    }

Autocompliet pass two value and return a value

 <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
 <script type="text/javascript">
      function pageLoad(sender, e) {
          var o = $find("AutoCompleteExtender2");
          o.add_populating(function () {
              o.set_contextKey($get("<%=txtlocationName.ClientID %>").value);
          });
      }
        </script>


 <asp:TextBox ID="txtlocationName" ValidationGroup="vgsearch" runat="server" onkeyup="1"></asp:TextBox>
<asp:TextBox ID="txtpincode" ValidationGroup="vgsearch"  runat="server" onkeyup="1"></asp:TextBox>
           <asp:AutoCompleteExtender runat="server" ID="AutoCompleteExtender2" TargetControlID="txtpincode"
                UseContextKey="true" ContextKey="txtlocationName" ServicePath="AutoComplete.asmx"
                ServiceMethod="RetrivePincodeList" MinimumPrefixLength="1" EnableCaching="true"
                CompletionListCssClass="Extender" CompletionListItemCssClass="ExtenderList" CompletionListHighlightedItemCssClass="Highlight"
                CompletionListElementID="width" />

 [WebMethod]
    public string[] RetrivePincodeList(string prefixText, string contextKey)
    {
        DataSet ds = new DataSet();
        SqlHelper sqlhelp = new SqlHelper();
        ds = GetPincodfilterbylocationlist(prefixText,contextKey);
        List<string> Pincodelist = new List<string>();
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            Pincodelist.Add(ds.Tables[0].Rows[i]["pincode"].ToString());
        }
        return Pincodelist.ToArray();
    }
    protected DataSet GetPincodfilterbylocationlist(string prefixText, string contextKey)
    {
        SqlHelper sqlhelp = new SqlHelper();
        try
        {
            DataSet ctds = new DataSet();
            object[] obj = new object[13];
            obj[0] = "getpincolist";
            obj[3] = contextKey;
            ctds = SqlHelper.ExecuteDataset(sqlhelp.Connection, "sp_Tab_Employeedetails", obj);
            return ctds;
        }
        catch (Exception ex)
        {
            throw (ex);
        }
    }

Drop down multi select and find value

<select name="ddlDomainType" id="ddlDomainType" multiple="True" size="5"  class="dropmenu" runat="server">
     <option>pramod</option>
      <option>suyash</option>
       <option>nitin</option>
            </select>
        <asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />


 protected void Button1_Click(object sender, EventArgs e)
    {
        for (int i = 0; i < ddlDomainType.Items.Count; i++)
        {
            if (ddlDomainType.Items[i].Selected == true)
            {
                pp =pp + ddlDomainType.Items[i].Value+",";
            }
        }
        Response.Write(pp);
    }

javascript function call on repeter control

    <script>
        function jj(i) {
            alert(i);
        }
    </script>

    <asp:Repeater ID="newsListRepeater" runat="server" >
        <ItemTemplate>
            <tr>
              
                <td style="width:110px;">
             
                    <asp:LinkButton ID="LinkButton1" runat="server" OnClientClick='<%# Eval("Dosage", "jj(\"{0}\").ToString()") %>'>LinkButton</asp:LinkButton>
                </td>
            </tr>
        </ItemTemplate>
</asp:Repeater>
  

Google map

aspx pages:-
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="googlemap.aspx.cs" Inherits="AmbitSite_googlemap" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title></title>
    <script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?sensor=false"></script>
     <script language="javascript" type="text/javascript">
         var count = 0;
         var map;
         var geocoder;
         var directionsDisplay;
         var directionsService = new google.maps.DirectionsService();

         var count = 0;
         var map;
         var geocoder;
         function InitializeMap() {
             directionsDisplay = new google.maps.DirectionsRenderer();
             var latlng = new google.maps.LatLng(21.7679, 78.8718); //21.7679, 78.8718
             var myOptions =
        {
            zoom: 16,
            center: latlng,
            mapTypeId: google.maps.MapTypeId.ROADMAP,
            disableDefaultUI: true
        };
             map = new google.maps.Map(document.getElementById("map"), myOptions);

             directionsDisplay.setMap(map);
             directionsDisplay.setPanel(document.getElementById('directionpanel'));


         }


         function markicons(lat, lng,address) {

             InitializeMap();

             var ltlng = [];
             //alert(lat + "\n" + lng);
             ltlng.push(new google.maps.LatLng(lat, lng));


             map.setCenter(ltlng[0]);
             for (var i = 0; i <= ltlng.length; i++) {
                 marker = new google.maps.Marker({
                     map: map,
                     position: ltlng[i]
                 });

                 (function (i, marker) {

                     infowindow = new google.maps.InfoWindow();
                     infowindow.setContent(address);
                     infowindow.open(map, marker);

                     google.maps.event.addListener(marker, 'click', function () {

                         infowindow = new google.maps.InfoWindow();
                         infowindow.setContent(address);
                         infowindow.open(map, marker);

                     });

                 })(i, marker);

             }

         }
         // window.onload = markicons;
    </script>
</head>
<body >
    <form id="form1" runat="server">
   

     <div>
        <div style="float: left;">
        </div>
        <div style="float: left;">
            <table>
                <tr>
                    <td style="width: 627px">
                    </td>
                    <td>
                    </td>
                </tr>
                <tr>
                    <td colspan="2">
                        <div id="map" style="height: 581px">
                        </div>
                    </td>
                </tr>
            </table>
           
        </div>
    </div>
  
    </form>
</body>
</html>
code cs pages:-
using System;
using System.Data;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Net;


public partial class AmbitSite_googlemap : System.Web.UI.Page
{
    static string baseUri = "http://maps.googleapis.com/maps/api/geocode/xml?latlng={0},{1}&sensor=false";
    string location = string.Empty;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string lat, lng, Address;
            lat = "19.000302";//19.000302 19.000302 /   28.601714 77.229145/ 12.983569 77.595707/ 1.282729 103.850573
            lng = "19.000302";
            Address = "";
            if (Request.QueryString["lat"] != null)
            {
                lat =Request.QueryString["lat"].ToString().Trim();
                if (lat == "19.000302")
                {
                    Address = "<b>Ambit Holding</b></br>more info>></br>Ambit House, 449,Senapati Bapat Marg,Lower Parel,</br> Mumbai - 400 013.";
                }
                else if (lat == "28.601714")
                {
                    Address = "<b>Ambit Holding</b></br>more info>></br>Room No.422,Vivanta by Taj – Ambassador,Sujan Singh Park,Subramania Bharti Marg,</br> New Delhi - 110 003.";
                   
                }
                else if (lat == "12.983569")
                {
                    Address = "<b>Ambit Holding</b></br>more info>></br>Empire Infantry </br> Unit No. 3, 29 Infantry Road,1st Floor,</br> Bangalore - 560 001.";
                }
                else if (lat == "1.282729")
                {
                    Address = "<b>Ambit Holding</b></br>more info>></br>#19-03 Equity Plaza ,20 Cecil Street,</br> Singapore - 049 705.";
                }
            }
            if (Request.QueryString["long"] != null)
            {
                lng = Request.QueryString["long"].ToString().Trim();
            }
         
            ClientScript.RegisterStartupScript
         (GetType(), "Javascript", "javascript: markicons('" + lat + "','" + lng + "','" + Address + "'); ", true);
          
        }
    }
   

}

sql join

google search search.aspx pages and master file code

Master file:-
 <script type="text/javascript">
                            var googleSearchIframeName = "cse-search-results";
                            var googleSearchFormName = "cse-search-box";
                            var googleSearchFrameWidth = 600;
                     var googleSearchDomain = "www.google.com";
                            var googleSearchPath = "/cse";

                            function Open_Search_H() {
                                location.href = '/AmbitSite/search.aspx?cx005323480582218126107:q3mg_irwglm&cof=FORID%3A10%3BNB%3A1&ie=UTF-8&q=' + document.getElementById('txt').value + '&as_q=more%3AHTML';
                            }
                        </script>
                        <script type="text/javascript" src="http://www.google.com/afsonline/show_afs_search.js"> </script>
                        <input type="text" id="txt" value="Google Custom Search" onblur="if (this.value == '') {this.value='Google Custom Search'}" class="searh_input" onfocus="this.value=''"
                            />
search.aspx:-

<script>
     (function () {
    var cx = 'dummy code';
    var gcse = document.createElement('script');
    gcse.type = 'text/javascript';
    gcse.async = true;
    gcse.src = (document.location.protocol == 'https:' ? 'https:' : 'http:') +'//www.google.com/cse/cse.js?cx=' + cx;
    var s = document.getElementsByTagName('script')[0];
    s.parentNode.insertBefore(gcse, s);
})();
</script>
<gcse:search></gcse:search>

Excel Report create customise excel with databse

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.IO;
using System.Data.SqlClient;
public partial class AmbitAdmin_AluminiReports : System.Web.UI.Page
{
    #region Private variables

    DataSet _ds = new DataSet();
    string StrDatefrom = "";
    string StrDateto = "";
    #endregion

   
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (!IsPostBack)
            {
                //getting citylist
                if (Session["Mess"] != null)
                    Session.Contents.Remove("Mess");
            }
        }
        catch (Exception ex)
        {
            throw (ex);
        }
    }

    protected void btnSave_Click(object sender, EventArgs e)
    {
        string strErrMsg = "";
        try
        {
            strErrMsg = checkValues();
            if (strErrMsg != "")
            {
                Page.ClientScript.RegisterStartupScript(Page.GetType(), "Alert", "<script language='javascript' type='text/javascript'>alert('" + strErrMsg + "');</script>");
            }
            else
            {
                if (Page.IsValid)
                {
                    cmdDisplayReports();
                }
            }
        }
        catch (Exception ex)
        {
            throw (ex);
        }
    }

    /// <summary>
    /// Publish in excel
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    ///
    protected string Reports(DataTable dt)
    {

        DataTable toExcel = dt.Copy();
        System.Text.StringBuilder sb = new System.Text.StringBuilder();
        sb.Append("<table border='1' bordercolor='black' rules='all' " + "style='BORDER: 1px double; BORDER-COLLAPSE: collapse;' cellpading='2' cellspacing='2'>\r\n");
        sb.Append("<tr height=17 style='height:12.75pt'>\r\n");
            sb.Append("<td align='left' style='height:{1}pt;mso-number-format:\\@;' colspan=" + (toExcel.Columns.Count + 1).ToString() + "></td>\r\n");
        sb.Append("</tr>\r\n");
        sb.Append("<tr height=17 style='height:12.75pt'>\r\n");
            sb.Append("<td align='center' style='height:{1}pt;mso-number-format:\\@;' colspan=" + (toExcel.Columns.Count + 1).ToString() + "><strong>" + toExcel.Rows.Count.ToString() + " Records Found.</strong></td>\r\n");
        sb.Append("</tr>\r\n");
        sb.Append("<tr height=17 style='height:12.75pt'>\r\n");
            sb.Append("<td align='left' style='height:{1}pt;mso-number-format:\\@;' colspan=" + (toExcel.Columns.Count + 1).ToString() + "></td>\r\n");
        sb.Append("</tr>\r\n");
       
        sb.Append("<tr height=17 style='height:12.75pt'>\r\n");
        sb.Append("<td align='left' style='height:{1}pt;mso-number-format:\\@;'><strong>Sr. No</strong></td>\r\n"); //For Serial Number
        foreach (DataColumn column in toExcel.Columns)
        {
            sb.Append("<td align='left' style='height:{1}pt;mso-number-format:\\@;'><strong>" + column.ColumnName + "</strong></td>\r\n");
        }
        sb.Append("</tr>\r\n");
        if (toExcel.Rows.Count == 0)
        {
            sb.Append("<tr height=17 style='height:12.75pt'>\r\n");
            sb.Append("<td align='left' colspan'" + (toExcel.Columns.Count + 1) + "'>\r\n");
            sb.Append("No Records Found</td>\r\n");
            sb.Append("</tr>\r\n");
        }
        else
        {
            Boolean Flag;
            int Counter = 1;
            foreach (DataRow row in toExcel.Rows)
            {
                Flag = true;
                sb.Append("<tr height=17 style='height:12.75pt'>\r\n");
                foreach (DataColumn column in toExcel.Columns)
                {
                    if (Flag)
                    {
                        sb.Append("<td align='left' style='height:{1}pt;mso-number-format:\\@;'>" + Counter.ToString() + "</td>\r\n"); // For Serial Number
                        //sb.Append("<td align='left' style='height:{1}pt;mso-number-format:\\@;'>" + row[column].ToString().Replace(",", string.Empty) + "</td>\r\n");
                        sb.Append("<td align='left' style='height:{1}pt;mso-number-format:\\@;'>" + row[column].ToString() + "</td>\r\n");
                        Flag = false;
                    }
                    else
                    {
                        //sb.Append("<td align='left' style='height:{1}pt;mso-number-format:\\@;'>" + row[column].ToString().Replace(",", string.Empty) + "</td>\r\n");
                        sb.Append("<td align='left' style='height:{1}pt;mso-number-format:\\@;'>" + row[column].ToString() + "</td>\r\n");
                    }
                }
                sb.Append("</tr>\r\n");
                Counter += 1;
            }
        }
        sb.Append("</table>\r\n");
        return sb.ToString();
    }

    protected void cmdDisplayReports()
    {
        string attachment = "attachment; filename=Alumini_Report.xls";
        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.Buffer = true;
        HttpContext.Current.Response.ClearContent();
        HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
        HttpContext.Current.Response.AddHeader("content-disposition", attachment);
        HttpContext.Current.Response.Charset = "";
        try
        {
            getReports();

            //if (_ds.Tables[0].Rows.Count > 0)
            //{
                StringBuilder sb = new StringBuilder();
                sb.Append(Reports(_ds.Tables[0]));
                HttpContext.Current.Response.Write(sb.ToString());
            //}
            HttpContext.Current.Response.End();
        }
        catch (Exception ex)
        {

            throw (ex);
        }
    }

  
  
    #region Private methods
    /// <summary>
    /// Bind dataset with details
    /// </summary>
    private void getReports()
    {
        #region private varibales
           
        #endregion

        // generating records
        try
        {
        StrDatefrom = txtFromDate.Text;
        StrDateto = txtDateTo.Text;
        _ds = getData();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
    }

    /// <summary>
    /// Server Validation
    /// </summary>
    /// <returns></returns>
    private string checkValues()
    {
        #region Private variables
         string strErrMsg="";
        #endregion

        // checking values
        /*
        if (txtDateFrom.Text == "" && txtDateTo.Text == "")
            strErrMsg = "Please select atleast one criteria for search.";
       
         */
        if (txtFromDate.Text == "" && txtDateTo.Text != "")
             strErrMsg = "Please select From Date.";
         if (txtFromDate.Text != "" && txtDateTo.Text == "")
             strErrMsg = "Please select To Date.";
         if (txtFromDate.Text != "" && txtDateTo.Text != "")
        {
            if (Convert.ToDateTime(txtDateTo.Text) < Convert.ToDateTime(txtFromDate.Text))
                strErrMsg = "To Date cannot be less than From Date.";
        }
         return strErrMsg;
    }

    protected DataSet getData()
    {
        #region private variabes
        DataSet _dsData = new DataSet();
        string _strConnString = "";
        #endregion
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["SqlConnString"]);
        SqlCommand cmd = null;
        try
        {
            cmd = new SqlCommand("webroot.Manage_Alumini_Form", conn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@action", SqlDbType.VarChar).Value = "GetReport";
            cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = DBNull.Value;
            cmd.Parameters.Add("@emailaddr", SqlDbType.VarChar).Value = DBNull.Value;
            cmd.Parameters.Add("@mobile", SqlDbType.VarChar).Value = DBNull.Value;
            cmd.Parameters.Add("@currOrg", SqlDbType.VarChar).Value = DBNull.Value;
            cmd.Parameters.Add("@currDesig", SqlDbType.VarChar).Value = DBNull.Value;
            cmd.Parameters.Add("@Date1", SqlDbType.VarChar).Value = txtFromDate.Text;
            cmd.Parameters.Add("@Date2", SqlDbType.VarChar).Value = txtDateTo.Text;

            cmd.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet(cmd.CommandText);
            da.Fill(ds);
            _dsData = ds;
        }
        catch (Exception ex)
        {

            throw (ex);
        }
        return _dsData;
    }


    #endregion
    #region
    private int getObjectLength()
    {
        return 19;
    }
    #endregion



}