Best Visualization Technical Blogs For DNN, PHP, ASP, .net

Take Back up for all SSRS Report

2025-04-30T23:05:00.000-07:00

Dear All,

If you want to take a backup of the complete SSRS report server, please follow the below setups

Run PowerShell with Full Administrator Rights

#------------------------------------------------------
#Prerequisites
Install-Module -Name ReportingServicesTools
#------------------------------------------------------

#Lets get security on all folders in a single instance
#------------------------------------------------------
#Declare SSRS URI
$sourceRsUri = 'http://ReportServerURL/ReportServer/ReportService2010.asmx?wsdl'
# in my case http://sjerpsrvr2/ReportServer/ReportService2010.asmx?wsdl

#Declare Proxy so we dont need to connect with every command
$proxy = New-RsWebServiceProxy -ReportServerUri $sourceRsUri

#Output ALL Catalog items to file system
Out-RsFolderContent -Proxy $proxy -RsFolder / -Destination 'C:\SSRS_Out' -Recurse

I hope it will work

Regards

Rashid Imran Bilgrami
3ART Technologies 
https://www.3art.tech

AI Logo Design Website

2023-04-11T20:37:00.002-07:00

https://turbologo.com/

Top 15 AI Software Tools For Developers by ChatGPT

2023-04-11T19:04:00.003-07:00

Dear All,

I found the following tools recommended by Chat GPT for the AI Program Development

TensorFlow: an open-source platform for developing and training machine learning models.

Keras: a high-level neural networks API, written in Python and capable of running on top of TensorFlow, CNTK, or Theano.

PyTorch: an open-source machine learning framework that accelerates the path from research prototyping to production deployment.

Scikit-learn: a free software machine learning library for the Python programming language.

Apache Mahout: a free, distributed linear algebra framework and mathematically expressive Scala DSL.

H2O.ai: an open-source platform that makes it easy to build, deploy, and operate machine learning models in production.

RapidMiner: a data science platform that provides an integrated environment for building machine learning models.

DataRobot: an automated machine learning platform that enables organizations to build and deploy highly accurate machine learning models.

BigDL: a distributed deep learning library for Apache Spark that enables efficient training of very large models.

MLflow: an open-source platform for managing the end-to-end machine learning lifecycle.

Weka: a collection of machine learning algorithms for data mining tasks.

Orange: an open-source data visualization and analysis tool for machine learning.

KNIME: a free, open-source platform for data science that enables easy integration of various tools and workflows.

Google Cloud AutoML: a suite of machine learning products that enables organizations to build and deploy custom models with minimal coding.

IBM Watson Studio: a cloud-based integrated development environment (IDE) for building and deploying machine learning models.

How to run Python On IIS

2023-04-08T07:11:00.003-07:00

Dear All,

If you want to run Python On IIS it's very simple and easy

1) Download Python from the Download Python | Python.org

2) Open The IIS and setup your new web application

3) Make sure your project directly don't have any Spaces

4) Setup the handler mapping

Thats it and your pyton script will run on browser

C# – FileUpload not working in Multiview and updatepanel

2022-09-11T02:36:00.005-07:00

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<asp:UpdatePanel runat="server">

<asp:PostBackTrigger ControlID="Button1" />

</Triggers>

<asp:MultiView ID="MultiView1" runat="server"

ActiveViewIndex="0">

<asp:View ID="View1" runat="server">

<asp:Button Text="next"

runat="server" onclick="Unnamed1_Click" />

</asp:View>

<asp:View ID="View2" runat="server">

<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button"

style="width: 56px" />

<asp:FileUpload ID="fileupload2" runat="server" />

</asp:View>

</asp:MultiView>

</ContentTemplate>

</asp:UpdatePanel>

and the code behind is

protected void Button1_Click(object sender, EventArgs e)

{

if (fileupload2.HasFile)

{

//code..

}

protected void Unnamed1_Click(object sender, EventArgs e)

{

MultiView1.ActiveViewIndex = 1;

}

When i click Button1 for uploading the image on first time the fileupload2.HasFile returns "false"

without refrshing the page again try to upload the same picture then fileupload2.HasFile returns "true"

Best solution for it

Try registering the button control with RegisterPostBackControl early in the page lifecycle:

protected void Page_Init(object sender, EventArgs e)

{

ScriptManager1.RegisterPostBackControl(Button1);

}

Upload Image by using File Control with JS or Update Panel or C# DNN Partial Post back

2022-07-05T05:12:00.001-07:00

In this article i will show how you can upload image with partial post back and as well as using views

We need to create multi view and views and under view we have a form where the file upload control is present we need to place this script under this view otherwise partical post back in DNN stuck because controller will not found

/* I use this code to get the image in base 64 and add in to the textbox to get the value in particle post back in next tab */

// Display image is preview function

function displayImage() {

document.querySelector("#demoImage").src = document.querySelector("#<%=txt_imgValue.ClientID%>").value;

}

// Get the file upload control image read it in to base 64 value the plus point for it either you can store the whole image in db as a text or save it as file after rendering it.

function ReceiveImageInto_Base64() {

const image_input = document.querySelector("#<%=fp_productImage.ClientID%>");

image_input.addEventListener("change", function () {

const reader = new FileReader();

reader.addEventListener("load", () => {

const uploaded_image = reader.result;

document.querySelector("#<%=txt_imgValue.ClientID%>").value = `${uploaded_image}`;

displayImage();

});

reader.readAsDataURL(this.files[0]);

});

}

fp_productImage.ClientID is the file upload control at ASCX page

txt_imgValue.ClientID is a text field that keep the value of the image

$(document).ready(function () {

ReceiveImageInto_Base64();

displayImage();

});

//Re-bind for callbacks (This is a key to work on Partical postback )

var prm = Sys.WebForms.PageRequestManager.getInstance();

prm.add_endRequest(function () {

$(document).ready(function () {

ReceiveImageInto_Base64();

displayImage();

});

</script>

Good MVC Tutorial

2019-03-23T15:00:00.002-07:00

Hi
Following is a good MVC tutorial
https://www.tutorialsteacher.com/mvc/routing-in-mvc

Read PBX data

2018-12-29T03:08:00.000-08:00

These are some research work nothing is implemented yet

Try first this
https://community.spiceworks.com/scripts/show/2615-smdr-cdr-pbx-call-detail-archiver

Alos Try this
https://www.experts-exchange.com/questions/22982027/I-am-trying-to-create-desktop-application-using-C-to-Read-Call-information-for-Panasonic-PBX-are-ther-any-sample-code.html

Microsoft Tapi Check this out
https://social.msdn.microsoft.com/Forums/vstudio/en-US/235b93f8-6b61-4fd6-9b98-8021eb9b9049/tapi-and-panasonic-kxtda200?forum=csharpgeneral

http://forums.codeguru.com/showthread.php?520685-How-can-I-receive-data-from-a-PBX-machine-after-I-get-gonnected-to-it

Call SDK for panasonic
https://panasonic.net/cns/office/products/pbx/products/application/sdk/

Regular expression builder online tool

2018-01-01T20:13:00.000-08:00

Dear All,
Following is an online tool for regular expression building

https://regex101.com/r/d1Kdw5/1/

You can get some of the prepaid regular expressions and also try your own

I hope this small tool will help you and save more time in development

Regards
Rashid Imran Bilgrami

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

2017-12-30T02:10:00.002-08:00

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?

2017-09-27T23:16:00.002-07:00

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 10.132.79.23 /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 /FI "IMAGENAME eq filename"

For example, if I need to kill all command window processes, I would run the below command.

taskkill /s 10.132.79.23 /u administrator /FI "IMAGENAME eq CMD.EXE"

If you need to kill outlook process, the command would be:

taskkill /s 10.132.79.23 /u administrator /FI "IMAGENAME eq OUTLOOK.EXE"

Kill processes executed by a particular user

The command is similar to the previous case with one change. Instead of ‘imagename‘, now we use ‘username‘ in the filter argument.

taskkill /s remoteServer  /u userName /FI "USERNAME eq userLoginId"

Viewing the list of processes on remote computer

We can get the remote processes list using tasklist command.
To get list of all the processes, the command is :

tasklist /s remoteServer /u userName

To list the processes running a particular image file:

TASKlist /S remoteServer /u userName /FI "IMAGENAME eq filename"

Example: To get the list of processes running cmd.exe on the remote computer 10.132.79.23, the command is:

c:\>Tasklist /S 10.132.79.23 /u administrator /FI "IMAGENAME eq CMD.EXE"
Type the password for administrator:******

Image Name                     PID Session Name        Session#    Mem Usage
========================= ======== ================ =========== ============
cmd.exe                       4272                            3      2,336 K
cmd.exe                       4448                            3      2,276 K
cmd.exe                       5008                            1      2,392 K
cmd.exe                       4228                            0      2,032 K
cmd.exe                       2344                            0      2,024 K
cmd.exe                       5552                            0      2,028 K
cmd.exe                       2936                            0      2,024 K
cmd.exe                       3776                            1      6,248 K

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

2017-04-01T23:18:00.000-07:00

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

SELECT
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
FROM
sys.tables t

INNER JOIN
sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
sys.allocation_units a ON p.partition_id = a.container_id
INNER JOIN
INFORMATION_SCHEMA.TABLES ist on ist.TABLE_NAME = t.name

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

I hope it will work for your

Regards
Rashid imran Bilgrami

SQL SERVER – Cannot resolve collation conflict for equal to operation

2016-11-02T00:16:00.001-07:00

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.

SELECT ID
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.

SELECT ID
FROM ItemsTable
INNER JOIN AccountsTable
WHERE ItemsTable.Collation1Col COLLATE DATABASE_DEFAULT
= 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

2016-07-10T22:26:00.001-07:00

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

2016-05-23T01:26:00.001-07:00

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
http://www.c-sharpcorner.com/UploadFile/naresh.avari/develop-and-install-a-windows-service-in-C-Sharp/

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 rename it "to" Scheduler or any other name that you want to give it. Then click “click here to switch to code view”.

In the code view, you can see two methods called OnStart() and OnStop(). The OnStart() triggers when the Windows Service starts and the OnStop() triggers when the service stops.

Right-click the TestWindowService project, add a new class and name it "Library.cs". This class will be useful to create the methods that we require in the project. If your TestWindowService is a big project, you can create a ClassLibrary project and reference it to your TestWindowService.

Library.cs

Make the class public and declare it as a Static class.

Create a log method (WriteErrorLog) to log the exceptions.

Create one more log method (WriteErrorLog) to log the custom messages.

Scheduler.cs

Now return to our Scheduler.cs file and declare a Timer.

Write the following code in the OnStart() method and timer1_Tick():

Write the following code in the OnStop() method:

Scheduler.cs [Design]

Now return to the Scheduler.cs [Design] and right-click on the editor window then click "Add Installer".

Then you can see that there will be a new file called "ProjectInstaller.cs" as shown in the following.

Right-click on the "serviceInstaller1" and click "Properties".

Change the ServiceName to "Test Windows Service" (or your own name) and StartType to "Manual" (or you can choose "Automatic" if you need this service to be automatic).

Right-click the serviceProcessInstaller1, go to the properties window and change "Account" to "LocalSystem".

Build the project to see the .exe file at the location where you created the solution.

That's all. Your Windows Service is all ready to install in your machine.

Installing the Windows Service

Go to "Start" >> "All Programs" >> "Microsoft Visual Studio 2012" >> "Visual Studio Tools" then click "Developer Command Prompt for VS2012".

Type the following command:

InstallUtil.exe <physical location of your TestWindowService.exe file>

in my case it is :

InstallUtil.exe "C:\Sandbox\WindowServices\TestWindowService\TestWindowService\bin\Debug\TestWindowService.exe"

and press Enter.

Here you go, the TestWindowService is installed successfully.

How to start the Windows Service

Since we chose StartType = Manual, we must start the Windows Service manually by visiting the "Services and Applications" window in the computer.

Select the Test Windows Service and click "Start" to start the service. Go to the "TestWindowService.exe" location to see the logs.

LogFile.txt

Since we are tracking our Windows Service by writing some logs to a .txt file called LogFile.txt, we can test the working condition of our Windows Service by looking at this log file.

As you can see in the preceding screen, you can find the LogFile.txt file at the physical location that your TestWindowService solution exists.

Click the LogFile.txt to see the logs, whether our service is doing the job that we set it to do for every 30 seconds.

If you look at the preceding log file, we can prove that our Windows Service is running and doing the job that we wanted on a 30 seconds interval.

Stop the Windows Service

To stop the Windows Service, just click "Stop" link in the Services window by selecting our TestWindowService.

Logfile after stopping our service:

Type the following two commands in the "Developer Command Prompt for VS2012" to uninstall the TestWindowService.exe.
cd <physical location of your TestWindowService.exe file>
and press Enter. In my case it is:
cd C:\Sandbox\WindowServices\TestWindowService\TestWindowService\bin\Debug
InstallUtil.exe /u “TestWindowService.exe”
And press enter.
After executing the preceding commands, the TestWindowService will be uninstalled from your computer.

Summary

In this article, I explained how to develop a Windows Service and install it using InstallUtil.exe from a command prompt.

I believe that I have explained each step clearly that can be easily understandable for a beginner to develop and install a Windows Service.

If you want to register the application on your deployment enviroment where visual studio is not present then run the install.util command by following location
C:\Windows\Microsoft.NET\Framework\v4.0.30319
Change the version as you have in my case i have v4.0.30319

I hope this article will help you

Regards

Rashid Imran Bilgrami

SEND SMS or Call HttpWebRequest on Proxy Server or ISA Server

2016-05-21T23:48:00.000-07:00

Dear All
I tried to access the HttpWebRequest to send the SMS the code was working fine with my online website but when i run it with my local server and the LAN server i got and server not responding error

Original Solution Post
http://stackoverflow.com/questions/20336826/httpwebrequest-cannot-connect-through-proxy

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond IP Address:80
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond IP ADDRESS:80

After quick review of my code i found the issue that my local enviroment is using ISA proxy server and that the main issue that the local intranet environment is throwing following error

Once i do the research i found the above post as a solution with quick hint

1) Add the following lines in your code
HttpWebRequest req = (HttpWebRequest)WebRequest.Create("http://www.websiteurl.com");

// This is a problem that the code did not use the proxy
req.Proxy = new WebProxy("[Your Proxy Server Name]", 8080);
req.Proxy.Credentials = new NetworkCredential("User Name", "Password");

Here is the complete code

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Net;
using System.IO;
public partial class _SendSMS : System.Web.UI.Page
{

private void InitializeComponent()
{

this.Load += new System.EventHandler(this.Page_Load);

}

private void Page_Load(object sender, EventArgs e)
{

SendMessage(username, password, message, sender, number);
}

public string SendMessage(string username, string password, string msg, string sender, string numbers)

{

HttpWebRequest req = (HttpWebRequest)WebRequest.Create("http://www.websiteurl.com");

req.Method = "POST";

req.ContentType = "application/x-www-form-urlencoded";

req.Proxy = new WebProxy("[Your Proxy Server Name]", 8080);

req.Proxy.Credentials = new NetworkCredential("User Name", "Password");

string postData = "mobile=" + username + "&password=" + password + "&numbers=" + numbers + "&sender=" + sender + "&msg=" + ConvertToUnicode(msg) + "&applicationType=24";

req.ContentLength = postData.Length;

StreamWriter stOut = new

StreamWriter(req.GetRequestStream(),

System.Text.Encoding.ASCII);

stOut.Write(postData);

stOut.Close();

// Do the request to get the response

string strResponse;

StreamReader stIn = new StreamReader(req.GetResponse().GetResponseStream());

strResponse = stIn.ReadToEnd();

stIn.Close();

return strResponse;

}

I hope it save your time
Rashid Imran Bilgrami

Mobile APP development with Visual studio.net 2015

2016-05-10T23:40:00.001-07:00

Dear All

This is an awesome video for the one VS application tool for development the code of all mobile devices

I hope it will work for you

Regards
Rashid Imran Bilgrami

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated

2016-03-21T02:10:00.001-07:00

Dear All,
Once i got the issue for the timeout i fixed the following in the code

"
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated"

Its a vb code you can use it in C# also

Dim ObjCon As New SqlConnection
ObjCon.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("conString").ConnectionString
ObjCon.Open()
ObjCmd.Connection = ObjCon
ObjCmd.CommandText = "Select * from your table"

' Its a trick only
ObjCmd.CommandTimeout = 0

Try
ObjDr = ObjCmd.ExecuteReader
Catch ex As Exception
Response.Write("Following Error is there:" & ex.ToString() & "Kindly contact with IT Department")
End Try

If ObjDr.HasRows = True Then
DataGrid1.DataSource = ObjDr
DataGrid1.DataBind()
End If
ObjDr.Close()
ObjCon.Close()

I hope it will work with you guys

Regards
Rashid Imran Bilgrami

How to Get All SQL Tables

2016-03-07T21:10:00.001-08:00

Dear All,
If you want to get all SQL tables through query use the following command

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE
TABLE_TYPE='BASE TABLE' order by table_name

I hope it save your time

Regards
Rashid Bilgrami

How to create and consume web service

2015-11-24T22:29:00.002-08:00

Create web service & Consume it with Create As a Website Option

This is a tutorial for how to create and consume web service if you are creating ASP.net application with the option of create as a website

Consume it with Create As a Project Option (Highly Important Check this one also)

This is a tutorial for how to create and consume web service if you are creating ASP.net application with the option of create as a website

Create project as a NEW > Website

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

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// it's just a multi view nothing else
surveyorProfile.SetActiveView(loginInformation);
}
protected void Button1_Click(object sender, EventArgs e)
{
surveyorProfile.SetActiveView(displayInformation);
// load profile
loadProfile(uID.Text, pass.Text);
}
protected void loadProfile(string username, string password)
{
/*SurveyorServices is an reference name what i made at the time of service while SurveyorCandidateProfileServiceSoapClient you can get once you create the project as a website and this is only tricky part in website project and normal project /*

SurveyorServices.SurveyorCandidateProfileServiceSoapClient client = new SurveyorServices.SurveyorCandidateProfileServiceSoapClient();

/*client.GetSCProfileList(username, password)[0]; is the function name return more than one values as a result*/
var test = client.GetSCProfileList(username, password)[0];
firstName.Text = test.SCPFirstname.ToString();
secondName.Text = test.SCPLastname.ToString();
familyName.Text = test.SCPFamilyname.ToString();
dateOfBirth.Text = test.SCPDateofBirth.ToString() ;
Gender.Text= test.Gender.ToString();
IDNumber.Text = test.ID.ToString();
//Nationality.Text = test.SCPNationality;
currentCity.Text =test.SCPCity.ToString();
//passportNumber.Text = test.SCPPassport.ToString();
}

}

Create Project as a New > Project

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

namespace WebApplication1
{
public partial class GetSurvyorList : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// it's just a multi view nothing else
surveyorProfile.SetActiveView(loginInformation);
}
protected void Button1_Click(object sender, EventArgs e)
{
surveyorProfile.SetActiveView(displayInformation);
// load profile
loadProfile(uID.Text, pass.Text);
}

protected void loadProfile(string username, string password)
{
/*SurveyorServices is an reference name what i made at the time of service while SurveyorCandidateProfileServicet you can get once you create the project as New > Project this is a class name which you can find if you review the video 2 or expand all the file and check the References.cs under your add reference file/*
SurveyorServices.SurveyorCandidateProfileService client = new SurveyorServices.SurveyorCandidateProfileService();

/*client.GetSCProfileList(username, password)[0]; is the function name return more than one values as a result*/
var test = client.GetSCProfileList(username, password)[0];
firstName.Text = test.SCPFirstname.ToString();
secondName.Text = test.SCPLastname.ToString();
familyName.Text = test.SCPFamilyname.ToString();
dateOfBirth.Text = ;
Gender.text= ;
IDNumber.Text = "";
Nationality.Text = "";
currentCity.Text = "";
email.Text = "";

}
}
}

I hope both videos save your search and time

Regards

Rashid Imran Bilgrami

Increase DNN Site Speed

2015-09-03T12:50:00.001-07:00

Dear All,

This is how you can make the dnn faster

Upgrade the site 6.01.05 >> 6.02.06 >> 7.00.05 (latest version)
Change the following settings in host >> host settings:

Basic settings - turn off copyright credits
Performance settings - cache setting heavy
Authenticated cacheability - Public
Client resource management - Enable Composite Files
Client resource management - Minify CSS
Client resource management - Minify JS
Scheduler mode - Timer Method
Enable Event Log Buffer - on
Auto sync file system - off
In Admin >> Site Settings turn off Enable Skin Widgets if not used

Regards

Crm 2015 import in different domain (You must map your Active Directory user account to at least one enabled Microsoft Dynamics CRM User who has the System Administrator security role before the organization can be imported.)

2015-08-16T03:50:00.002-07:00

Dear All,
if you are facing the below issue by importing the CRM in different domain then solution is below:

You must map your Active Directory user account to at least one enabled Microsoft Dynamics CRM User who has the System Administrator security role before the organization can be imported.

Go to you sql
Open CRM database
Open table SystemUserBase
Change the GUID and Domain name with your AD user (for getting GUID check the default organization table)
Rest of the user make it IsActiveDirectoryUser Column "False"

After that the error will resolve

Regards

Rashid Imran Bilgrami

Downgrade SQL from Enterprise to Standard “Database cannot be started in this edition of SQL server” : Restore failed for Server Error in CRM 2011

2015-08-16T02:43:00.001-07:00

Dear All

If you want to downgrade your database from the enterprise to standard here is the following solution

Reference URL:

https://ashwaniashwin.wordpress.com/2013/02/28/database-cannot-be-started-in-this-edition-of-sql-server-restore-failed-for-server-error-in-crm-2011/

Hello Everyone,

Today while trying to restore the Org_MSCRM Database from production server to one of my testing server, I came across a new Error:“Database ‘Org_MSCRM’ cannot be started in this edition of SQL Server because it contains a partition function ‘AuditPFN’. Only Enterprise edition of SQL Server supports partitioning. Database ‘Org_MSCRM’ cannot be started because some of the database functionality is not available in the current edition of SQL Server. (Microsoft SQL Server, Error:

905)”

The error was very clear indeed as my production server was SQL Server Enterprise Edition and testing server was SQL Server Standard Edition.
Basically while installing CRM 2011 in Enterprise edition, a partition is created for auditing functionality in AuditBase table. And since this functionality is missing in rest of the SQL Server editions, the restoration of the Database from Enterprise Edition to Standard Edition throws error. The only possible solutions are either to remove the Audit partitioning or install the Enterprise Edition.

I then came across a Fast Publish article from Microsoft here describing about the issue in detail along with the Script to delete the partition.

Here is a script that you want to run by selecting your database

IF EXISTS (SELECT name FROM sys.partition_schemes WHERE name='AuditPScheme')
BEGIN
 SELECT 
  CASE WHEN ind.type != 1 
   THEN 
    'DROP INDEX [dbo].[AuditBase].' + QUOTENAME(ind.name) + ' ' 
   ELSE ' ' 
  END + 
  'CREATE ' + CASE is_unique WHEN 1 THEN 'UNIQUE ' ELSE '' END  +
  ind.type_desc + ' INDEX ' + QUOTENAME(ind.name  COLLATE SQL_Latin1_General_CP1_CI_AS )  + ' ON [dbo].' +  QUOTENAME(OBJECT_NAME(object_id)) + ' (' +
   
  REVERSE(SUBSTRING(REVERSE((
   SELECT name + CASE WHEN sc.is_descending_key = 1 THEN ' DESC' ELSE ' ASC' END + ','
   FROM
    sys.index_columns sc
    JOIN sys.columns c ON sc.object_id = c.object_id AND sc.column_id = c.column_id
   WHERE
    OBJECT_NAME(sc.object_id) = 'AuditBase' AND
    sc.object_id = ind.object_id AND
    sc.index_id = ind.index_id
   ORDER BY index_column_id ASC
   FOR XML PATH('')
        )), 2, 8000)) + ')' +
  CASE WHEN ind.type = 1 
   THEN 
    ' WITH (DROP_EXISTING = ON) ON [PRIMARY]' 
   ELSE 
    ' ' 
  END  as Script 
 INTO #indexesScript
 FROM sys.indexes ind
 JOIN sys.partition_schemes ps on ind.data_space_id=ps.data_space_id 
 WHERE
  OBJECT_NAME(object_id) = 'AuditBase'
  AND ps.name = 'AuditPScheme' 
  AND is_unique_constraint = 0 
 SELECT * FROM #indexesScript 
 
 DECLARE @recreateScript nvarchar(max)
 DECLARE indScript CURSOR FOR
 SELECT Script FROM #indexesScript
 OPEN indScript
 FETCH NEXT FROM indScript INTO @recreateScript
 
 WHILE @@FETCH_STATUS = 0   
 BEGIN   
  BEGIN TRANSACTION t1
  Execute sp_executesql @recreateScript
  
  IF @@ERROR > 0
  BEGIN 
   ROLLBACK TRAN t1
   declare @message varchar(max)
   set @message = 'Audit history recreate index failed. SQL: ' + @recreateScript 
      RAISERROR (@message, 10,1)
  END
  ELSE
  BEGIN
   COMMIT TRAN
  END
  FETCH NEXT FROM indScript INTO @recreateScript   
 END   
 DROP PARTITION SCHEME AuditPScheme
 DROP PARTITION FUNCTION AuditPFN
  
 CLOSE indScript   
 DEALLOCATE indScript 
 DROP TABLE #indexesScript
END

After successfully running the Script, try to restore the DB again.

Note: Please take a backup before running the script on the Org_MSCRM database.

Even though the Auditing feature is still functional on Standard Edition, the ability to delete the partition of Audit History will not be available.

Thanks.

Individual css for every li node

2015-04-19T03:05:00.000-07:00

Dear All

If you are looking for define individual node for every css here is a code

for first node

li:first-child {

background: #ff0000;

}

for last node

li:last-child {

background: #ff0000;

}

for nay number of node (change the 2 with the number of node you want to apply the style)

li:nth-child(2) {

background: #ff0000;

}

Regards

Rashid Imran Bilgrami

How to convert and crack windows server 2012 from Evaluation to Full

2015-04-16T01:33:00.003-07:00

Dear All

This is a way how you Convert Evalution to Full

Step1:

Open CMD and run following command
DISM /online /Get-CurrentEdition

<edition ID> is like ServerStandard with out Eval

Step 2:
DISM /online /Set-Edition:<edition ID> /ProductKey:XXXXX-XXXXX-XXXXX-XXXXX-XXXXX /AcceptEula

WINDOWS SERVER 2012
Serial Key

Windows Server 2012
DataCenter: 48HP8-DN98B-MYWDG-T2DCC-8W83P
Datacenter: Y4TGP-NPTV9-HTC2H-7MGQ3-DV4TW

Standard: XC9B7-NBPP2-83J2H-RHMBY-92BT4
Standard R2: DBGBW-NPF86-BJVTX-K3WKJ-MTB6V

Server Essentials: K2XGM-NMBT3-2R6Q8-WF2FK-P36R2

For Standard R2 here is a command
For R2 its like that
DISM /online /Set-Edition:ServerStandard /ProductKey:DBGBW-NPF86-BJVTX-K3WKJ-MTB6V /AcceptEula

Regards

Best Visualization Technical Blogs For DNN, PHP, ASP, .net

Take Back up for all SSRS Report

AI Logo Design Website

Top 15 AI Software Tools For Developers by ChatGPT

How to run Python On IIS

C# – FileUpload not working in Multiview and updatepanel

Upload Image by using File Control with JS or Update Panel or C# DNN Partial Post back

We need to create multi view and views and under view we have a form where the file upload control is present we need to place this script under this view otherwise partical post back in DNN stuck because controller will not found

Good MVC Tutorial

Read PBX data

Regular expression builder online tool

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

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

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

Kill remote process using process id.

Kill remote process using image name

Kill processes executed by a particular user

Viewing the list of processes on remote computer

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

SQL SERVER – Cannot resolve collation conflict for equal to operation

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

VB Code

C# Code

How to Create Window Service and execute it

Here we go...

SEND SMS or Call HttpWebRequest on Proxy Server or ISA Server

Here is the complete code

Mobile APP development with Visual studio.net 2015

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated"

How to Get All SQL Tables

How to create and consume web service

Create web service & Consume it with Create As a Website Option

Consume it with Create As a Project Option (Highly Important Check this one also)

Create project as a NEW > Website

Create Project as a New > Project

Rashid Imran Bilgrami

Increase DNN Site Speed

Crm 2015 import in different domain (You must map your Active Directory user account to at least one enabled Microsoft Dynamics CRM User who has the System Administrator security role before the organization can be imported.)

Downgrade SQL from Enterprise to Standard “Database cannot be started in this edition of SQL server” : Restore failed for Server Error in CRM 2011

Individual css for every li node

How to convert and crack windows server 2012 from Evaluation to Full

"
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated"