Changing the SiteMaster StyleSheet from Codebehind

- In the SiteMaster Page, add ID to StyleSheet tag:
     <link id="layoutStyleSheet" href="~/Styles/Site.css" rel="stylesheet" type="text/css" />
- In a login page, set a SESSION to a value. e.g. SESSION["user"] = "test"
- In the SiteMaster Page_Load method:
     protected void Page_Load(object sender, EventArgs e)
     {
         if (Session["user"] != null)
         {
             if (Session["user"].ToString() == "test")
             {
                 HtmlLink link = Page.Master.FindControl("layoutStyleSheet") as HtmlLink;
                 link.Href = "~/Styles/Aqualinc.css";
             }
             .
             .
             .       
         }
     }

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
    }
});

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" />

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

.NET WinForms Application Crashes When Run Outside Visual Studio

If you run the application directly of EXE file, try to set "LOCAL COPY = TRUE" for each assembly in the References node and rebuild the project. Execute and try it if run it without problems.

Import CSV Data File Into MySQL Table

LOAD DATA INFILE "D:/test.csv"
INTO TABLE desire_table_name
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r';