public void ConsultaDatosInsumos() { Clases.clsUtilidades ut = new Clases.clsUtilidades(); ds = pd.ConsultasCombos("paConsultas", "1"); if (TipoConsulta_ == "Insumos") { dgvMaestros.DataSource = ds.Tables[0]; ut.FormatearGrid(dgvMaestros, "Precio", "C"); } else if (TipoConsulta_ == "Clientes") { gbppal.Text = "Clientes"; dgvMaestros.DataSource = ds.Tables[1]; dgvMaestros.Columns["Id"].Visible = false; } else if (TipoConsulta_ == "Compañias") { gbppal.Text = "Compañias"; dgvMaestros.DataSource = ds.Tables[2]; dgvMaestros.Columns["IdCompañia"].Visible = false; dgvMaestros.Columns["Logo"].Visible = false; } ut.AlinearContenidoColumna(dgvMaestros); dgvMaestros.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; }
private void Refresh() { ds = pd.ConsultasCombos("paConsultas", "0"); //string[] s = ds.Tables[1].Rows.OfType<DataRow>().Select(k => k[2].ToString()).ToArray(); cbbResolucion.DataSource = ds.Tables[0]; cbbResolucion.ValueMember = "NumeroResolucion"; this.cbbResolucion.AutoCompleteCustomSource.AddRange(ds.Tables[0].Rows.OfType <DataRow>().Select(k => k[0].ToString()).ToArray()); this.cbbResolucion.AutoCompleteMode = AutoCompleteMode.Suggest; this.cbbResolucion.AutoCompleteSource = AutoCompleteSource.CustomSource; //this.cbbCliente.AutoCompleteMode = AutoCompleteMode.SuggestAppend; //this.cbbCliente.AutoCompleteSource = AutoCompleteSource.ListItems; // dtv = new DataView(ds.Tables[1]); //dtv.Sort = "RazonSocial ASC"; //DataTable dt = dtv.ToTable(); cbbCliente.DataSource = ds.Tables[1]; cbbCliente.DisplayMember = "RazonSocial"; cbbCliente.ValueMember = "IdCliente"; cbbCliente.Text = "Seleccione un cliente"; txtNumFac.Text = ds.Tables[2].Rows[0]["NumFac"].ToString(); dgvInsumos.DataSource = ds.Tables[3]; dgvInsumos.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; //dgvInsumos.Columns["Precio"].DefaultCellStyle.FormatProvider= System.Globalization.CultureInfo.GetCultureInfo("en-us"); //dgvInsumos.Columns["Precio"].DefaultCellStyle.Format =string.Format( "C"); Utilidades.FormatearGrid(dgvInsumos, "Precio", "C"); cbbCompania.DataSource = ds.Tables[5]; cbbCompania.DisplayMember = "RazonSocial"; cbbCompania.ValueMember = "IdCompañia"; cbbSede.Text = ""; this.dtpFechaFactura.Value = DateTime.Now; this.dtpFechavencimento.Value = DateTime.Now; textBox1.Text = ""; errorProvider1.Clear(); }