C#

string path = @"D:\Test";

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Linq;
using System.ServiceProcess;
using System.Text;
using System.Configuration;

namespace FileTransfer
{
    public partial class Service1 : ServiceBase
    {
        public Service1()
        {
            InitializeComponent();
        }

        protected override void OnStart(string[] args)
        {
            try
            {
                FileTransferWatcher.Created += new System.IO.FileSystemEventHandler(FileTransferWatcher_Created);
            }
            catch (Exception ex)
            {
                EventLog.WriteEntry("Message :  " + ex.Message);
            }
        }

        void FileTransferWatcher_Created(object sender, System.IO.FileSystemEventArgs e)
        {
            System.IO.File.Copy(e.FullPath, @"D:\");
        }

        protected override void OnStop()
        {
        }
    }
}

namespace FileTransfer
{
    partial class Service1
    {
        /// <summary> 
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components;

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Component Designer generated code

        /// <summary> 
        /// Required method for Designer support - do not modify 
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.FileTransferWatcher = new System.IO.FileSystemWatcher();
            // 
            // FileTransferWatcher
            // 
            this.FileTransferWatcher.EnableRaisingEvents = true;
            this.FileTransferWatcher.Path = "D:\\Test\\";
            // 
            // Service1
            // 
            this.ServiceName = "FileTransfer";

        }

        #endregion

        private System.IO.FileSystemWatcher FileTransferWatcher;
    }
}

void FileTransferWatcher_Created(object sender, System.IO.FileSystemEventArgs e)
        {
            System.IO.File.Copy(e.FullPath, @"D:\");
        }
/pre>

Are you copying a file to your observed directory when you register the handler?

Company Name
News and the latest updates
RSS Version: 2.0
Feed Updated: Thu, 17 Aug 2000 23:32:32 GMT

Some Title: Some description
Published: Thu, 27 Apr 2006

yadlaprasad wrote:

so, i used string.Format(sql,searchvalue),

SqlCommand cmd = new SqlCommand("SELECT * FROM xyz WHERE column1=@SV");
cmd.Parameters.AddWithValue("@SV", searchvalue);