C#

SELECT * FROM tablename WHERE dateFieldName='2009-10-27'
SELECT * FROM tablename WHERE dateFieldName=#2009-10-27#
SELECT * FROM tablename WHERE dateFieldName=`2009-10-27`

Form2 qForm = new Form2();
if( qForm.ShowDialog() == DialogResults.OK )
{
   // Valid, now do something
}

public void button1_Click(object sender, System.EventArgs e)
{
   if(string.IsNullOrEmpty(CaseNo) || string.IsNullOrEmpty(Reason) )
   {
       MessageBox(...);
   }
   else
   {
      DialogResult = DialogResult.OK;
      Close();
   }
}

JTRizos wrote:

what would cause Form2 to be redisplayed after pressing OK or Cancel?

Form2 qForm = new Form2();
qForm.ShowDialog();

if (qForm.ShowDialog ()== DialogResult.OK)

Form f = new Form();<br />
f.Location = new Point(100, 100);<br />
f.Size = new Size(300, 300);<br />
f.Text = "Form 2";

if (TextBox.Text == null)<br />
{<br />
   //Tell user he has to fill it.<br />
}<br />
<br />
if (TextBox.Text != null)<br />
{<br />
   //Do something with the text.<br />
}

if (TextBox.Text == null)
{
//Tell user he has to fill it.
}

if (TextBox.Text != null)
{
//Do something with the text.
}

_Madmatt wrote:

Maybe you can create your whole "Form2" by codig

_Madmatt wrote:

That will be much easier

Mark Nischalke wrote:

Really? How so?

_Madmatt wrote:

Maybe you can create your whole "Form2" by codig? That will be much easier

_Madmatt wrote:

Are you going to tell me you don't know how to make a control in the codebehind?

{
MessageBox.Show("The Last Name and First Name are required!!");
return;
}
//  Above code handles Form1 textboxes


//Call Form2 for CaseNo and Reason data
GetForm2();
...
...

// Opens second Diaolog form (Form2) to get Case Number and Reason
  public void GetForm2()
  {
      Form2 qForm = new Form2();
      qForm.ShowDialog();

      if (qForm.ShowDialog()== DialogResult.OK)
      {
          CaseNo = qForm.CaseNo;
          Reason = qForm.Reason;
          MessageBox.Show("Form2 Exists" + " " + CaseNo + "  " + Reason);
      }
      qForm.Dispose();
  }

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

namespace DMV_Test_1
{
    public partial class Form2 : Form
    {
        public Form2()
        {
                InitializeComponent();
        }

        public string CaseNo
        {
            get { return textBox1.Text; }
        }
        public string Reason
        {
            get { return textBox2.Text; }
        }
        
   
        private void button1_Click(object sender, System.EventArgs e)
        {
            if (CaseNo == "")
            {
                MessageBox.Show("The Case No is required!!");
                this.textBox1.Focus();
                return;
            }

            else
            if (Reason == "")
            {
                MessageBox.Show("The Reason is required!!");
                this.textBox2.Focus();
                return;
            }
            else
            {
                this.DialogResult = DialogResult.OK; Close();
            }  
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.DialogResult = DialogResult.Cancel;    Close();
        }
    }
}

public void GetForm2()
{
  Form2 qForm = new Form2();
  qForm.ShowDialog(); <---- Form2 opened. Not needed

  if (qForm.ShowDialog()== DialogResult.OK) <------ Form 2 opened again
  {
    CaseNo = qForm.CaseNo;
    Reason = qForm.Reason;
    MessageBox.Show("Form2 Exists" + " " + CaseNo + "  " + Reason);
  }
  qForm.Dispose(); <----- Not needed
}