protected void view_db_in_grid() { s_without_ext = ""; s_without_ext = Path.GetFileNameWithoutExtension(dbf_filename); /*var datastring = frontlook_csharp_library.data_helper.data_helper1.constring(dbf_filepath); * DataTable dtx = new DataTable(); * try * { * * OleDbConnection connection = new OleDbConnection(datastring); * string sql = "SELECT * FROM " + s_without_ext; * MessageBox.Show(sql + " \n" + datastring+" "+s_without_ext+" "+ dbf_filepath + " "); * OleDbCommand cmd1 = new OleDbCommand(sql, connection); * connection.Open(); * OleDbDataAdapter DA = new OleDbDataAdapter(cmd1); * DA.Fill(dtx); * * //DA.Update(dt); * connection.Close(); * dataGridView1.DataSource = dtx; * //BackgroundWorker bgw = new BackgroundWorker(); * * } * catch (OleDbException e) * { * MessageBox.Show("Error : " + e.Message); * }*/ dataGridView1.DataSource = FL_Dbf_Manager.FL_dbf_datatable(dbf_filepath); }
/*protected void dbf_selection() * { * OpenFileDialog dbfselect = new OpenFileDialog * { * InitialDirectory = @"C:\", * RestoreDirectory = true, * Filter = "DBF files (*.dbf)|*.dbf|All files (*.*)|*.*", * FilterIndex = 1, * Title = "Select DBF File", * CheckFileExists = true, * CheckPathExists= true, * DefaultExt = "dbf", * }; * //dbfselect.ShowDialog(); * * if(dbfselect.ShowDialog() == DialogResult.OK) * { * dataGridView1.DataSource = null; * dataGridView1.Refresh(); * dbf_filepath = dbfselect.FileName; * dbf_filename_withext = Path.GetFileNameWithoutExtension(dbf_filepath)+Path.GetExtension(dbf_filepath); * dbf_filename = Path.GetFileNameWithoutExtension(dbf_filepath); * label2.Text = dbf_filepath + " " +dbf_filename; * panel1.Visible = true; * if (!dbf_to_excel_series_worker.IsBusy) * { * * dbf_to_excel_series_worker.RunWorkerAsync(); * } * //data_to_excel.dbf_to_xls_series(dbf_filepath); * //dbf_file_open(); * } * }*/ protected void try_1() { //query.Text = query1; var v = FL_Dbf_Manager.FL_dbf_datatable(dbf_filepath, query.Text.ToString().Trim()); dataGridView1.DataSource = FL_Dbf_Manager.FL_dbf_datatable(dbf_filepath, query.Text.ToString().Trim()); //dataGridView1.DataSource = /*DataSet all_ds = dbf_helper.get_all_datatable_in_dataset(filePaths); * var a = "SELECT * FROM '" + all_ds + "'.BILLMED"; * all_ds.Tables[0].Select() */ //data_to_excel.FL_data_to_xls(dbf_filepath); //data_to_excel.FL_data_to_xls_multiple_datatable_in_single_excel_file(dbf_filepath); // MessageBox.Show(frontlook_csharp_library.database_helper.database_helper.FL_odbc_execute_command()); /*FileInfo fileInfo = new FileInfo(dbf_filepath); * string directoryFullPath = fileInfo.DirectoryName; * string x = Path.GetDirectoryName(dbf_filepath); * string[] filePaths; * filePaths = Directory.GetFiles(x, "*.dbf"); * foreach(string s in filePaths) * { * MessageBox.Show("Ok"+" "+FL_dbf_helper.get_os()+" "+FL_dbf_helper.constring(dbf_filepath)); * dataGridView1.DataSource = null; * dataGridView1.Refresh(); * dataGridView1.DataSource = FL_dbf_helper.data(s); * * }*/ //view_db_in_grid(); /*Demo*/ /* * using (var report = new Report()) * { * report.Load("report1.frx"); * report.RegisterData(v.DataSet, "NorthWind"); * report.Prepare(true); * PDFSimpleExport export = new PDFSimpleExport(); * * report.Export(export, "result.pdf"); * //report.SavePrepared("a.pdf"); * //report.Save("a.pdf"); * } */ }
public void fast_report() { string query1 = "SELECT " + "smast.SDES as SDES,bill.DT,billmed.VNO,billmed.BATCH,billmed.EXPDT, bill.MPT,aconf.ADD1,aconf.ADD2,aconf.ADD3," + "(SELECT smast.SDES FROM [smast],[bill] WHERE bill.LCOD=smast.SCOD AND bill.VNO='00534' AND bill.MPT='M') AS TRANSPORT_SDES " + "FROM " + "[billmed],[bill],[smast],[aconf] WHERE billmed.VNO = bill.VNO AND bill.SCOD=smast.SCOD AND bill.MPT='M' AND bill.SCOD=aconf.GCOD " + "AND " + "bill.VNO='00534'"; /* * SELECT smast.SDES as SDES,bill.DT,billmed.VNO,billmed.BATCH,billmed.EXPDT, bill.MPT,aconf.ADD1,aconf.ADD2,aconf.ADD3, (SELECT smast.SDES FROM [smast],[bill] WHERE bill.LCOD=smast.SCOD AND bill.VNO='00534' AND bill.MPT='M') AS TRANSPORT_SDES FROM [billmed],[bill],[smast],[aconf] WHERE billmed.VNO = bill.VNO AND bill.SCOD=smast.SCOD AND bill.MPT='M' AND bill.SCOD=aconf.GCOD AND bill.VNO='00534' */ DataSet ds = new DataSet("client_info"); ds.Tables.Add(FL_Dbf_Manager.FL_dbf_datatable(dbf_filepath, query1)); SqlServerTypes.Utilities.LoadNativeAssemblies(AppDomain.CurrentDomain.BaseDirectory); //ReportViewer rv = new ReportViewer(); rv.ShowPrintButton = true; rv.ShowProgress = true; //Report r = new LocalReport(); //r.DisplayName = "BILL"; //rv.LocalReport.DataSources = ds.Tables[0]; }
private void button2_Click(object sender, EventArgs e) { //MessageBox.Show(DateTime.Now.ToString()); //MessageBox.Show("OS Version: "+frontlook_csharp_library.FL_General.FL_Os_Helper.FL_get_os()); dataGridView1.DataSource = ""; if (dbf_filepath.Equals("") || dbf_filepath.Equals(string.Empty)) { dbf_folder_selection(); var v = FL_Dbf_Manager.FL_dbf_datatable(dbf_filepath, query.Text.ToString().Trim()); v.TableName = "Table1"; FL_DataTableToExcel_Helper.FL_DataTableToExcel(v, Path.GetDirectoryName(dbf_filename)); //dataGridView1.DataSource = v; /* * SELECT smast.SDES as SDES,bill.DT,billmed.VNO,billmed.BATCH,billmed.EXPDT, bill.MPT,aconf.ADD1,aconf.ADD2,aconf.ADD3, (SELECT smast.SDES FROM [smast],[bill] WHERE bill.LCOD=smast.SCOD AND bill.VNO='00534' AND bill.MPT='M') AS TRANSPORT_SDES FROM [billmed],[bill],[smast],[aconf] WHERE billmed.VNO = bill.VNO AND bill.SCOD=smast.SCOD AND bill.MPT='M' AND bill.SCOD=aconf.GCOD AND bill.VNO='00534' */ DataSet ds = new DataSet("client_info"); ds.Tables.Add(v); //ReportViewer rv = new ReportViewer(); rv.ShowPrintButton = true; rv.ShowProgress = true; //query.Text = query1; MessageBox.Show(ds.DataSetName); dataGridView1.DataSource = ds.Tables["table1"]; fast_report(); //db_viewer.RunWorkerAsync(); /*using (var report = new Report()) * { * report.Load("report1.frx"); * report.RegisterData(ds, "client_info"); * report.Prepare(true); * PDFSimpleExport export = new PDFSimpleExport(); * * report.Export(export, "result.pdf"); * //report.SavePrepared("a.pdf"); * //report.Save("a.pdf"); * * }*/ } else { /* * SELECT smast.SDES as SDES,bill.DT,billmed.VNO,billmed.BATCH,billmed.EXPDT, bill.MPT,aconf.ADD1,aconf.ADD2,aconf.ADD3, (SELECT smast.SDES FROM [smast],[bill] WHERE bill.LCOD=smast.SCOD AND bill.VNO='00534' AND bill.MPT='M') AS TRANSPORT_SDES FROM [billmed],[bill],[smast],[aconf] WHERE billmed.VNO = bill.VNO AND bill.SCOD=smast.SCOD AND bill.MPT='M' AND bill.SCOD=aconf.GCOD AND bill.VNO='00534' */ var v = FL_Dbf_Manager.FL_dbf_datatable(dbf_filepath, query.Text.ToString().Trim()); v.TableName = "Table1"; FL_DataTableToExcel_Helper.FL_DataTableToExcel(v, Path.GetDirectoryName(dbf_filename)); dataGridView1.DataSource = v; DataSet ds = new DataSet("client_info"); ds.Tables.Add(v); //ReportViewer rv = new ReportViewer(); rv.ShowPrintButton = true; rv.ShowProgress = true; //query.Text = query1; File.WriteAllText("C:\\Users\\deban\\Desktop\\xml.txt", v.DataSet.GetXml()); File.WriteAllText("C:\\Users\\deban\\Desktop\\xml1.txt", v.DataSet.GetXmlSchema()); MessageBox.Show(ds.DataSetName); /*using (var report = new Report()) * { * report.Load("C:\\Users\\deban\\Desktop\\dbtest.frx"); * report.RegisterData(ds, "client_info"); * report.Prepare(true); * PDFSimpleExport export = new PDFSimpleExport(); * * report.Export(export, "C:\\Users\\deban\\Desktop\\result.pdf"); * //report.SavePrepared("a.pdf"); * //report.Save("a.pdf"); * }*/ } /*using (var report = new Report()) * { * report.Load("report1.frx"); * report.RegisterData(t, "NorthWind"); * report.Prepare(true); * PDFSimpleExport export = new PDFSimpleExport(); * * report.Export(export, "result.pdf"); * //report.SavePrepared("a.pdf"); * //report.Save("a.pdf"); * }*/ /* var ci = new CultureInfo("en-IN"); * var cu = CultureInfo.CurrentUICulture.DateTimeFormat.FullDateTimePattern; * var cd = CultureInfo.CurrentCulture.DateTimeFormat.GetAllDateTimePatterns(); * MessageBox.Show(Thread.CurrentThread.CurrentCulture.ToString()); * MessageBox.Show(CultureInfo.CurrentCulture.Name + "1"); * CultureInfo currentCulture = Thread.CurrentThread.CurrentCulture; * var cf_d = currentCulture.DateTimeFormat.ShortDatePattern; * var cf_t = currentCulture.DateTimeFormat.LongTimePattern; * MessageBox.Show(cf_d + " 1 "+cf_t+" 2 "+ currentCulture.DateTimeFormat.FullDateTimePattern+" 3 "+ * currentCulture.DateTimeFormat.SortableDateTimePattern+" 4 "+ currentCulture.DateTimeFormat.LongDatePattern);*/ //MessageBox.Show(DateTime.ParseExact(DateTime.Now.ToString(),cf_d+" "+cf_t,ci,DateTimeStyles.AssumeLocal).ToString()); }