Restart IIS from asp net page

ASP.NET

ServiceController represents a Windows service and allows you to connect to a running or stopped service, manipulate it, or get information about it.
The Internet Information Services (IIS) World Wide Web Publishing Service (W3SVC) manages the HTTP protocol and HTTP performance counters.

Example :
Restart IIS from asp net page

using System;

using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.ServiceProcess;
using System.Threading;

namespace WebApplication1

{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            ServiceController sc = new ServiceController("W3SVC");
            if (null != sc)
            {
                if (sc.Status == ServiceControllerStatus.Running)
                {
                    sc.Stop();
                    Thread.Sleep(2000);
                    sc.Start();
                    Response.Write("IIS restarted");
                }
                else
                {
                    Response.Write("IIS started");
                    sc.Start();
                }
            }
        }
    }
}

 

ISNUMERIC SQL Server

SQL Server > Built-In Functions > ISNUMERIC

ISNUMERIC returns 1 when the input expression evaluates to a valid numeric data type; otherwise it returns 0

Example:

IF OBJECT_ID(N'tbl1', N'U') IS NOT NULL

       DROP TABLE tbl1;
GO

CREATE TABLE tbl1

(
       id     int ,
       code   varchar(50)
);
GO

INSERT INTO tbl1 values  (1,'aaa'), (2,'b12') , (3,'345')

SELECT
       *
FROM
       tbl1
WHERE
       ISNUMERIC(code) = 1

Result:

 

id code
3  345

 

 

C# Nullable DateTime

C# > System Namespace > DateTime > Nullable DateTime

// Error Cannot convert null to 'System.DateTime' because it is a non-nullable value type 
   

DateTime AgendaValidFrom;

AgendaValidFrom = null;

Solution:
Add ? to DateTime

DateTime? AgendaValidFrom = null; // Declare a nullable DateTime instance and assign to null.

Delete from table using join SQL Server

SQL Server > DML > DELETE

Removes rows from a table.

Example

To delete from tables using join you must specify an alias for the table from which to delete data.

IF OBJECT_ID(N'tbl1', N'U') IS NOT NULL

       DROP TABLE tbl1;
GO
IF OBJECT_ID(N'tbl2', N'U') IS NOT NULL
       DROP TABLE tbl2;
GO

CREATE TABLE tbl1

(
       id           int ,
       name   varchar(50)
);
GO
CREATE TABLE tbl2
(
       id           int ,
       name   varchar(50)
);
GO

INSERT INTO tbl1 values  (1,'john'), (2,'dan') , (3,'laura')

INSERT INTO tbl2 values  (1,'john')
GO

select * from tbl1

--id name
--1 john
--2 dan
--3 laura

DELETE
  a
from
  tbl1 a
join tbl2 b on a.id = b.id

select * from tbl1

--id name
--2 dan
--3 laura

GO

COUNT_BIG SQL Server

SQL Server > Built-in Functions > COUNT_BIG

COUNT_BIG is the same like COUNT but returns bigint data type value.

Date Functions C#

C# > System Namespace > DateTime > Add Methods

Returns a new DateTime that adds the specified number of  years, days, minutes, months, seconds to the value of this instance.

Example:

DateTime AgendaValidTill = DateTime.Now.AddYears(10);
// add days

AgendaValidTill = DateTime.Now.AddDays(10);
AgendaValidTill = DateTime.Now.AddMinutes(10);
AgendaValidTill = DateTime.Now.AddMonths(10);
AgendaValidTill = DateTime.Now.AddSeconds(10);

Date functions SQL Server

SQL Server > Date&Time > Date Functions



-- Selecting the Current Year/Get Current Year/Separate Year Part from Date
Select DatePart(YY, GetDate()) as Current_Year
-- Selecting the Current Quarter/Get Current Quarter/Separate Quarter Part from Date
Select DatePart(QQ, GetDate()) as Current_Quarter
-- Selecting the Current Month/Get Current Month/Separate Month Part from Date
Select DatePart(MM, GetDate()) as Current_Month
-- Selecting the Current Hour/Get Current Hour/Separate Hour Part from Date
Select DatePart(HH, GetDate()) as Current_Hour
-- Selecting the Current Minute/Get Current Minute/Separate Minute Part from Date
Select DatePart(minute, GetDate()) as Current_Minute

-- Selecting the Name of Current Month/Get Name of Current Month/Separate Month Part from Date and display its Name
Select DateName(month, GetDate()) as Current_Month_Name
-- Selecting the Name of Current Month/Get Name of Current Month/Separate Month Part from Date and display its Name
Select DateName(day, GetDate()) as Current_Day
-- Selecting the Name of Current Month/Get Name of Current Month/Separate Month Part from Date and display its Name
Select DateName(wk, GetDate()) as Current_Week