C#

public delegate void SetLabel(Control lblctrl, string filename);

private void setFilename(Control lblctrl, string filename)
{
    if (this.WindowState == FormWindowState.Minimized)
        return;
    if (lblctrl.InvokeRequired)
        lblctrl.BeginInvoke(new SetLabel(setFilename),
            new object[] { lblctrl, filename });
    else
        lblctrl.Text = filename;
}

foreach (string str2 in Directory.GetFiles(path))
{
    setFilename(this.lblFileName, str2);

int a=5;
int b=5;
MessageBox.Show(a==5?"a is equal to b":"a is not equal to b");

string value = GetValueFromDatabase() ?? GetValueFromConfigFile() ?? "None Selected";

SqlConnection cn = new SqlConnection("server=.;uid=sa;pwd=sa;database=Payroll1");
string ssql = "Select * from EmpDetails";
SqlDataAdapter da = new SqlDataAdapter(ssql, cn);
DataSet ds = new DataSet();

try 
{ 
cn.open();
da.Fill(ds);
BindingSource bindgrd = new BindingSource(); 
bindgrd.DataSource = ds;

if(ds.Tables[0].Rows.count > 0)
{
this.Datagridview1.DataSource = bindgrd; 
}
else
{
lblError.text = "No Rows Returned";
}
catch(SQlException ex)
{
lblError.text = ex.Message;
}
Finaly
{
cn.close();
}

SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlConnection();
cmd.CommandText ="your query";
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
datagridview1.DataSource = ds;