C#

private void SearchBtn_Click(object sender, EventArgs e) {
  DoTask(HostTextBox.Text);
}

private void OpenFileMenuItem_Click(object sender, EventArgs e) {
  OpenFileDialog fdlg = new OpenFileDialog();
  fdlg.Title = "Load machines to search";
  fdlg.InitialDirectory = @"c:\";
  fdlg.Filter = "Text files (*.txt)|*.txt|All files (*.*)|*.*";
  fdlg.FilterIndex = 2;
  fdlg.RestoreDirectory = true;
  if (fdlg.ShowDialog() == DialogResult.OK) {
    // get machine names from text file
    string[] machineNames = System.IO.File.ReadAllLines(fdlg.FileName);
    foreach (string hostname in machineNames) {
      // query one host
      DoTask(hostname);
      // allow the UI to update
      Application.DoEvents();
    }
  }
}

Vivek Vijayan wrote:

how to close a form and navigate to another form

void MyCommonFunction()
{
  ...
}

void PictureClick_Event(o as object, e as EventArgs)
{
  MyCommonFunction();
}

void ButtonClick_Event(o as object, e as EventArgs)
{
  MyCommonFunction();
}

pictureclick_event()
{
    MySexyButton.PerformClick();
}

CREATE PROCEDURE Sample
AS
BEGIN
  select * from table1;
  select * from table2;
END

DataTable dt0 = ds.Tables[0]; // first result set from the batch queries
DataTable dt1 = ds.Tables[1];  // second result set from the batch queries

sda.Fill(ds);
ds.Tables[0].TableName = "tableNameIsAMust.";
ds.Tables[1].TableName = "somethingElse";

da1.Fill(ds, "Table1");
da2.Fill(ds, "Table2");