Anuj's Share IT

We all know how important charting is now days. We all store lots of data but the end users generally are the people who do not have much time to use it after putting in hours in correlating and analyzing it. They generally ask for reports charts etc. Traditionally either we had to use GDI+ or buy a third party tool to provide these facilities. MS has started providing this facility free of cost since 2008 (though it was not part of 3.5 framework but one can download the exe and can install it). Starting from framework 4.0 charting controls are also shipping with .NET. It is quite easy to use chart controls, let us see how. Create a web application project and from the toolbox (in design mode) drag chart control. It will be present under the data section. Configure the datasource and set the chart type and X and Y column for the chart. I am using a SQLDataSource and AdventureWorks as my DB. Now we are good to go. Press F5 and you can see the chart. Let us extend the functiona...

You might see the error “HTTP Error 403.14 – Forbidden” when you have a Web site that is hosted on Internet Information Services (IIS) 7.0 and when you visit the Web site in a Web browser. Error Server Error in Application " application name " HTTP Error 403.14 - Forbidden HRESULT: 0x00000000 Description of HRESULT : The Web server is configured to not list the contents of this directory.   Discussion This problem occurs because the Web site does not have the Directory Browsing feature enabled, and the default document is not configured. Now what is this “Default Document”? A default document is the document to which the request will be redirected by the server when the user hits you website domain. That is, the user is typing “http://www.<domain name>” e.g. http://www.anujyadavcse.blogspot.com . Here the user is not typing which page he want the server to serve as part of the request. e.g. http://localhost/Admin.aspx . This generally is the home/login pag...

Introduction You can use encryption in SQL Server for connections, data, and stored procedures. This Article explains you how to Encrypt and Decrypt a text using T-SQL functions.you can encrypt a password and can store a password as VarBinary in a column by using EncryptByPassPhrase function . Encrypted column can be decrypted by using DECRYPTBYPASSPHRASE function. Encryption Encryption is the process of obfuscating data by the use of a key or password. This can make the data useless without the corresponding decryption key or password. Encryption does not solve access control problems. However, it enhances security by limiting data loss even if access controls are bypassed. For example, if the database host computer is misconfigured and a hacker obtains sensitive data, that stolen information might be useless if it is encrypted. Although encryption is a valuable tool to help ensure security, it should not be considered for all data or connections. When you are de...

In this post we will have a look in to SQL Server Reporting Services. In this post we will se its need, capabilities, features and requirements. Before starting on it we will try to analyze the need for it. Why Reporting? Data represented in a usable form provides us information which we need to drive the business in an intelligent way. Enterprises have been collecting data for decades now. It has been a challenge to collect quality data along with quantity. We seems to have overcome this challenge with experience. The challenge which we face now is using this data productively to gain benefit. Data mining is the need of the hour. Here comes the reporting. Workers at all level in organization need information with and for different perspective. Workers at higher level needs reports to get the information to take knowledgeable decisions to benefit the organization and individual. Workers at lower level need information to be productive and perform their task in a more effective mann...

Generally speaking batch files are text files with .bat extension with group of commands that you can execute on command line (cmd). They are generally used to group multiple tasks for smooth and reliable execution, to automate stuff, for repeated jobs etc. Admins generally use these files for administrating the system and also for deployment. Enough said lets see how we can create one and work with it. You can use your favorite text editor. I am going to use notepad. Type -  echo "hello world" in it and save it with the name (any name) firstbat.bat in 'C' drive . Go to start -> run-> cmd Run/Execute the batch file Change the current directory to 'C', for that type cd c:/ of cmd and press enter . Now type 'firstbat' and press enter and you will see "hello world" on the screen. So in short in cmd you will have to go to the directory where you have store the batch file and then type the name of the batch file. Now, le...