For .NET, SQL, jQuery and other technical articles and useful code snippets.
There are some cases you wanted to check the Operating system installed on your SQL server. You may not have remote login access to the server where SQL server is installed in that case it will be difficult to know what is the operating system installed on your server where SQL database is installed.
In this article I am going to explain you the simple query which you can run in your SQL server Query analyzer and it will show you the Operating System version installed on your database server.
SQL Server by default provides you an inbuilt table with all the details of the operating system installed on your database server. sys.dm_os_windows_info is the table you may query in this regard.
Your final query will be,
SELECT windows_release, windows_service_pack_level, windows_sku, os_language_versionFROM sys.dm_os_windows_infoAnd the output of the above query will be,
| windows_release | windows_service_pack_level | windows_sku | os_language_version |
| 6.1 | Service Pack 1 | 10 | 1033 |
In the above result you can see that windows release is 6.1 means Windows Server 2008 R2 in my case. It can be Windows 7 if your database is not installed on the server.
You can find all the operating system version number in below chart.
| Operating system | Version number |
| Windows 8.1 | 6.3 |
| Windows Server 2012 R2 | 6.3 |
| Windows 8 | 6.2 |
| Windows Server 2012 | 6.2 |
| Windows 7 | 6.1 |
| Windows Server 2008 R2 | 6.1 |
| Windows Server 2008 | 6 |
| Windows Vista | 6 |
| Windows Server 2003 R2 | 5.2 |
| Windows Server 2003 | 5.2 |
| Windows XP 64-Bit Edition | 5.2 |
| Windows XP | 5.1 |
| Windows 2000 | 5 |
In this article I am going to explain timer/stop watch function using JavaScript. In many situations we may get requirement to show the timer in your application. This article will help you to show the timer using JavaScript in a webpage.
To implement the timer first we will write JavaScript function and save it as .Timer.js.
var milliSec = 0; var seconds = 0; var minutes = 0; function startTimer() { var timerVal = document.getElementById('lblTimer'); timerVal.value = minutes + ":" + seconds + ":" + milliSec; go=setTimeout("startTimer()",1); milliSec++; if(milliSec==100) { milliSec=0; seconds++; } if(seconds==60) { seconds=0; minutes++; } } function stopTimer() { clearTimeout(go) }
Below is the HTML code to design the webpage. Here you can see that startTimer() and stopTimer fucntion is called on click of the button. Also you can see that I have referred the Timer.js Javascript file which is saved in the root folder.
<html> <head> <title>Timer Using JavaScript</title> <script type="text/javascript" src="Timer.js"></script> </head> <body> <form> <table> <tr> <td colspan="3" ><input id="lblTimer" type="text" name="displayTime" STYLE="color: red; border:0px; font-family: Verdana; font-weight: bold; font-size: 25px; " size="10" maxlength="30 value="00:00:00" /></td> </tr> <tr> <td> <input type="button" value="Start Timer" onclick="startTimer()"/> <input type="button" value="Stop Timer" onclick="stopTimer()"/> </td> </tr> </table> </form> </body> </html>
The output looks like below.
Do you want to display all directories in the specified directory using C#? Read this article to know how to list the subdirectories using .NET
Here first I added a Label, a TextBox, a Button and a ListBox to the form. Textbox is used to enter the folder path. Once you click on on the button sub directories will be shown in the list box.
We will see the page design first.
Below is the source code for the page design.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ListDir.aspx.cs" Inherits="Blog.ListDir" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <style type="text/css"> .auto-style1 { width: 100%; } .auto-style2 { width: 156px; } .auto-style3 { width: 156px; height: 26px; } .auto-style4 { height: 26px; } </style> </head> <body> <form id="form1" runat="server"> <div> </div> <table class="auto-style1"> <tr> <td class="auto-style3"> <asp:Label ID="lblDir" runat="server" Text="Enter the Root Directory"></asp:Label> </td> <td class="auto-style4"> <asp:TextBox ID="txtPath" runat="server"></asp:TextBox> </td> <td class="auto-style4"></td> </tr> <tr> <td class="auto-style2"> </td> <td> <asp:Button ID="btnDisplay" runat="server" Text="Show All Sub Directories" OnClick="btnDisplay_Click" /> </td> <td> </td> </tr> <tr> <td class="auto-style2"> </td> <td> <asp:ListBox ID="lstDir" runat="server" Height="124px" Rows="5" Width="154px"></asp:ListBox> </td> <td> </td> </tr> </table> </form> </body> </html>
On Button Click event write the following code.
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.IO; namespace Blog { public partial class ListDir : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { lstDir.Visible = false; } protected void btnDisplay_Click(object sender, EventArgs e) { lstDir.Visible = true; lstDir.Items.Clear(); string strFolderPath = txtPath.Text; DirectoryInfo dirInfo = new DirectoryInfo(strFolderPath); if (dirInfo.Exists) { DirectoryInfo[] dirSubDir = dirInfo.GetDirectories(); for (int i = 0; i < dirSubDir.Length; i++) { lstDir.Items.Add(dirSubDir[i].ToString()); } } else { lstDir.Items.Add("No such directory..."); } } } }
And the final output will be like below,
There are many cases you may have to share the data with other computer/Users. If anybody have more than one computer and want to transfer some file over it you have to share the folder so that other users will be able to access the files inside the shared folder. Read this article to learn how to share a folder over your local network using ASP.NET.
For implementing this concept I have created one webpage like below.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ShareFolder.aspx.cs" Inherits="Blog.ShareFolder" %><!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1 {width: 100%;
}
.auto-style2 {width: 169px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<table class="auto-style1">
<tr>
<td class="auto-style2">
<asp:Label ID="Label1" runat="server" Text="Share Folder Path"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtPath" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style2">
<asp:Label ID="Label2" runat="server" Text="Share Folder Name"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style2">
<asp:Label ID="Label3" runat="server" Text="Share Folder Description"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtDesc" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style2"> </td>
<td>
<asp:Button ID="btnShare" runat="server" OnClick="btnShare_Click" Text="Share Folder" />
</td>
</tr>
</table>
<div>
<asp:Label ID="lblResult" runat="server"></asp:Label>
</div>
</form>
</body>
</html>
Here I am using three TextBox.
1. txtPath - To enter complete folder path which you want to share
2. txtName - Folder name to be displayed for shared folder
3. txtDesc - Description for the shared folder
First we need to create a directory and subdirectories in the specified path given in the first TextBox.
Directory.CreateDirectory(strSharePath);
Next step is to create a management class. For that we need to add a reference System.Management. You can refer below screen print to know how to add the reference.
Then create a Shared folder with the name and description what we got through TextBox.
Here is the complete code you may use for this purpose:
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.IO;using System.Management;namespace Blog{public partial class ShareFolder : System.Web.UI.Page
{protected void Page_Load(object sender, EventArgs e)
{}
protected void btnShare_Click(object sender, EventArgs e)
{ string strSharePath = txtPath.Text.ToString(); string strShareName = txtName.Text.ToString(); string strShareDesc = txtDesc.Text.ToString(); try {Directory.CreateDirectory(strSharePath);
ManagementClass oManagementClass = new ManagementClass("Win32_Share");
ManagementBaseObject inputParameters = oManagementClass.GetMethodParameters("Create");ManagementBaseObject outputParameters;
inputParameters["Description"] = strShareDesc; inputParameters["Name"] = strShareName; inputParameters["Path"] = strSharePath;inputParameters["Type"] = 0x0;//disk drive
inputParameters["MaximumAllowed"] = null;
inputParameters["Access"] = null;//Make Everyone has full control access
inputParameters["Password"] = null;
outputParameters = oManagementClass.InvokeMethod("Create", inputParameters, null);//// Invoke the method on the ManagementClass object
if ((uint)(outputParameters.Properties["ReturnValue"].Value) != 0)
{throw new Exception("There is a problem while sharing the directory.");
}
else { lblResult.Text = "Share Folder has been created with the name :" + strShareName;}
}
catch(Exception ex) {lblResult.Text = ex.Message.ToString();
}
}
}
}
You have many more options for the Create method of the Win32_Share class, you can read all this option from MSDN article.
After running the code, you will be seeing the interface like below. You can also see the data which you need to enter in below screen print.
Once you execute the code successfully your folder will be shared like below,
Are you thinking of decorating your website with some animation? Then there is one simple and useful control in AjaxControlToolkit named Animation extender which help you to give excellent animation to your pages.
You can apply animations to target control when some events likes, OnLoad, OnClick, OnMouseOver, or OnMouseOut raised. Here I am trying to explain how this Ajax Animation Control will work.
Create a new webform in ASP.NET. Drag and drop ToolScriptManager, Panel and a Animation Extender control.
Here I am using a panel for animation which is the target control. First I created a style sheet for the panel.
<style>
.animationPanel
{position : absolute;
height : 250px;
width: 300px;
top: 100px;
left: 400px;
border-width: 2px;
border-color:red;
border-style:solid;
}
</style>
First I set animation property for the text inside the panel and then I set the animation for panel. Here I am doing the animation sequentially. I wrote the code on click event of the panel.
So the entire .aspx page looks like below.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Ajaxanimation.aspx.cs" Inherits="Blog.Ajaxanimation" %><%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %><!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>AjaxAnimation</title>
<style>
.animationPanel
{position : absolute;
height : 250px;
width: 300px;
top: 100px;
left: 400px;
border-width: 2px;
border-color:red;
border-style:solid;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<br />
<asp:Panel ID="ajaxPanel" runat="server" CssClass="animationPanel">
Click me!!! I will move...<br><br><br>
<div id ="info">
Thanks for vising asheej.blogspot.com<br>
You are reading the article related to AJAX animation extender
</div>
</asp:Panel>
<asp:AnimationExtender ID="AnimationExtender1" runat="server" TargetControlID="ajaxPanel">
<Animations>
<OnClick>
<Sequence><%-- Sequance is used to do the animation sequantially --%>
<%-- Below code will help you to move the Panel --%>
<Parallel AnimationTarget="info" Duration=".2">
<Color PropertyKey="color"
StartValue="#0000CD" EndValue="#FF0000" />
<Color PropertyKey="borderColor"
StartValue="#0000CD" EndValue="#FF0000" />
</Parallel>
<Parallel AnimationTarget="info" Duration=".2">
<Color PropertyKey="color"
StartValue="#FF0000" EndValue="#666666" />
<Color PropertyKey="borderColor"
StartValue="#FF0000" EndValue="#666666" />
</Parallel>
<Parallel AnimationTarget="flyout" Duration=".1" Fps="30">
<Move Horizontal="200" Vertical="-75" />
<Resize Height="300" Width="300" />
<Color AnimationTarget="info" PropertyKey="backgroundColor"
StartValue="#ADFF2F" EndValue="#00FFFF" />
</Parallel>
</Sequence>
</OnClick>
</Animations>
</asp:AnimationExtender>
</div>
</form>
</body>
</html>
After running the code the result should be looks like this:
AnimationExtender Control properties:
Are you planning to use Rating Control in your application from Ajax Control toolkit? This article is trying to give information on AJAX Rating Control and how to use this control. The main purpose of AJAX Rating Control is to give a chance to user for rating or reviewing content in your website.
To use Ajax Rating Control, first we have to install Ajax control toolkit. If you haven’t installed AjaxControlToolkit you may refer my article How to Install AjaxControlToolkit
Let me show you how I used Ajax Rating control.
First we need to add One Label, ToolkitScriptManager and Ajax rating Control to the webpage.
Do you have any doubt, why I have used ToolkitScriptManager instead of ScriptManager? First I dropped ScriptManager in the webpage but while running, I got an error “0x800a138f - JavaScript runtime error: Unable to get property 'UI' of undefined or null reference” like below.
This exception can be avoided using toolscriptManager because most of the controls from AjaxToolKit work using Ajax script. ToolkitScriptManager adds most of the updated Ajax Script.
Here I am using 3 images to show the state (Empty,Filled, Saved) of rating control. For that you need to create a folder in your project root directory and save three star images for visible star, star in waiting mode and star in filled mode.
Now the time for adding CSS class in the head section.
.filledRatingStar {background-image: url(Images/FilledStar.png);
}
.emptyRatingStar {background-image: url(Images/EmptyStar.png);
}
.savedRatingStar {background-image: url(Images/SavedStar.png);
}
Some properties need to set to Ajax rating Control. They are :
After doing all the above 3 steps,the source page should look like this:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="RatingControl.aspx.cs" Inherits="Blog.RatingControl" %><%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %><!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style>
.ratingStar {font-size: 0pt;
width: 15px;
height: 50px;
margin: 0px;
padding: 0px;
cursor: pointer;
display: block;
background-repeat: no-repeat;
}
/*You need to make sure that Images folder is created in your Project root directory and copy the images in this folder */
.filledRatingStar {background-image: url(Images/FilledStar.png);
}
.emptyRatingStar {background-image: url(Images/EmptyStar.png);
}
.savedRatingStar {background-image: url(Images/SavedStar.png);
}
</style>
</head>
<body style="height: 83px">
<form id="form1" runat="server">
<div>
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<asp:Label ID="lblrate" runat="server" Text="Rate this blog"></asp:Label>
<asp:Rating ID="Rating1" runat="server" RatingAlign="Horizontal"
CurrentRating ="1"
EmptyStarCssClass="emptyRatingStar"
FilledStarCssClass="filledRatingStar"
RatingDirection="LeftToRightTopToBottom"
StarCssClass="ratingStar"
WaitingStarCssClass="savedRatingStar"
Direction="LeftToRight">
</asp:Rating>
</div>
</form>
</body>
</html>
Hope you enjoy reading this article, if you have any comment please post below…
This is one of the common error you get when you start using AJAX first time in your project. Nothing to panic about this, you can easily resolve the error “System.IO.FileNotFoundException: Could not load file or assembly 'AjaxMin, Version=4.97.4951.28478, Culture=neutral, PublicKeyToken=21ef50ce11b5d80f' or one of its dependencies. The system cannot find the file specified.” by copying the missing dll in the correct folder.
If you look at the error once again you may notice that error clearly suggest it cannot find the assembly 'AjaxMin’ which means once you open your project bin folder you may not find the 'AjaxMin.dll’ file.
So to resolve this issue what you have to do is, search for 'AjaxMin.dll’ and copy this into the project bin folder.
After copying this 'AjaxMin.dll’ in your project bin folder try to run the application and see if it works fine.
You must have seen the statement SET NOCOUNT ON in most of the stored procedure. When I saw this message first time I was thinking why this has been used in almost all stored procedure what will happen if I set SET NOCOUNT OFF in place of ON. Here in this article I thought I will share you the advantage of using SET NOCOUNT ON in SQL Stored Procedure and how this will improve the performance of your query.
The main advantage of using SET NOCOUNT ON in your stored procedure or TSQL statement is, this statement automatically suppress the message which shows how many rows has been affected by the query. Which means, this will reduce the overhead of the server and improves the performance when you execute query in a table which has got millions of data.
What exactly is happening inside the server is when you execute a stored procedure with SET NOCOUNT ON it prevents the sending of DONE_IN_PROC messages to the client for each statement in your stored procedure. Imagine you have a loop or several statement has to be executed!!! So using SET NOCOUNT ON will definitely boost your query performance and adding the line SET NOCOUNT ON is one of the main DBA tasks when they find that query or procedure is not performing well.
If you wanted to know the message of affected rows then you can add SET NOCOUNT OFF in your query. This will show the number of rows affected by executing the query.
Irrespective of using SET NOCOUNT ON or SET NOCOUNT ON SQL server internally updates @@ROWCOUNT function. So querying @@ROWCOUNT function will give you the affected rows details at any time.
Now let’s see how it shows in SQL query analyzer,
Below is my stored procedure, you can notice that I have commented the line SET NOCOUNT ON.
CREATE PROCEDURE [dbo].[sp_GetCustomerList]
ASBEGIN--SET NOCOUNT ON;
SELECT * from Customer
ENDWe will execute this procedure and see the result.
Now we will un comment the line SET NOCOUNT ON and see the output,
CREATE PROCEDURE [dbo].[sp_GetCustomerList]
ASBEGINSET NOCOUNT ON;
SELECT * from Customer
END
Hope you are now clear about the usage of SET NOCOUNT ON.
Have you ever heard about NuGet Package? Do you know how to use NuGet Package manager and how to install AJAXControlToolkit using NuGet Package Manager. Here is the answer for all your doubts related to NuGet Package manager for Visual Studio.
Pre-Requisite: System with Visual Studio 2013 and Good Internet Connection
First we will download NuGet Package manager for Visual Studio 2013. You may use the this link :NuGet Package Manager for Visual Studio 2013 for downloading the package.
Once you install the package open Visual Studio 2013 and open the Package Manager Console.
Refer below image to know how to open NuGet Package Manager Console.
Once you click on the Package Manager Console you will find a consol window link below
Here is the place you execute the command install AjaxControlToolkit. As I mentioned earlier you should have good internet connection to download the AjaxControlToolKit otherwise it will throw error.
The command you execute to install AjaxControlToolkit is :PM> Install-Package AjaxControlToolkit
Once you execute the command Install-Package AjaxControlToolkit it may take few seconds and you will below updates,
Finally when the installation completes you will find below updates,
There are many inbuilt commands available in NuGet you can find the help by running the command get-help NuGet and explore all possible options.
I have a requirement to add new column in existing report. Unfortunately rdlc file was given by a third party vendor and we don’t have the complete project and dataset to edit the file.
As you are aware .rdlc is just an XML file, once you open that in notepad or any editor you can see what and all contents are visible in reports. But if you start editing the .rdlc file manually it will be a never ending process.
Here we are going to edit .rdlc file by using Visual Studio. Of course you require Visual Studio Business Intelligence to edit .rdlc file, also I am expecting you to have an access to the database to add new field in your stored procedure or SQL query which is executed from .rdlc to populate the data in reports.
Now we will go to step by step procedure.
1. Convert .rdlc to .rdl first—> This is a very simple technique. You just need to change the extension from .rdlc to .rdl. This will automatically convert the file.
2. Open Visual Studio business intelligence and select new—> Project—> Report project.
3. Right Click solution and select Add—>Existing Items—> Locate your renamed .rdl file.
4. Double Click .rdl file to open it in design mode.
5. Select the last field or the field near to the new one you are going to add. In this example I am adding the new column as the last one.
6. Right Click on the selected field and select Insert Column. You can opt either left or right depends on your choice.
7. Provide required name for the new fields. Here I am giving the name as Test.
8. Now we will add new field in the DataSet. Click on View menu and select report Data to show the dataset.
9. Right Click Dataset and select DataSet Properties.
6. Click on Add button to add new field in the DataSet.
7. And the last steps is to modify your Stored procedure/SQL query to add the new field you added in the reports.
8. Now it’s the time to convert .rdl to .rdlc. and it is exactly same as the firs step, just change the extension from .rdl to .rdlc.
Just copy the .rdlc file in your project folder where it has been placed earlier and access it from your application…That’s it!!!
If you have any doubt or confusion in above steps you can always contact me using my mail ID or write comment below.
Are you looking for an option to rename the SQL 2012 database? If you have an existing stand-alone instance of an SQL 2012 database you wanted to rename the database then this cannot be down from object explorer. When you right click on your database you will be surprised that Rename option will be disabled. Ok, don’t get panic we an do this renaming by running simple query.
Let’s how does it looks if you right click on your database in SQL Server 2012,
Since this is disabled we will use SQL query to rename the database.
USE master;GOALTER DATABASE DemoRename
Modify Name = DemoRenameDB ;GO
Now just refresh your Database and see the result,
