private void ActcboTasasCambio() { l_tasascambiodolar tasascambio = new l_tasascambiodolar(); DataTable dt1 = new DataTable(); dt1 = tasascambio.select("1 order by id desc"); cboTasasCambio.DataSource = dt1; }
private void ConfigForm() { this.dtItems.Columns.Add("codprod", typeof(string)); this.dtItems.Columns.Add("descrip", typeof(string)); this.dtItems.Columns.Add("refere", typeof(string)); this.dtItems.Columns.Add("marca", typeof(string)); this.dtItems.Columns.Add("costact", typeof(decimal)); this.dtItems.Columns.Add("costant", typeof(decimal)); this.dtItems.Columns.Add("precio1", typeof(decimal)); this.dtItems.Columns.Add("precio2", typeof(decimal)); this.dtItems.Columns.Add("precio3", typeof(decimal)); this.dtItems.Columns.Add("existen", typeof(decimal)); this.dtItems.Columns.Add("fechauv", typeof(DateTime)); this.dtItems.Columns.Add("fechauc", typeof(DateTime)); this.dtItems.Columns.Add("sj_selec", typeof(bool)); this.dtItems.Columns.Add("sj_tasacambio", typeof(decimal)); this.dtItems.Columns.Add("sj_costodolar", typeof(decimal)); this.dtItems.Columns.Add("sj_p1dolar", typeof(decimal)); this.dtItems.Columns.Add("sj_p2dolar", typeof(decimal)); this.dtItems.Columns.Add("sj_p3dolar", typeof(decimal)); this.dtItems.Columns.Add("sj_putilidad1", typeof(decimal)); this.dtItems.Columns.Add("sj_putilidad2", typeof(decimal)); this.dtItems.Columns.Add("sj_putilidad3", typeof(decimal)); this.dtItems.Columns.Add("actualiza", typeof(bool)); dataGridView1.AutoGenerateColumns = false; dataGridView1.DataSource = this.dtItems; misclases.namecompany = ConfigurationManager.AppSettings["namecompany"].ToUpper(); misclases.conexLite = misclases.Conexion_Sqlite(); misclases.conexSql = misclases.Conexion_Sql(); cboGrupo.DataSource = misclases.CursorTable("select * from sainsta"); cboBuscapor.SelectedIndex = 0; cboGrupo.SelectedValue = 0; ActualizaEstructuraBD(); // l_tasascambiodolar tasascambio = new l_tasascambiodolar(); DataTable dt1 = new DataTable(); dt1 = tasascambio.select("1 order by id desc limit 1"); if (dt1.Rows.Count > 0) { this.ultimatasa = Convert.ToDecimal(dt1.Rows[0]["tasacambio"]); } texTasaCambio.Text = this.ultimatasa.ToString("F0"); ActcboTasasCambio(); ValidaInicio(); }