aspx Textbox Search from sql server database (like google search):

aspx Textbox Search from sql server (like google search):
----------------------------------------------------------------------------------------------------

  <link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css">
        <script src="http://code.jquery.com/jquery-1.9.1.js"></script>
        <script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>

aspx page code:
 -------------------------------
           <script language="javascript" type="text/javascript">
            $(function () {
                $('#<%=txtcustname.ClientID%>').autocomplete({
                    source: function (request, response) {
                        $.ajax({
                            url: "enquiry.aspx/GetCompanyName",
                            data: "{ 'customer':'" + request.term + "'}",
                            dataType: "json",
                            type: "POST",
                            contentType: "application/json; charset=utf-8",
                            success: function (data) {
                                response($.map(data.d, function (item) {
                                    return { value: item }
                                }))
                            },
                            error: function (XMLHttpRequest, textStatus, errorThrown) {
                                alert(textStatus);
                            }
                        });
                    }
                });
            });
</script>

<asp:TextBox ID="txtcustname" runat="server"  CssClass="textboxAuto" ></asp:TextBox>

C# CodeBehibd
-------------------------

 [WebMethod]
        [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
        public static List<string> GetCompanyName(string customer)
        {
            mainclass objmc = new mainclass();
            List<string> result = new List<string>();
            using (SqlCommand cmd = new SqlCommand("select name from customer where name LIKE @SearchText+'%'", objmc.con))
            {
                objmc.con.Open();
                cmd.Parameters.AddWithValue("@SearchText", customer);
                SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    result.Add(dr["name"].ToString());
                }
                return result;
            }
        }

DEMO:

Add DataTable/TextBox data to Dataset in C#

//Page load
  DataSet ds = new DataSet();
                DataTable dt = new DataTable();
                DataColumn dc0 = new DataColumn("ItemNumber");
                DataColumn dc1 = new DataColumn("Quantity");
                DataColumn dc2 = new DataColumn("DeliveryDate");

                dt.Columns.Add(dc0);
                dt.Columns.Add(dc1);
                dt.Columns.Add(dc2);
                ds.Tables.Add(dt);
                Session["scheduledata"] = ds;

//Button Click

DateTime DateDelvry = Convert.ToDateTime(Request.Form["dpDelDateSdul"]);

                DataSet ds = (DataSet)Session["scheduledata"];
                DataRow dr = ds.Tables[0].NewRow();
                dr[0] = ViewState["Item"];
                dr[1] = txtQuantitySchedule.Text.Trim();
                dr[2] = DateDelvry.ToShortDateString();
                ds.Tables[0].Rows.Add(dr);
                GridView1.DataSource = ds;
                GridView1.DataBind();

JavaScript - Calculate two textbox values on TextChange Event ClientSide

js function:

<script type="text/javascript">
    function findaverageL() {
        var l1 = document.getElementById('<%= txtqnty.ClientID %>');
        var l2 = document.getElementById('<%= txtNCRqty.ClientID %>');
        var avgl = document.getElementById('<%= txtOKqnty.ClientID %>');
        avgl.value = parseFloat(l1.value) - parseFloat(l2.value);

    }  
   
// this function is for validate Number Only. It not allow to entr characters in textbox
        function isNumberKey(evt) {
            var charCode = (evt.which) ? evt.which : event.keyCode
            if (charCode != 46 && charCode > 31
              && (charCode < 48 || charCode > 57))
                return false;
            return true;
        }
   
</script>

<asp:TextBox ID="txtqnty" runat="server" Text="0" onkeypress="return isNumberKey(event)"       onpaste="return false" ondrop="return false" onchange='javascript:findaverageL();'></asp:TextBox>