AutoComplete Extender with Web Service

Use below link, and DOWNLOADS: Code (C#)

http://www.asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-autocomplete-control

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Step 1: Make a Web service:named as AutoComplete.asmx

public string[] GetCompletionList(string prefixText, int count)
    {
      
        SqlConnection con = new SqlConnection("Connection String from web config");
        SqlDataAdapter dad = new SqlDataAdapter("SELECT column1 from table where column2 like '" + prefixText + "%'", con);

     
        DataSet ds = new DataSet();
        dad.Fill(ds);
        List<string> list = new List<string>(ds.Tables[0].Rows.Count);
        //string[] list = new string[ds.Tables[0].Rows.Count];

        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            list.Add(dr[0].ToString());
            //list.SetValue(dr[0].ToString(), i);

        }
        return list.ToArray();
    }

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Step2: Add reference to your default page:

<asp:ScriptManager ID="ScriptManager1" runat="server">
        <Services>
        <asp:ServiceReference Path="AutoComplete.asmx" />
        </Services>
        </asp:ScriptManager>

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Step 3: Add Ajax tol kit ( AjaxControlToolkit.dll ) to bin folder and register it
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Step 4: Add AutoCompleteExtender

<div>           
            <asp:TextBox runat="server" ID="myTextBox" Width="300" autocomplete="off" />
            <ajaxToolkit:AutoCompleteExtender
                runat="server"
                ID="autoComplete1"
                TargetControlID="myTextBox"
                ServicePath="AutoComplete.asmx"
                ServiceMethod="GetCompletionList"
                MinimumPrefixLength="2"
                CompletionInterval="1000"
                EnableCaching="true"
                CompletionSetCount="12" />
    </div>
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Rediect to another aspx page after few seconds

Code file code:

Response.AddHeader("REFRESH", "5;URL=yourpage.aspx");

SQL SERVER – How to Rename a Column Name or Table Name

The script for renaming any column :
sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

The script for renaming any object (table, sp etc) :
sp_RENAME '[OldTableName]' , '[NewTableName]'

Jquery Pop up

<style type="text/css">
/* popup_box DIV-Styles*/
#popup_box {
    display:none; /* Hide the DIV */
    position:fixed; 
    _position:absolute; /* hack for internet explorer 6 */ 
    height:150px; 
    width:500px; 
    background:#FFFFFF; 
    left: 400px;
    top: 150px;
    z-index:100; /* Layering ( on-top of others), if you have lots of layers: I just maximized, you can change it yourself */
    margin-left: 15px; 
   
    /* additional features, can be omitted */
    border:2px solid #ff0000;     
    padding:15px; 
    font-size:15px; 
    -moz-box-shadow: 0 0 5px #ff0000;
    -webkit-box-shadow: 0 0 5px #ff0000;
    box-shadow: 0 0 5px #ff0000;
   
}

#container {
    background: #d2d2d2; /*Sample*/
    width:100%;
    height:100%;
}

a{ 
cursor: pointer; 
text-decoration:none; 
}

/* This is for the positioning of the Close Link */
#popupBoxClose {
    font-size:20px; 
    line-height:15px; 
    right:5px; 
    top:5px; 
    position:absolute; 
    color:#6fa5e2; 
    font-weight:500;     
}
</style>



<script src="http://jqueryjs.googlecode.com/files/jquery-1.2.6.min.js" type="text/javascript"></script>

<script type="text/javascript">

    $(document).ready(function() {

        // When site loaded, load the Popupbox First
        $('#a_CancelPayment').click(function() {
            loadPopupBox();
        });

        $('#popupBoxClose').click(function() {
            unloadPopupBox();
        });



        function unloadPopupBox() {    // TO Unload the Popupbox
            $('#popup_box').fadeOut("slow");
            $("#wrapper").css({ // this is just for style       
                "opacity": "1"
            });
        }

        function loadPopupBox() {    // To Load the Popupbox
            $('#popup_box').fadeIn("slow");
            $("#wrapper").css({ // this is just for style
                "opacity": "0.3"
            });
        }
        /**********************************************************/

    });
</script>


Put the below code in form tag in your body....
  <div id="popup_box">    <!-- OUR PopupBox DIV-->
    <table style="width :100%;">
 
    <tr ><td style="width :15%;"></td>
    <td align="center" style="width :70%;">
    <table>
    <tr style="height:100px;">
    <td align="center">Do you really want to cancel your recurring payments?</td>
    </tr>
    <tr><td align="center"><asp:Button ID="btn_ConfirmCancelPayment" runat="server" Text ="Confirm" OnClick ="btn_ConfirmCancelPayment_Click" />
    <asp:Button ID="btn_CancelPayment" runat="server" Text ="Cancel" OnClick ="btn_CancelPayment_Click"/></td></tr>
    <tr></tr>
    </table>
   
   
    </td><td style="width :15%;"></td>
    </tr>
    </table>
   
    <a id="popupBoxClose">Close</a>   
</div>