C#

SqlDataAdapter SQL_Adapter;
     DataTable dtReport1 = new DataTable();
     string SQL_Command = "SQL STATEMENT GOES HERE"
     //if (cklbxColumns.Items.Count != 0)
     //{
         SQL_Command += "'" + strExecutive + "', '" + strToolClass + "'";
     //}

     try
     {
         using (SQL_Conn = new SqlConnection(WhatIsTheSQLConnectionString))
         {
             if (SQL_Conn.State != ConnectionState.Open)
             {
                 SQL_Conn.Open();
             }
             else
             {
                 SQL_Conn.Close();
                 SQL_Conn.Open();
             }

             //using (SQL_Adapter = new SqlDataAdapter("SQL STATEMENT GOES HERE", SQL_Conn))
             using (SQL_Adapter = new SqlDataAdapter(SQL_Command, SQL_Conn))
             {
                 // Use DataAdapter to fill DataTable

                 SQL_Adapter.Fill(dtReport1);
                 // 4
                 // Render data onto the screen
                 // dgvReport = DataGridViewer
                 dgvReport.DataSource = dtReport1;
                 //dgvReport.DataMember = "dtToolStatusboardReport";
                 dgvReport.Refresh();
                 gbToolStatusBoard.Refresh();
                 //ActiveForm.Refresh();
             }
             SQL_Adapter.Dispose();
         }
         SQL_Conn.Close();
     }
     catch
     { return; }

String strIndex = "12";
Int32 nIndex = Convert.ToInt32(strIndex);

void ctrl_Click(object sender, EventArgs e)
{
    Control contol = sender as Control;

    if (control != null)
    {
        string name = control.Name;
    }
}

if (sender is TextBox) log("this is a TextBox");
// or
TextBox tb=sender as TextBox;
if (tb!=null) log("this is a TextBox");

foreach (Control candidate in Controls)
{
    if(candidate is TextBox) // assign your event handler here
}

dirSec.AddAccessRule(new FileSystemAccessRule(IdentityReference, FileSystemRights.WriteData,
 InheritanceFlags.ObjectInherit, PropagationFlags.InheritOnly, AccessControlType.Allow));