Create a user & grant that user to a specific Database

--Step 1: (create a new user)

create LOGIN hello WITH PASSWORD='foo', CHECK_POLICY = OFF;

-- Step 2:(deny view to any database)

USE master;

GO

DENY VIEW ANY DATABASE TO hello;

 -- step 3 (then authorized the user for that specific database , you have to use the  master by doing use master as below)

USE master;

GO

ALTER AUTHORIZATION ON DATABASE::khsk_db TO hello;

GO

Crystal Report View PDF in Browser

using System.IO;

MemoryStream oStream;

oStream = (MemoryStream)rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);

Response.Clear();

Response.Buffer = true;

Response.ContentType = "application/pdf";

Response.AddHeader("content-disposition", "filename=" + FileName + ".pdf");

Response.BinaryWrite(oStream.ToArray());

Response.End();

ASP.NET C# StopWatch

using System.Diagnostics;

Stopwatch sw = Stopwatch.StartNew();

 Your Process Start

Your Process End

string second = sw.ElapsedMilliseconds.ToString();

sw.Stop();

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>