/****************ESTILOS PARA EL DATAGRIDVIEW********************/ private void aplicarEstilos(DataGridView dataGrid) { DgbConceptoDePago.Columns[0].HeaderText = "ID"; DgbConceptoDePago.ClearSelection(); dataGrid.RowsDefaultCellStyle.BackColor = Color.White; dataGrid.RowHeadersDefaultCellStyle.BackColor = Color.White; dataGrid.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(224, 224, 224); }
private void ejecutarConsulta() { try { //Data Source = DESKTOP - Q7VG5OH; Initial Catalog = Backup_Cuentas_por_pagar; Integrated Security = True conn = new SqlConnection("Data Source=ana-alex-brian.database.windows.net;Initial Catalog=Cuentas_por_pagar;User ID=propietaria;Password=#Seguridad1"); conn.Open(); /***************CONSULTA*****************/ string sql = "SELECT * FROM CONCEPTO_PAGO"; if (cbxCriterio.Text.Length > 0) { string criterio; if (cbxCriterio.SelectedIndex == 0) { criterio = "Id_Concepto_Pago"; } else { criterio = cbxCriterio.Text; } sql += " WHERE " + criterio + " LIKE '%" + txtBuscar.Text + "%'"; sql += " ORDER BY " + criterio; } /*******************************************/ SqlDataAdapter da = new SqlDataAdapter(sql, conn); DataTable dt = new DataTable(); da.Fill(dt); DgbConceptoDePago.DataSource = dt; DgbConceptoDePago.Refresh(); aplicarEstilos(DgbConceptoDePago); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error" + ex.Message); } }