private void Form1_Load(object sender, EventArgs e) { string appPath2 = Path.GetDirectoryName(Application.ExecutablePath); ///create the connection string string connString = @"Data Source= " + appPath2 + @"\DBpinc.s3db ;Version=3;"; //create the database query string query = "SELECT * FROM Ventas"; //create an OleDbDataAdapter to execute the query System.Data.SQLite.SQLiteDataAdapter dAdapter = new System.Data.SQLite.SQLiteDataAdapter(query, connString); //create a command builder System.Data.SQLite.SQLiteCommandBuilder cBuilder = new System.Data.SQLite.SQLiteCommandBuilder(dAdapter); //create a DataTable to hold the query results DataTable dTable = new DataTable(); //fill the DataTable dAdapter.Fill(dTable); dAdapter.Update(dTable); if (dTable.Rows.Count != 0) { DataRow Row = dTable.Rows[dTable.Rows.Count - 1]; string num = Row["NVenta"].ToString(); int autonum = Int32.Parse(num); textBox1.Text = (autonum + 1).ToString(); } else { textBox1.Text = "1"; } try { Sistema_Caritas.ConvertidorMonetario.CurrencyConvertor CC = new Sistema_Caritas.ConvertidorMonetario.CurrencyConvertor(); label21.Text = CC.ConversionRate(Sistema_Caritas.ConvertidorMonetario.Currency.USD, Sistema_Caritas.ConvertidorMonetario.Currency.MXN).ToString(); } catch { comboBox1.Visible = false; label20.Visible = false; label21.Visible = false; button5.Visible = false; } timer1.Enabled = true; }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { Sistema_Caritas.ConvertidorMonetario.CurrencyConvertor CC = new Sistema_Caritas.ConvertidorMonetario.CurrencyConvertor(); if (comboBox1.SelectedIndex == 0) { label21.Text = CC.ConversionRate(Sistema_Caritas.ConvertidorMonetario.Currency.USD, Sistema_Caritas.ConvertidorMonetario.Currency.MXN).ToString(); } else if (comboBox1.SelectedIndex == 1) { label21.Text = CC.ConversionRate(Sistema_Caritas.ConvertidorMonetario.Currency.EUR, Sistema_Caritas.ConvertidorMonetario.Currency.MXN).ToString(); } else if (comboBox1.SelectedIndex == 2) { label21.Text = CC.ConversionRate(Sistema_Caritas.ConvertidorMonetario.Currency.GBP, Sistema_Caritas.ConvertidorMonetario.Currency.MXN).ToString(); } else if (comboBox1.SelectedIndex == 3) { label21.Text = CC.ConversionRate(Sistema_Caritas.ConvertidorMonetario.Currency.ARS, Sistema_Caritas.ConvertidorMonetario.Currency.MXN).ToString(); } else if (comboBox1.SelectedIndex == 4) { label21.Text = CC.ConversionRate(Sistema_Caritas.ConvertidorMonetario.Currency.PEN, Sistema_Caritas.ConvertidorMonetario.Currency.MXN).ToString(); } else if (comboBox1.SelectedIndex == 5) { label21.Text = CC.ConversionRate(Sistema_Caritas.ConvertidorMonetario.Currency.CAD, Sistema_Caritas.ConvertidorMonetario.Currency.MXN).ToString(); } else if (comboBox1.SelectedIndex == 6) { label21.Text = CC.ConversionRate(Sistema_Caritas.ConvertidorMonetario.Currency.COP, Sistema_Caritas.ConvertidorMonetario.Currency.MXN).ToString(); } else if (comboBox1.SelectedIndex == 7) { label21.Text = CC.ConversionRate(Sistema_Caritas.ConvertidorMonetario.Currency.CUP, Sistema_Caritas.ConvertidorMonetario.Currency.MXN).ToString(); } } catch { } }
private void Form1_Load(object sender, EventArgs e) { string appPath2 = Path.GetDirectoryName(Application.ExecutablePath); ///create the connection string string connString = @"Data Source= " + appPath2 + @"\DBpinc.s3db ;Version=3;"; //create the database query string query = "SELECT * FROM Ventas"; //create an OleDbDataAdapter to execute the query System.Data.SQLite.SQLiteDataAdapter dAdapter = new System.Data.SQLite.SQLiteDataAdapter(query, connString); //create a command builder System.Data.SQLite.SQLiteCommandBuilder cBuilder = new System.Data.SQLite.SQLiteCommandBuilder(dAdapter); //create a DataTable to hold the query results DataTable dTable = new DataTable(); //fill the DataTable dAdapter.Fill(dTable); dAdapter.Update(dTable); if (dTable.Rows.Count != 0) { DataRow Row = dTable.Rows[dTable.Rows.Count-1]; string num = Row["NVenta"].ToString(); int autonum = Int32.Parse(num); textBox1.Text = (autonum + 1).ToString(); } else { textBox1.Text = "1"; } try { Sistema_Caritas.ConvertidorMonetario.CurrencyConvertor CC = new Sistema_Caritas.ConvertidorMonetario.CurrencyConvertor(); label21.Text = CC.ConversionRate(Sistema_Caritas.ConvertidorMonetario.Currency.USD, Sistema_Caritas.ConvertidorMonetario.Currency.MXN).ToString(); } catch { comboBox1.Visible = false; label20.Visible = false; label21.Visible = false; button5.Visible = false; } timer1.Enabled = true; }