Get SQL Server Use Which Port Using a Query

SELECT DISTINCT

local_tcp_port

FROM sys.dm_exec_connections

WHERE local_tcp_port IS NOT NULL

This is for specific database

SELECT DISTINCT

    local_tcp_port

FROM sys.dm_exec_connections

WHERE local_tcp_port IS NOT NULL

USE master

GO

xp_readerrorlog 0, 1, N'Server is listening on'

GO

Bangladesh Mobile Number Validation Using JavaScript

C# Control
=========

<asp:TextBox ID="txtSMSNotification" class="input-semi-large" runat="server" onchange="ValidateMobNumber();"></asp:TextBox>

JavaScript Control
==============

<script type="text/javascript">

        function ValidateMobNumber() {

            var fld = document.getElementById("ContentPlaceHolder_txtSMSNotification");

            if (fld.value == "") {

                alert("You didn't enter a sms notification number.");

                fld.value = "";

                fld.focus();

                return false;

            }

            var mySplitResult = fld.value.substring(0, 2);

            if (mySplitResult != "01") {

                alert("Not in correct format");

                fld.value = "";

                fld.focus();

                return false;

            }

            if (isNaN(fld.value)) {

                alert("SMS notification number contains illegal characters.");

                fld.value = "";

                fld.focus();

                return false;

            }

            if (!(fld.value.length == 11)) {

                alert("SMS notification number is the wrong length. \nPlease enter 11 digit mobile no.");

                fld.value = "";

                fld.focus();

                return false;

            }

        }

           

    </script>

How to Title Case a Column Value Using SQL Query

Create a scalar-valued functions in database,

CREATE FUNCTION dbo.fn_title_case

(

  @str AS varchar(100)

)

RETURNS varchar(100)

AS

BEGIN

  DECLARE

    @ret_str AS varchar(100),

    @pos AS int,

    @len AS int

  SELECT

    @ret_str = ' ' + LOWER(@str),

    @pos = 1,

    @len = LEN(@str) + 1

  WHILE @pos > 0 AND @pos < @len

  BEGIN

    SET @ret_str = STUFF(@ret_str,

                         @pos + 1,

                         1,

                         UPPER(SUBSTRING(@ret_str,@pos + 1, 1)))

    SET @pos = CHARINDEX(' ', @ret_str, @pos + 1)

  END

  RETURN RIGHT(@ret_str, @len - 1)

END

======

Execute this update sql query

UPDATE dbo.Client

  SET ClientName = dbo. fn_title_case(ClientName)

Allow only number in C# TextBox using JavaScript

C# Control:

<asp:TextBox CssClass="form-control" ID="txtContactNumber" runat="server" onkeypress="return isNumber(event)"></asp:TextBox>

JavaScript:

function isNumber(evt) {
            evt = (evt) ? evt : window.event;
            var charCode = (evt.which) ? evt.which : evt.keyCode;
            if (charCode > 31 && (charCode < 48 || charCode > 57)) {
                return false;
            }
            return true;
        }

Display Image in asp.net C# web form after click file upload using Javascript

Javascript:

<script type="text/javascript">

    function previewFile() {

        var preview = document.querySelector('#<%=Avatar.ClientID %>');

        var file = document.querySelector('#<%=avatarUpload.ClientID %>').files[0];

        var reader = new FileReader();

        reader.onloadend = function () {

            preview.src = reader.result;

        }

        if (file) {

            reader.readAsDataURL(file);

        } else {

            preview.src = "";

        }

    }

    </script>

 .aspx page code:

    <p>

        <asp:Image ID="Avatar" runat="server" Height="225px" ImageUrl="~/Images/NoUser.jpg" Width="225px" />

    </p>

    <p>

        <input ID="avatarUpload" type="file" name="file" onchange="previewFile()"  runat="server" />

        <asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="Upload"/>   

    </p>

Open a .aspx page on a new tab in asp.net button click event using javascript

Code For .aspx page:

<asp:Button ID="btnAbout" runat="server" Text="About" onclick="btnAbout_Click" OnClientClick="return PostToNewWindow();"/>

Java Script Function:

<script type="text/javascript">

    function PostToNewWindow() {

        originalTarget = document.forms[0].target;

        document.forms[0].target = '_blank';

        window.setTimeout("document.forms[0].target=originalTarget;", 300);

        return true;

    }

</script>

Code in .cs Page For Button Click:

protected void btnAbout_Click(object sender, EventArgs e)

{

Response.Redirect("~/About.aspx");

}

That's It.