private void btnConvertExcel_Click(object sender, EventArgs e) { //Class.ExportToExcel.Export2Excel(dgvPrintSaleDayExcel); com = new SqlCommand(); com.Parameters.Clear(); com.Parameters.Add("@saleDate", SqlDbType.DateTime).Value = Convert.ToDateTime(saleDate); com.CommandText = strExcelToFormula; com.CommandType = CommandType.Text; com.Connection = Conn; dr = com.ExecuteReader(); DataTable dtFormula = new DataTable(); dtFormula.Load(dr); dtFormula.Columns["ProductId"].ColumnName = "รหัสสินค้า"; dtFormula.Columns["SaleHeadId"].ColumnName = "ใบยืม"; dtFormula.Columns["SaleDetailQuantity"].ColumnName = "จำนวน"; dtFormula.Columns["SaleDetailPriceUnit"].ColumnName = "ราคาขาย"; dtFormula.Columns["Cash"].ColumnName = "ขายสด"; ds = new DataSet(); ds.Tables.Add(dtFormula); dr.Close(); Class.ExportToExcel.Export2Excel(ds); frmCheckSaleDaily frm = new frmCheckSaleDaily(); frm.Close(); }
private void btnConvertExcel_Click(object sender, EventArgs e) { Class.ExportToExcel.Export2Excel(dgvPrintSaleMonthExcel); frmCheckSaleDaily frm = new frmCheckSaleDaily(); frm.Close(); }