private void button3_Click(object sender, EventArgs e) { DataSet ds = db.GetTableData("select * from VEW_BILL_REGISTER where invoice_date between '" + DtpFrm.Value.ToString("dd-MMM-yy") + "' and '" + DtpTo.Value.ToString("dd-MMM-yy") + "'"); dataGridView1.DataSource = ds.Tables[0]; db.ExportToExcel(dataGridView1); }
private void button2_Click(object sender, EventArgs e) { db.ExportToExcel(DgvList); }