private void Btn_consulta_Click(object sender, EventArgs e)
{
Dgv_consultaBonoYDesc.Rows.Clear();
ruta = Txt_consultaNombre.Text;
try
{
OdbcCommand comm = new OdbcCommand("{call Sp_Buscarguia(?)}", Conexion.nuevaConexion());
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("nom", OdbcType.Text).Value = ruta;
OdbcDataReader mostrarDatos = comm.ExecuteReader();
while (mostrarDatos.Read())
{
Dgv_consultaBonoYDesc.Refresh();
Dgv_consultaBonoYDesc.Rows.Add(mostrarDatos.GetString(0), mostrarDatos.GetString(1), mostrarDatos.GetString(2),
mostrarDatos.GetString(3));
}
comm.Connection.Close();
mostrarDatos.Close();
}
catch (Exception err)
{
Console.WriteLine("ERROR:" + err.Message);
}
}
private void MostrarConsulta()
{
try
{
string consultaMostrar = "SELECT * FROM tbl_guiaturistico WHERE Estado='0';";
OdbcCommand comm = new OdbcCommand(consultaMostrar, Conexion.nuevaConexion());
OdbcDataReader mostrarDatos = comm.ExecuteReader();
while (mostrarDatos.Read())
{
Dgv_consultaBonoYDesc.Refresh();
Dgv_consultaBonoYDesc.Rows.Add(mostrarDatos.GetString(0), mostrarDatos.GetString(1), mostrarDatos.GetString(2));
}
comm.Connection.Close();
mostrarDatos.Close();
}
catch (Exception err)
{
Console.Write(err.Message);
}
}
