Hello Guru's
i was trying to export Excel from my DataGrid,found this example in microsoft and implement in my button click.
But not sure how to call my data set here.
private void button1_Click(object sender, System.EventArgs e)
{
Excel.Application oXL;
Excel._Workbook oWB;
Excel._Worksheet oSheet;
Excel.Range oRng;
FillExcel();
try
{
oXL = new Excel.Application();
oXL.Visible = true;
oWB = (Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
oSheet = (Excel._Worksheet)oWB.ActiveSheet;
oSheet.Cells[1, 1] = "No";
oSheet.Cells[1, 2] = "Message ID";
oSheet.get_Range("A1", "C1").Font.Bold = true;
oSheet.get_Range("A1", "C1").VerticalAlignment =
Excel.XlVAlign.xlVAlignCenter;
string[,] saNames = new string[5, 2];
saNames[0, 1] = "Smith";
saNames[1, 0] = "Tom";
oSheet.get_Range("A2", "B6").Value2 = saNames;
oRng = oSheet.get_Range("C2", "C6");
oRng.Formula = "=A2 & \" \" & B2";
oRng = oSheet.get_Range("D2", "D6");
oRng.Formula = "=RAND()*100000";
oRng.NumberFormat = "$0.00";
oRng = oSheet.get_Range("A1", "C1");
oRng.EntireColumn.AutoFit();
oXL.Visible = true;
oXL.UserControl = true;
}
private void loadPage()
{
string strSql = "";
int intSkip = 0;
intSkip = (this.mintCurrentPage * this.mintPageSize);
string ItemList = SearchList.SelectedItem.ToString();
if (ItemList == "ALL")
{
strSql = "SELECT Top " + this.mintPageSize +
" * FROM tblTraceMessages WHERE MessageId NOT IN " +
"(SELECT TOP " + intSkip + " ID FROM tblTraceMessages)";
}
SqlCommand cmd = this.mcnSample.CreateCommand();
cmd.CommandText = strSql;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "tblTraceMessages");
this.dgEmp.DataSource = ds.Tables["tblTraceMessages"].DefaultView;
this.lblStatus.Text = (this.mintCurrentPage + 1).ToString() + " / " + this.mintPageCount.ToString();
cmd.Dispose();
da.Dispose();
ds.Dispose();