Creating Windows Service using ASP.NET

Posted by Venkat | Labels: , ,

Good morning to All

Now I am going to explain how to Create a windows Service in asp.net

What is the purpose of Creating windows service in asp.net ?

For ex: if you have the task of Sending birthday email to the members Automatically or  you are going to do some manipulation on particular day or do some manipulation on Consecutive intervals so at this situation you can go for Window service or even you can do birth email process through Sql Job Scheduling.

Now see how to create a simple service.

Choose Create Project -> VisualC# -> Windows -> Windows Service

Fig 1:


So once you give the windowService Name it will show this - by default the serviceName is Service1 here i am changed to TimerService.

Fig 2:



Then Right Click on Service - Select -> Add Installer

Fig 3:


Then the ProjectInstaller window show two Services like serviceProcessIntaller1 , serviceInstaller1 so you have to change some Properties for this service

Properties of serviceProcessIntaller1

Account - > there are some 4 types of account are there as per the requirement

1) LocalService - for only particular computer

2) Network Service - to access resource on remote side ie: server

3) Local System - to works on local System

4) User - Based on User credentials

For Brief Description Check it :

http://technet.microsoft.com/en-us/library/ms143504.aspx

Fig 4:


Properties of serviceInstaller1

StartType :

1) Automatic

2) Manual

3) Disabled

You have to specify whether you are going to start this Service Manually or Automatically or Disabled the Service.then give the name for ServiceName Property , And give some Name for DisplayName property - this name will be displayed on your servicelist to identify your Service.

Fig 5:


Now we going to write the code for Service on Service1.cs

by default it has OnStart and OnStop Event - so this event occurs when service start and stop.

using System.Timers;

Add timer to do some manipulation on particular intervals

  //Initialize the timer
Timer timer = new Timer();

so here is the code - what i am doing is create a method called AddToFile where i am adding the string to the file ie: on C Directory if the file is present it will write it on  or it will create a new file with the specified name and write the content on that file.

And onStart Event i am creating the Timer Elapsed event which called at every 1 minute so their i am adding another entry on that event.

Finally onStop Event i set the timer enabled = false and made last entry ie: Service stopped.

protected override void OnStart(string[] args)
        {
            // TODO: Add code here to start your service.
            //add line to the file
            AddToFile("Make starting service");

            //ad 1: handle Elapsed event
            timer.Elapsed += new ElapsedEventHandler(OnElapsedTime);

            //ad 2: set interval to 1 minute (= 60,000 milliseconds)
            timer.Interval = 60000;

            //ad 3: enabling the timer
            timer.Enabled = true;
        }

  protected override void OnStop()
        {
            // TODO: Add code here to perform any tear-down necessary to stop your service.
            timer.Enabled = false;
            AddToFile("Make stopping service");
        }

  private void AddToFile(string contents)
        {

            //set up a filestream
            FileStream fs = new FileStream(@"c:\timelog.txt", FileMode.OpenOrCreate, FileAccess.Write);

            //set up a streamwriter for adding text

            StreamWriter sw = new StreamWriter(fs);

            //find the end of the underlying filestream

            sw.BaseStream.Seek(0, SeekOrigin.End);

            //add the text
            sw.WriteLine(contents);
            //add the text to the underlying filestream

            sw.Flush();
            //close the writer
            sw.Close();
        }
        private void OnElapsedTime(object source, ElapsedEventArgs e)
        {
            AddToFile("Make Another entry");
        }

so once you written the code just press F5 to run it show this dialog

Fig 6:

so you can start the service to start the service you have to install installutil.exe through commandline.

so go to Command Prompt on this Path.

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

From here you have to install the service , once you compile the project exe file is created on bin folder.

here is the step to install the Service

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727: InstallUtil "F:\WindowsService1\bin\Debug\WindowsService1.exe"

so if you press enter. Service will be installed.

To UnInstall The service follow this line

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\: IntsallUtil  /u"F:\WindowsService1\bin\Debug\WindowsService1.exe"

Once the Serice is installed it will be available on your Service list To check this follow this one

Start -> Control Panel -> Administrative Tools -> Services -> then find the Service as you given while creating the windowsService ie: DisplayName : TimerService

Fig7:



so if you set the Startup Type - Automatic - the service started when the System boots, you can also start the service Manually Right Click on the Service -> start. to start the service.

After the start the service check the C:\ Directory - you can check the file with the entry.

Happy Coding.


Enhanced by Zemanta

Compress and Cache the CSS and JS file using ASP.NET

Posted by Venkat | Labels: ,

HTTPCombiner
Credit goes to : http://code.msdn.microsoft.com/HttpCombiner

In my last article i have discussed how to compress .aspx pages. Now we are going to see how to compress the Javascript and CSS file.

Once the JS and CSS file is requested to the server and has been Cached. On next time You get it from Cache.If i have 10 Javascript file and 10 Stylesheets , every time when you request the page - each time it requested the server for JS and CSS file ie: 10 request to server for CSS and 10 request to Server for JS, to avoid the issue we have to combine all the CSS as one file and all JS as one file. Therefore only one request is sent to the server to get the JS file so totally two request has been sent to the server one for JS and CSS.

There is some JS and CSS compressor tools available for free, these tools will compress or minify your JS or CSS file this is the one waybut we have to do manually.

If you want to compress the file at runtime, here i am using HTTPCombiner to make the all the CSS as 1 CSS and all the JS and 1 JS file.

It has one file ie: HTTPCombiner.ashx - to Compress the CSS and JS file.Place the file on your project.
Add these two line to include all your Css and Js file on your appSettings tag on your web.config, You can get the file name using key part of the appSettings.

<add key="Set_Css" 

value="App_Themes/Default/Css1.css,App_Themes/Default/Css2.css"/>
  <add key="Set_Javascript" 
value="Javascripts/Js1.js,Javascripts/Js2.js,

http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js"/>

After that you have to give the cSS and JS path on the Page1.aspx.

<link   type="text/css" 
            rel="Stylesheet" 
            href="HttpCombiner.ashx?s=Set_Css&t=text/css&v=1" />

    <script     
        type="text/javascript" 
        src="HttpCombiner.ashx?s=Set_Javascript&t=type/javascript&v=2" >
    </script>

Thats all, now you upload the file to server and check the JS,CSS file compressed (check the file length before and after applying this technique) using Fiddler tool or any other tools.
These are some tools to check Page response time.

http://www.aptimize.com/
http://websiteoptimization.com/services/analyze/
http://www.fiddler2.com/

Compressing Asp.Net Pages

Posted by Venkat | Labels: ,

Good Evening to All.
Here I am going to cover how to compress the .aspx pages.
so there are no.of ways to compress the pages in asp.net
1) using IIS.
2) using Code ie: through HTTPCompress.dll i got the source code from codeproject.com.
so i am going to share with you.
There are two type of Compression ie: Deflate , GZIP. here i am going to use GZIP compression to compress the asp.net pages.
First Place the DLL file ie::HTTPCompress.dll to the Bin folder of your project.
Then you have to include some tag on web.config file

<configsections>
  <sectiongroup name="Flanders">
   <section name="HttpCompress" type="Flanders.Library.Modules.HttpCompress.Configuration, HttpCompress">
  </section>
 </sectiongroup>
<flanders>
  <httpcompress compressiontype="GZip">
   <excludedpaths>
    <add path="NoCompression.aspx">
   </add>
   <excludedmimetypes>
    <add mime="image/jpeg">
   </add>
  </excludedmimetypes></excludedpaths>
</httpcompress>
</flanders>
</configsections>
Here i am using GZiP Compression technique. there are two more inner Tags ie: ExcludePaths, ExcludeMimeTypes.
ExcludePaths - It includes the Page Name that don't want to compress.
ExcludeMimeTypes - Include the mime types that dont want to compress the images..
By default images are compressed so no need to compress the image while using compression so our ExcludedMimeTypes tag should be like this.

<excludedmimetypes>
  <add mime="image/jpeg">
  <add mime="image/jpg">
  <add mime="image/png">
  <add mime="image/gif">
</add>
</add>
</add>
</add>
</excludedmimetypes>
Finally we need to add the httpModules

<httpmodules>
   <add> name="HttpCompressModule" type="Flanders.Library.Modules.HttpCompress.HttpModule,HttpCompress"/>
 </add>
</httpmodules>
Download Source Code

Credit goes to :
Ref: http://www.codeproject.com/KB/aspnet/HttpCompress.aspx

Postback not works when using HTTPCompression

Posted by Venkat | Labels: , ,

Some members asked this question on forums. Here is the Solution to overcome this issue.

When i am going to compress the .aspx pages using HTTPCompression, the postback will not works. Because it also compressing the Scripresource.axd, webresource.axd file.

To make the postback works in your project you do not compress the above two files, by adding these code.

Solution:

........,

<httpcompress compressiontype="GZip">
 <excludedpaths>
 <add path="scriptresource.axd">
 <add path="webresource.axd">
</add>
</add>
</excludedpaths></httpcompress>


And one more thing don't compress the images like jpg, gif, jpeg etc.. because its already compressed one. if you compress the image it will degrade the performance. you should the exclude the image from compression.

Solution:

..,
<excludedmimetypes>
 <add mime="image/jpeg">
 </add>
 </excludedmimetypes>

Thanks to all.

Convert String to DateTime using ASP.NET

Posted by Venkat | Labels: , ,

I saw the question repeatedly asking on forums ie: how to convert the String to datetime.

even if someone give solution still the problems exists..,

Error: String is not recognized as a valid DateTime.

Here i am giving the solution to overcome the problem.

First make sure whether you entered is a valid date or not because User may enter alphabets, special symbols etc.. so in order to avoid that , I have to validate the textbox. Here i am using the Regex to to validate the date.

This is my Article to vaildate date using Regex

try
{
 string sDate ="06/05/2010";
// this the regex to match the date ie: dd/MM/yyyy
 string _dateExpression = @"^((0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](?:19|20)\d\d)$";
 Regex chkDate = new Regex(_dateExpression);
 if ((chkDate.IsMatch(sDate))
 {
 // so if the date is valid and its matched you can store the date on DB or do some manipulatio.
 }
 else
 {
 // show invalid date
 }
}
 catch (System.FormatException ex)
 {
 // show invalid date
 }
catch(Exception ex1)
{
throw;
}

So if the user enter other than numbers it shows format exception to avoid this exception. once i caught the FormatException i am showing the Message to user ie:- input is not valid date or something.

Another small manipulation on DateTime

DateTime sDate = new DateTime();

sDate = DateTime.Today; //  Here i am getting like this 5/6/2010

// So i want this format 05/06/2010  - for this i am using Format to Convert the Date as i Want.

string gDate = String.Format("{0:dd-MM-yyyy}", sDate);

Thanks to All.

Sending Email Asynchronously

Posted by Venkat | Labels: , ,

Good Morning to Everybody this is my First article.
Now i am going to see how to send email Asynchronously, actually we send email normally using asp.net Example check here..
Send Email Using ASP.NET

By default smtpClient has one method called SendAsync to send an email ansynchronously. so if you sending an email normally it will take some time for each mail sent. But if you send an email Asynchronously it will not wait for each mail sent it will do the other process , while mail sending is done at background process.
So Here is the code.

//creating mail message object
 MailMessage mailMessage = new MailMessage();
 mailMessage.From = new MailAddress("venkat@gmail.com");
 mailMessage.To.Add(new MailAddress("msdotnettechies@gmail.com"));
 mailMessage.CC.Add(new MailAddress("user1@gmail.com"));
 mailMessage.Bcc.Add(new MailAddress("user2@gmail.com"));
 mailMessage.Subject = "Email Checking Asynchronously";
 mailMessage.Body = "Email test asynchronous";
 mailMessage.IsBodyHtml = true;//to send mail in html or not

 SmtpClient smtpClient = new SmtpClient();//portno here
 smtpClient.Host = "smtp.gmail.com";
 smtpClient.EnableSsl = true ; //True or False depends on SSL Require or not
 smtpClient.Credentials = new NetworkCredential("yourGmail@gmail.com", "yourpassword");
 //smtpClient.UseDefaultCredentials = true; //true or false depends on you want to default credentials or not
 Object mailState = mailMessage;

 //this code adds event handler to notify that mail is sent or not
 smtpClient.SendCompleted += new SendCompletedEventHandler(smtpClient_SendCompleted);
 try
 {
 smtpClient.SendAsync(mailMessage, mailState);
 }
 catch (Exception ex)
 {
 Response.Write(ex.Message);
 Response.Write(ex.StackTrace);
 }

// this is the event called on main method
void smtpClient_SendCompleted(object sender, System.ComponentModel.AsyncCompletedEventArgs e)
 {
 MailMessage mailMessage = e.UserState as MailMessage;
 if (e.Cancelled || e.Error != null)
 {

 Response.Write(e.Error.Message);
 Response.Write(e.Error.StackTrace);
 }
 else
 {
 Response.Write("Email sent successfully");
 }
 } 
 

Ref :  http://jalpesh.blogspot.com/2010/02/how-to-send-mail-asynchronously-in.html

Sams Teach Yourself ASP.NET 3.5 in 24 Hours, Complete Starter Kit How to Train Your DragonHarry Potter Box Set

Logout issue : Copy the URL of the user page and paste user after logout show the page only IE has Issue

Posted by Venkat | Labels: , ,

When i working on the project ,i faced the issue - that i am sharing to u. ex: When the user login in to his account then do some navigation inside User page - at this stage I copied the URL then i Click Logout button. 

Once i logged out if i paste the Copied URL on that page it redirect to the user Page, when i do some navigation (or clicking any button on that page ) its has been redirect to Login page , but this should not occur  like this if i paste the URL it will directly redirect to the Login page only.This issue will not occur on Mozilla , IE 8 version. it occurs only on IE  browser.

Even if  I set the Session on page_load event but no use. So the thing is Cache ie: the page has been cached stored on Client Browser, so we need to disable the cache.

So Add this line on Master Page inside the Head Tag.

 <meta http-equiv="PRAGMA" value="NO-CACHE"></meta>
<meta content="Mon, 01 Jan 1990 12:00:00 GMT" http-equiv="Expires"></meta>



 
 

uploading text and numeric data from an excel file shows NULL Value

Posted by Venkat | Labels: , ,

Good Morning to everyone

I was working with one of the project , where i had the task of uploading excel ie: Read the Excel data to Dataset ie: from DataSet I am going to store the each field value to DB, so the excel sheet may contain numbers ,or string ,.. by default the Excel sheet  accept  the data based on the first rows of excel sheet.

If the first row and first column will be string - so further the whole first rows and first columns accept strings, if there is any Numeric found  on the first rows and first columns it consider as NULL ie: Empty value , as the same for Numeric also so it may also contain alphanumeric on some cells.

So while we read the Excel sheet  these problems are arise. then we tried to select all cell ie: full excel sheet -> Right Click on the Excel sheet - > format Cells - > Choose String - > click ok .Then I upload this Excel sheet to Read the Data.

Why we change the Format cell  to String means if we set it as string it will accept as both numeric , strings , or alphanumeric - so i am going end it up by doing this.

But the problem arises again - it works that time correctly after few day the same problem occurs, then i do some research or googled and came up with a solution :

The short answer is "IMEX=1" 

You have to apply this on Connection String

To connect to an excel file within ADO.NET use the "System.Data.OleDb" provider  a connection string similar to:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source="Sample.xls";Persist Security Info=False;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1" 

 Thanks for All. 

 

window.open method

Posted by Venkat | Labels: , ,

Window.open method in asp.net - this is used in javascript to open a page on new window.
through this you can hide the menubar ,set the width and hieght of the popupwindow,status,toolbar,resizable etc., for this you can either set the value is 0 | 1 or yes | no

Example

window.open('http://msdn.microsoft.com', '', '');");

Suppose if you want to do on code behind check this code :

Here i have mentioned widht , height of the window ,top and left , menubar,toolbar,
location, resizable, scrollbars
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("<script language="javascript">");
sb.Append("window.open('popuop.aspx', 'CustomPopUp',");
sb.Append("'width=1020, height=750, left=0, top=0, menubar=no, toolbar=no, resizable=no, status=no, location=no, scrollbars=yes');<");
sb.Append("/script>");
Type t = this.GetType();
if (!Page.ClientScript.IsStartupScriptRegistered(t, "PopupScript"))
{
     Page.ClientScript.RegisterStartupScript(t, "PopupScript", sb.ToString());
 }


If you want to open a new window through in-line code try this.

   <img border="0" id="img_PopUp" onclick="window.open('../PopUp.aspx','custompopop','width=250,height=300,toolbar=no,menubar=no,statusbar=no,resizable=no,scrollbars=no,location=no, directories=no,copyhistory=no,left=250,top=250')" />
                                runat="server" src="../Images/Newwindow.png" style="width: 35px" />

Reference:


http://dotnetslackers.com/articles/aspnet/JavaScript_with_ASP_NET_2_0_Pages_Part1.aspx

Arithmetic Captcha

Posted by Venkat | Labels: , ,

In this post i am going to show how to work with Arithmetic CAPTCHA. Generally we used , Alpha or alphaNumeric Captcha on most of the site but some site like  ASP.SNIPPETS it shows ARITHMETIC CAPTCHA like 18 + 12 = ? so user have to give correct value then only it proceeds.

Here I am getting help from this site

http://www.knowlegezone.com/documents/80/Simple-ASPNET-CAPTCHA-Tutorial/

Which was in VB.NET so I would like to Written in C#, here I have been posted , On the Above link they used normal ASPX image to Generate the Image ie: 18 + 12 = .

So i written the code on Generic Handler File to improve the site performance.
By default Handler file does not Read or write the value to Session so we have to use like this

using System.Web.SessionState;

public class Captcha : IHttpHandler, IRequiresSessionState


suppose if we are going to read the Session value on HTTP Handler file

using System.Web.SessionState;
public class Captcha : IHttpHandler, IReadOnlySessionState

This is the full code for Captcha.ashx file

<%@ WebHandler Language="C#" Class="Captcha" %>
using System;
using System.Web;
using System.Drawing;
using System.Web.SessionState;
public class Captcha : IHttpHandler, IRequiresSessionState
{
   
    public void ProcessRequest (HttpContext context) {
        //context.Response.ContentType = "text/plain";
        //context.Response.Write("Hello World");
        Random num1 = new Random();
        Random num2 = new Random();
        int numQ1 = 0;
        int numQ2 = 0;
        string QString = null;
        numQ1 = num1.Next(10, 15);
        numQ2 = num1.Next(17, 31);
        QString = numQ1.ToString() + " + " + numQ2.ToString() + " = ";
        int tAnswer = numQ1 + numQ2;
        context.Session["answer"] = tAnswer .ToString ();
        Bitmap bitmap = new Bitmap(85, 25);
        Graphics Grfx = Graphics.FromImage(bitmap);
        Font font = new Font("Arial", 18, FontStyle.Bold, GraphicsUnit.Pixel);
        Rectangle Rect = new Rectangle(0, 0, 100, 25);
        Grfx.FillRectangle(Brushes.Snow, Rect);
        Grfx.DrawRectangle(Pens.White, Rect);
        // Border
        Grfx.DrawString(QString, font, Brushes.Black, 0, 0);
        context.Response.ContentType = "Image/jpeg";
        bitmap.Save(context.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
        bitmap.Dispose();
        Grfx.Dispose();
    }
    public bool IsReusable {
        get {
            return false;
        }
    }
}

Here is the code if you are going to write it on Captcha.aspx page

Explanation was given on Comment itself. Write the below code on Page_Load Event

// Getting Random number
        Random num1 = new Random();
        Random num2 = new Random();

        int numQ1 = 0;
        int numQ2 = 0;
        string QString = null;

        // here we get the random number for the first and second numer - ie: shows the number in between the range.
        numQ1 = num1.Next(10, 15);
        numQ2 = num1.Next(17, 31);

        //Total answer has been  stored it on String and assign to the Session["number"]
        QString = numQ1.ToString() + " + " + numQ2.ToString() + " = ";
        Session["answer"] = numQ1 + numQ2;

        // Here we create  Bitmap width - 85 and height - 25
        Bitmap bitmap = new Bitmap(85, 25);
        Graphics Grfx = Graphics.FromImage(bitmap);

        // Setting the font name, size etc for the text that we have to write it on the image
        Font font = new Font("Arial", 18, FontStyle.Bold, GraphicsUnit.Pixel);

        // Here we specify  a Rectangle object of x , y co-ordinate , with width and height 
        Rectangle Rect = new Rectangle(0, 0, 100, 25);

        //Fill the color to the Rectangle
        Grfx.FillRectangle(Brushes.Snow  ,Rect);

        // Now Using Pen Object Drawing a rectangle
        Grfx.DrawRectangle(Pens.White, Rect);

        // Border - here drawing the string of the num1 and num 2, font size , type etc, font color , and x and y co-ordinate
        Grfx.DrawString(QString, font, Brushes.Black   , 0, 0);
        // Specify the Content type of the image - here i am using JPEG
        Response.ContentType = "Image/jpeg";

        // Save the image and show it on page using response object
        bitmap.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);

        //Dispose the object and release the resources
        bitmap.Dispose();
        Grfx.Dispose();

PayOffers.in