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());
}
