Skip to main content


Regular expression builder online tool

Recent posts

DnnDatePicker Error while adding in to your custom controller in DNN 9 [Solved]

Dear All
I tried to add the DNN datepicker by adding following way, I search on google but did not find any appropriate solution.

Every where i found the below solution which is no more workable with DNN 9.
<%@ Register Assembly="DotNetNuke.Web" Namespace="DotNetNuke.Web.UI.WebControls" TagPrefix="dnn" %>
<dnn:DnnDatePicker runat="server" ID="StartDatePicker" /></div>

In last i found a solution myself by digging down into the designer classes and I found that the above references are  obsolete in DNN 9 and there is no  DotNetNuke.Web reference in DNN9 If you want to add the date controller in dnn 9 then following class you need to change  <%@ Register TagPrefix="dnn" Assembly="DotNetNuke" Namespace="DotNetNuke.UI.WebControls" %>
<dnn:DateTimeEditControl ID="dnnDatePicker1" runat="server"  />

I hope it save your time 
Regards  Rashid Imran Bilgrami

Tasklist command Power Shell PS commands How to kill process on remote computer?

Open the windows power shell command In Windows, we can kill processes running on a remote computer using the taskkill command. We can specify process id/image file name/user name to identify the processes that need to be killed. Below you can find the syntax for each of the cases with examples. Kill remote process using process id. The syntax for this case is as below Taskkill /S remoteServer /u userName /PID processId Example: c:\>taskkill /S /u administrator /PID 5088 Type the password for administrator:****** SUCCESS: The process with PID 5088 has been terminated. We can as well specify FQDN name of the computer for /S option. We can add /P switch to the above command, to specify the password in the command itself. This will allow the command to be executed from a batch file, without any user interaction. Kill remote process using image name We can use filter option (/FI) to specify the image name. The syntax is as given below. taskkill /s remoteServer  /u userName …

Read All Tables from SQL with respect of table rows or table size

Dear All,
If you need to read how many tables of SQL in your database has major record this script will help you.

    t.NAME AS TableName,
    s.Name AS SchemaName,
    p.rows AS RowCounts,
    ist.TABLE_CATALOG as tableCatalog,
    SUM(a.total_pages) * 8 AS TotalSpaceKB,
    SUM(a.used_pages) * 8 AS UsedSpaceKB,
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
    sys.tables t

    sys.indexes i ON t.OBJECT_ID = i.object_id
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
    sys.allocation_units a ON p.partition_id = a.container_id

    sys.schemas s ON t.schema_id = s.schema_id
    t.NAME NOT LIKE 'dt%'
    AND t.is_ms_shipped = 0
    AND i.OBJECT_ID > 255
    t.Name, s.Name, p.Rows, ist.TABLE_CATALOG
    p.rows desc

I hope it will work for your

Rashid imran Bilg…

SQL SERVER – Cannot resolve collation conflict for equal to operation

Dear All,

In MS SQL SERVER, the collation can be set at the column level. When compared 2 different collation column in the query, this error comes up.

FROM ItemsTable
INNER JOIN AccountsTable
WHERE ItemsTable.Collation1Col = AccountsTable.Collation2Col

If columns ItemsTable.Collation1Col and AccountsTable.Collation2Col have different collation, it will generate the error “Cannot resolve collation conflict for equal to operation“.

To resolve the collation conflict add following keywords around “=” operator.

FROM ItemsTable
INNER JOIN AccountsTable
= AccountsTable.Collation2Col COLLATE DATABASE_DEFAULT

I hope the above solution will help you and save your time 
Regards  Rashid Imran Bilgrami

RegisterStartupScript updated way to right Java script JS (Javascript) in code behind also work with update panel

Dear All
RegisterStartupScript is obsolete now the new way that works with update panel  is given below its is code behind file code also

VB Code Dim csname1 As String = "PopupScript"
Dim cstype As Type = Me.GetType()
Dim cs As ClientScriptManager = Page.ClientScript
Dim cstext1 As String = "alert('Your message');"
cs.RegisterStartupScript(cstype, csname1, cstext1, True)

C# Code
String csname1 = "PopupScript";
Type cstype = this.GetType();
ClientScriptManager cs = Page.ClientScript;
String cstext1 = "alert('Hello World');"; cs.RegisterStartupScript(cstype, csname1, cstext1, true);
I hope it will help you also 
Regards  Rashid Imran Bilgrami

How to Create Window Service and execute it

Dear All
If you are looking for develop you own window service than below is the simplest method to create it

The original reference for this post is following

Here we go... This article explains a step-by-step process of developing and installing a Windows Service to do a scheduled job based on a time interval.

Open Visual Studio and from the menus select "File" -> "New" -> "Project...".

A New Project window will open. Choose "Visual C#" >> "Windows" project type and select "Windows Service" from the right hand side and name the project "TestWindowsService" as shown in the following screenshot.

After you click "OK", the project will be created and you will see the design view of the service as shown in the following screen. Right-click the "Service1.cs" file in Solution Explorer and…