/****************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);
}
}
