C#

using System;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace RectMove {
	public partial class Form1 : Form {
		Rect rect;
		bool m_mouseDown = false;
		Rect movingRect = null;
		Point prevMouseLoc;


		public Form1() {
			InitializeComponent();
			this.DoubleBuffered = true;
		}

		private void Form1_Load(object sender, EventArgs e) {
			rect = new Rect(200, 100, 100, 50);
		}

		private void panel1_Paint(object sender, PaintEventArgs e) {
			Graphics g = e.Graphics;
			rect.Paint(g);
		}

		private void panel1_MouseDown(object sender, MouseEventArgs e) {
			m_mouseDown = true;
			prevMouseLoc = e.Location;
		}

		private void panel1_MouseUp(object sender, MouseEventArgs e) {
			m_mouseDown = false;
		}

		private void panel1_MouseMove(object sender, MouseEventArgs e) {
			if (m_mouseDown) {
				if (movingRect != null) {
					Point mouseLoc = e.Location;
					movingRect.Move(prevMouseLoc, mouseLoc);
					prevMouseLoc = mouseLoc;
					Invalidate(true);
				}
			} else {
				movingRect = null;
				if (rect.Contains(e.Location)) movingRect = rect;
			}
			Console.WriteLine("movingRect=" + movingRect);
		}
	}

public class Rect {
    private static Pen pen=Pens.Red;
    private Rectangle rect;

    public Rect(int x, int y, int w, int h) {
        rect = new Rectangle(x, y, w, h);
    }

    public override string ToString() {
        return "Rect" + rect.Location+rect.Size.ToString();
    }

    public void Move(Point oldLoc, Point newLoc) {
        rect.X += newLoc.X - oldLoc.X;
        rect.Y += newLoc.Y - oldLoc.Y;
    }

    public bool Contains(Point pt) {
        return rect.Contains(pt);
    }

    public void Paint(Graphics g) {
        g.DrawRectangle(pen, rect);
    }
}

public partial class Form3 : Form
{
    Rectangle rect;
    Point StartXY;
    Point EndXY;

    int x = 0;
    int y = 0;
    int height = 0;
    int width = 0;

    bool m_mouseDown = false;
    bool m_movingRect = false;


    Pen rectPen = new Pen(Color.Red, 1);

    public Form3()
    {
        InitializeComponent();
        this.DoubleBuffered = true;
    }

    private void pictureBox1_Paint(object sender, PaintEventArgs e)
    {
        Graphics gObj = e.Graphics;

        rect = new Rectangle(x, y, height, width);
        rectPen.DashStyle = DashStyle.Dash;
        gObj.DrawRectangle(rectPen, rect);
    }

    private void pictureBox1_MouseDown(object sender, MouseEventArgs e)
    {
        m_mouseDown = true;

        // Moving rectangle
        if (rect.Contains(e.Location))
        {
            m_movingRect = true;
            Console.WriteLine("m_mouseDown");
        }

        StartXY = e.Location;
    }

    private void pictureBox1_MouseMove(object sender, MouseEventArgs e)
    {
        if (rect.Contains(e.Location))
            this.Cursor = Cursors.SizeAll;
        else
            this.Cursor = Cursors.Default;

        if (m_mouseDown && rect.Contains(e.Location))
        {
            rect.X += e.X - StartXY.X;    // <---- it is calculated correctly but doesn't update rectangle position
            rect.Y += e.Y - StartXY.Y;


            StartXY = e.Location;
            Console.WriteLine("pictureBox1_MouseMove StartXY " + StartXY.X);
            Console.WriteLine("pictureBox1_MouseMove StartXY " + StartXY.Y);
            Console.WriteLine("pictureBox1_MouseMove rect " + rect.X);
            Console.WriteLine("pictureBox1_MouseMove rect " + rect.Y);
        }

        if (m_mouseDown && !rect.Contains(e.Location))
        {
            EndXY = e.Location;

            x = Math.Min(StartXY.X, EndXY.X);
            y = Math.Min(StartXY.Y, EndXY.Y);

            height = Math.Abs(StartXY.X - EndXY.X);
            width = Math.Abs(StartXY.Y - EndXY.Y);
            //Console.WriteLine("pictureBox1_MouseMove XXXX: " + " --- " + e.X.ToString());
            //Console.WriteLine("pictureBox1_MouseMove YYYY: " + " --- " + e.Y.ToString());
        }

        Invalidate(true);
    }

    private void pictureBox1_MouseUp(object sender, MouseEventArgs e)
    {
        if (!m_movingRect)
        {
            EndXY = e.Location;
        }

        m_mouseDown = false;
        m_movingRect = false;

        Invalidate();
    }
}

cmd.CommandText = @"update  TabFx  set Ferx =@fer, Descrip=@descr where Ferx="
             + Convert.ToDateTime(DGV1.SelectedRows[0].Cells[0].Value);

CommandText = "... WHERE Ferx=@Ferx";
...
cmd.Parameters.AddWithValue("@Ferx", Convert.ToDateTime(DataGridView1.SelectedRows[0].Cells[0].Value));

Sriram Valluri wrote:

WinSCP directory

  // Setup session options
                SessionOptions sessionOptions = new SessionOptions
                {
                    Protocol = Protocol.Sftp,
                    HostName = "ap*****",
                    UserName = "****",
                    Password = "******",
                    SshHostKeyFingerprint = "*******"
                };

                using (Session session = new Session())
                {
                    // Connect

                    session.ExecutablePath = @"WinSCP.exe path";

                    session.Open(sessionOptions);


                    List<RemoteFileInfo> files =
       session.EnumerateRemoteFiles(
           MonitorDirectory, FileSearchPattern, EnumerationOptions.None)
           .ToList();

                    DateTime now = DateTime.Today;

                    ReportMonth = now.ToString("MMM").ToUpper();

foreach (RemoteFileInfo fileInfo in files)
    {

------------------------------have to do renaming of the file here---------------------------

          if (fileInfo.FullName.Contains(GetClientID))
              {
                   if (fileInfo.Length > ThresholdValue)
                      {
          FileModifiedDate = fileInfo.LastWriteTime.ToString("yyyyMM", CultureInfo.InvariantCulture);

              if (GetReportDateYM == FileModifiedDate || fileInfo.FullName.Contains(ReportMonth))
                                {
                                    FileName = fileInfo.FullName;



                                    Dts.Variables["User::FileName"].Value = FileName;
                                    Dts.Variables["User::FileDate"].Value = FileModifiedDate;
                                    Dts.TaskResult = (int)ScriptResults.Success;
                                    break;
                                }

                            }


                        }