C#

from=this.dateTimePicker1.Value.ToString("yyyy/MM/dd"); 
to=this.dateTimePicker2.Value.ToString("yyyy/MM/dd"); 

miss YY wrote:

string str="select * from Furn_Info where Time between ‘"+from+"’
and ‘"+to+"’";

ScottM1 wrote:

put the DateTime object as the parameter value?

class MyForm : Form {
    public MyForm() {
        Button btn=new Button();
        this.Controls.Add(btn);
        btn.Click+=new EventHandler(myClickHandler);
...
        public void myClickHandler(object sender, EventArgs e) {
            // whatever this form wants to happen when the button detects it is being clicked
        }
    }

if (a click got detected) {
    if (this.Click!=null) this.Click(this, new EventArgs()); // execute all the delegates that were
              // added to the Click event
}

<code>
 public static void Main()
    {
        Stock stock1 = new Stock();
        //Add "listener" to you event
        stock1.OnAlert += new Stock.StockPiraceAlertHandler(stock1_OnAlert);
        // test your event by doing this
        stock1.Alert();

    }

     //When the Alert event will be fired, this function will be called.
    static void stock1_OnAlert(object source, StockArgs a)
    {
        // Put your triger logic here
    }
</code>

public static void Main()
{
    Stock stock1 = new Stock();
    stock1.OnAlert += AlertOccured;  // Subscribing event.
    stock1.Alert(); // This will call <code>Alert()</code> method which will trigger <code>OnAlert </code>event.
}

private void AlertOccured(object source, StockArgs a)
{
    // your code.
}

public delegate void ADelegate();
class Foo
{
    public ADelegate ADelegateInstance;

    public void FireADelegate()
    {
        if (ADelegateInstance != null)
            ADelegateInstance();
    }
}

class Program
{
    static void AMethod()
    {
        Console.WriteLine("AMethod()");
    }

    static void Main(string[] args)
    {
        Foo f = new Foo();
        f.ADelegateInstance += AMethod;
        f.ADelegateInstance();   // This is valid and calls AMethod
    }
}

public class Stock {
     
     public event EventHandler<StockArgs> OnAlert;
     public event EventHandler<StockArgs> OnVolumeAlert;

     public void Alert()
     {
         if ( OnAlert != null )
           OnAlert( this, new StockArgs("ORCL", "14.50", 100000) );
     }
}

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

public class FormMain : Form
{
    private IContainer components = null;
    private ContextMenuStrip contextMenuStrip;
    private ToolStripSeparator toolStripSeparator;

    public FormMain()
    {
        InitializeComponent();
    }

    protected override void Dispose(bool disposing)
    {
        if (disposing && (components != null))
        {
            components.Dispose();
        }
        base.Dispose(disposing);
    }

    private void InitializeComponent()
    {
        components = new Container();
        contextMenuStrip = new ContextMenuStrip(components);
        toolStripSeparator = new ToolStripSeparator();

        contextMenuStrip.SuspendLayout();
        SuspendLayout();

        // contextMenuStrip
        contextMenuStrip.Items.AddRange(new ToolStripItem[] {
            toolStripSeparator});

        // FormMain
        AutoScaleDimensions = new SizeF(6F, 13F);
        AutoScaleMode = AutoScaleMode.Font;
        ClientSize = new Size(284, 262);
        ContextMenuStrip = contextMenuStrip;
        Text = "Form Main";

        contextMenuStrip.ResumeLayout(false);
        ResumeLayout(false);
    }
}