Database

SqlCommand MyCommand = new SqlCommand("SELECT First_Name, Last_Name, Grid_Square, Country, State, Call_Sign, Date_Time, Mode, Power FROM clouddata WHERE First_Name = @First_Name", conn);
MyCommand.Parameters.AddWithValue("@First_Name", searchOut);

private void button1_Click(object sender, EventArgs e)
  {
      if (cmbColumns.SelectedIndex == -1)
      {
          MessageBox.Show("You must select a column");
          return;
      }
      if (string.IsNullOrEmpty(tbSearch.Text))
      {
          MessageBox.Show("You must enter a value to search for");
          return;
      }

      // This bit would NOT normally be within the UI layer
      var conString = ConfigurationManager.ConnectionStrings["ConnectToDB"].ConnectionString;
      using (SqlConnection conn = new SqlConnection(conString))
      {
          conn.Open();
          using (var myCommand = new SqlCommand())
          {
              myCommand.Connection = conn;
              var sb = new StringBuilder(
                  "SELECT First_Name, Last_Name, Grid_Square, Country, State, Call_Sign, Date_Time, Mode, Power ");
              sb.Append("FROM clouddata WHERE ");
              sb.Append(cmbColumns.SelectedItem);
              sb.Append("=@searchValue");
              myCommand.CommandText = sb.ToString();
              myCommand.Parameters.AddWithValue("@searchValue", tbSearch.Text);

              using (var adapter = new SqlDataAdapter(myCommand))
              {
                  var myTable = new DataTable();
                  adapter.Fill(myTable);
                  dataGridView1.DataSource = myTable;
              }
          }
      }
  }

SELECT * FROM
 (
	SELECT C.ClientID, ClientName, StatusDescription, 
	CASE WHEN SM.StatusID IS NOT NULL THEN 'Y' ELSE 'N' END AS Actual
	FROM @Clients C
	LEFT OUTER JOIN @Statuses S ON C.ClientID = S.ClientID
	LEFT OUTER JOIN @StatusMappings SM on SM.StatusID = S.StatusID
) qry
PIVOT 
(
	MAX(Actual) FOR StatusDescription in ([Draft Letter],[Awaiting Response],[Complete])
) pvt
WHERE ClientName = 'Barclays'

EXTRACT(MONTH FROM VISIT_DATE) AS DAY_

EXTRACT(DAY FROM VISIT_DATE) AS DAY_

SELECT SUM(VISIT_FEE) AS FEE,
    EXTRACT(YEAR FROM VISIT_DATE) AS YEAR_,
    EXTRACT(MONTH FROM VISIT_DATE) AS MONTH_,
    EXTRACT(DAY FROM VISIT_DATE) AS DAY_
FROM MZS_VISIT_REQUEST
WHERE IS_PAY = 1
GROUP BY EXTRACT(YEAR FROM VISIT_DATE),
    EXTRACT(MONTH FROM VISIT_DATE) ,
    EXTRACT(DAY FROM VISIT_DATE)