Convert Label to ASP.Net TextBox and update value on Change using C# and VB.Net

Hi lingers,

Refer below code.

HTML

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript">
    $(function () {
        //Loop through all Labels with class 'editable'.
        $(".editable").each(function () {
            //Reference the Label.
            var label = $(this);

            //Add a TextBox next to the Label.
            label.after("<input type='text' style='display:none' />");

            //Reference the TextBox.
            var textbox = $(this).next();

            //Set the name attribute of the TextBox.
            var id = this.id.split('_')[this.id.split('_').length - 1];
            textbox[0].name = id.replace("lbl", "txt");

            //Assign the value of Label to TextBox.
            textbox.val(label.html());

            //When Label is clicked, hide Label and show TextBox.
            label.click(function () {
                $(this).hide();
                $(this).next().show();
            });

            //When focus is lost from TextBox, hide TextBox and show Label.
            textbox.focusout(function () {
                $(this).hide();
                $(this).prev().html($(this).val());
                $(this).prev().show();
                $('[id*=Button1]').trigger('click');
            });
        });
    });
</script>
<div>
    <table border="0" cellpadding="0" cellspacing="0" style="width: 222px">
        <tr>
            <td>Name:&nbsp;</td>
            <td><asp:Label ID="lblName" runat="server" Text="LINGERS" CssClass="editable" /></td>
        </tr>
        <tr>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td></td>
            <td>
                <asp:Button ID="Button1" Text="Submit" runat="server"
                    OnClick="TextBox1_TextChanged" Style='display: none' />
            </td>
        </tr>
    </table>
</div>

Code

C#

protected void TextBox1_TextChanged(object sender, EventArgs e)
{
    string name = Request.Form["txtName"];
    lblName.Text = name;
    SqlConnection dbConn = new SqlConnection();
    SqlCommand cmd = new SqlCommand();

    string updateSQL;
    updateSQL = "update job set machine ='" + name + "' where pid='212' ";

    dbConn.ConnectionString = WebConfigurationManager.ConnectionStrings["DB_SCH"].ConnectionString;
    cmd.Connection = dbConn;
    cmd.CommandText = updateSQL;
    cmd.CommandType = CommandType.Text;
    try
    {
        dbConn.Open();
        int updated = cmd.ExecuteNonQuery();
        if (updated == 1)
        {
            // Response.Redirect("changepassw.aspx");
        }
        else
        {
            // Label101.Text = "Process not Completed";
        }

        dbConn.Close();
    }
    catch (Exception err)
    {
        Response.Write(err.ToString());
    }
    finally
    {
        dbConn.Close();
    }
}

VB.Net

Protected Sub TextBox1_TextChanged(ByVal sender As Object, ByVal e As EventArgs)
    Dim name As String = Request.Form("txtName")
    lblName.Text = name
    Dim dbConn As SqlConnection = New SqlConnection()
    Dim cmd As SqlCommand = New SqlCommand()
    Dim updateSQL As String
    updateSQL = "update job set machine ='" & name & "' where pid='212' "
    dbConn.ConnectionString = WebConfigurationManager.ConnectionStrings("DB_SCH").ConnectionString
    cmd.Connection = dbConn
    cmd.CommandText = updateSQL
    cmd.CommandType = CommandType.Text

    Try
        dbConn.Open()
        Dim updated As Integer = cmd.ExecuteNonQuery()
        If updated = 1 Then
        Else
        End If

        dbConn.Close()
    Catch err As Exception
        Response.Write(err.ToString())
    Finally
        dbConn.Close()
    End Try
End Sub