C#

select userId from [Users] where userName = theUsername;

dataSet.Table[0].Rows.Count > 0

Microsoft.Office.Interop.Excel._Application _appClass = new ApplicationClass();<br />
_appClass.Visible = true;<br />
_appClass.Caption = "Excel custom title";<br />
Microsoft.Office.Interop.Excel.Workbook wbk = _appClass.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);<br />
Worksheet obj = (Worksheet)wbk.ActiveSheet;<br />
//Range r = (Range)obj.Cells[this.lsvDocumentList.Items.Count + 1, ((GridView)this.lsvDocumentList.View).Columns.Count + 1];<br />
Range r = (Range)obj.Cells;<br />
for (int i = 0; i < ((GridView)this.lsvDocumentList.View).Columns.Count; i++)<br />
{<br />
    r[1, i + 1] = ((GridView)this.lsvDocumentList.View).Columns[i].Header.ToString();<br />
    ((Range)r.Cells[1, i + 1]).Font.Bold = true;<br />
}

<br />
for (int i = 0; i < ((DataGridView)this.dgOutput).Columns.Count; i++)<br />
{<br />
r[1, i + 1] = ((DataGridView)this.dgOutput).Columns[i].HeaderText.ToString();<br />
((Range)r.Cells[1, i + 1]).Font.Bold = true;<br />
} <br />

//Write Header Record
StreamWriter sw = new StreamWriter(@"C:\EPORT\ExportFile_" + DateTime.Today.ToString("ddMMyyyy") + ".csv", false);
DataTable dt = m_dtMobEmail;
int iColCount = dt.Columns.Count;
for (int i = 0; i < iColCount; i++)
{
    sw.Write(@"""{0}""", dt.Columns[i]);
    if (i < iColCount - 1)
    {
        sw.Write(",");
    }
}
sw.Write(sw.NewLine);

//Write all records in the DB
foreach (DataRow dr in dt.Rows)
{
    //Search for all Records with value 0
    if (dr["Exported"].ToString() == "0")
    {
        for (int i = 0; i < iColCount; i++)
        {
            if (!Convert.IsDBNull(dr[i]))
            {
                sw.Write(@"""{0}""", dr[i].ToString());
            }
            if (i < iColCount - 1)
            {
                sw.Write(",");
            }
        }
        sw.Write(sw.NewLine);
    }
}

sw.Close();