Wednesday, 25 September 2013

Trace HTML textbox changes on the fly using JQuery

$(document).ready(function () {
    var searchValue = "";
    setInterval(checkTextboxChanged, 0.5);

    function checkTextboxChanged() {
        var currentValue = $('#TextBoxId').val();
        if (currentValue != searchValue) {
            searchValue = currentValue;
            TextboxChanged();
        }
    }

    function TextboxChanged() {
        // do your magic here
    }
});
 

Tuesday, 17 September 2013

Telerik RadGrid: Access the new values in Update Command

GridEditableItem editItem = e.Item as GridEditableItem;
Hashtable newValues = new Hashtable(); e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editItem);
string inf = newValues["username"].ToString();
.
.
.

After getting all the updated values, they can be passed to SQL update command.

Access input textbox value from the ASP.Net code behind

If you add attribute "runat" & "id" to your input then you can access it in your code behind without using Ajax:

<input type="text" id="myInput" runat="server" />

Tuesday, 10 September 2013

C# Partial-Page Update Sample Ajax Application

  • In the AJAX Extensions tab of the toolbox, double-click the ScriptManager control to add it to the page.
  • Drag an UpdatePanel control from the toolbox and drop it underneath the ScriptManager control.
  • Add those controls that you need to be partially updated.
More

SQL: Generate a range of numbers

SELECT ones.n + 10*tens.n + 100*hundreds.n + 1000*thousands.n FROM       (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) ones(n),      (VALU...