public override void PopulateData() { try { using (TaxiDataContext db = new TaxiDataContext()) { var list = db.stp_IncomeStatement().ToList(); grdLister.DataSource = list; } grdLister.Columns["Id"].IsVisible = false; grdLister.Columns["DriverName"].IsVisible = false; grdLister.Columns["DriverNo"].HeaderText = "Driver"; grdLister.Columns["NetTotal"].HeaderText = "Net Total"; grdLister.Columns["AccountBookings"].HeaderText = "Account Bookings"; grdLister.Columns["OfficeToPay"].HeaderText = "Office To Pay"; grdLister.Columns["DriverToPay"].HeaderText = "Driver To Pay"; grdLister.Columns["AccountBookings"].HeaderText = "Account Bookings"; grdLister.Columns["DriverNo"].Width = 160; grdLister.Columns["AccountBookings"].Width = 130; grdLister.Columns["Balance"].Width = 130; grdLister.Columns["DriverToPay"].Width = 130; grdLister.Columns["NetTotal"].Width = 130; grdLister.Columns["Rent"].Width = 130; grdLister.Columns["OfficeToPay"].Width = 130; grdLister.Columns["BalanceBF"].HeaderText = "Balance B/F"; grdLister.Columns["BalanceBF"].Width = 130; //grdLister.Columns["DriverNo"].Width = 120; //Active } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverNo", "DriverNo")); radGridView1.Columns.Add(new GridViewTextBoxColumn("NetTotal", "NetTotal")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Rent", "Rent")); radGridView1.Columns.Add(new GridViewTextBoxColumn("AccountBookings", "AccountBookings")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Balance", "Balance")); radGridView1.Columns.Add(new GridViewTextBoxColumn("OfficeToPay", "OfficeToPay")); radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverToPay", "DriverToPay")); radGridView1.Columns.Add(new GridViewTextBoxColumn("BalanceBF", "BalanceBF")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Total", "Total")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Active", "Active")); //this.radGridView1.Columns["Telephone"].ExcelExportType = Telerik.WinControls.UI.Export.DisplayFormatType.Text; //this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom; // radGridView1.DataSource = query; using (TaxiDataContext db = new TaxiDataContext()) { var list = db.stp_IncomeStatement().ToList(); // grdLister.DataSource = list; radGridView1.RowCount = list.Count; for (int i = 0; i < list.Count; i++) { radGridView1.Rows[i].Cells["DriverNo"].Value = list[i].DriverNo; radGridView1.Rows[i].Cells["NetTotal"].Value = list[i].NetTotal; radGridView1.Rows[i].Cells["Rent"].Value = list[i].Rent; radGridView1.Rows[i].Cells["AccountBookings"].Value = list[i].AccountBookings; radGridView1.Rows[i].Cells["Balance"].Value = list[i].Balance; radGridView1.Rows[i].Cells["OfficeToPay"].Value = list[i].OfficeToPay; radGridView1.Rows[i].Cells["DriverToPay"].Value = list[i].DriverToPay; radGridView1.Rows[i].Cells["BalanceBF"].Value = list[i].BalanceBF; // radGridView1.Rows[i].Cells["Telephone"].ViewInfo.; //radGridView1.Rows[i].Cells["Telephone"].Value = (radGridView1.Rows[i].Cells["Telephone"].Value.ToString().Replace(".", "")); } } // this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Fixed; //this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom; ExportToExcelML export = new ExportToExcelML(this.radGridView1); export.ExportVisualSettings = true; export.HiddenColumnOption = HiddenOption.ExportAsHidden; export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting); // // //radGridView1.Columns["DriverNo"].HeaderText = "Driver No"; //radGridView1.Columns["AccountBookings"].HeaderText = "Account Bookings"; //radGridView1.Columns["OfficeToPay"].HeaderText = "Office To Pay"; //radGridView1.Columns["BalanceBF"].HeaderText = "Balance B/F"; //radGridView1.Columns["DriverToPay"].HeaderText = "Driver To Pay"; radGridView1.Columns["DriverNo"].HeaderText = "Driver"; radGridView1.Columns["AccountBookings"].HeaderText = "A/C Bookings"; radGridView1.Columns["OfficeToPay"].HeaderText = "Office To Pay"; radGridView1.Columns["BalanceBF"].HeaderText = "Blnc B/F"; radGridView1.Columns["DriverToPay"].HeaderText = "Drv To Pay"; // //CompanyName exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }