public OdbcDataReader ProbarTabla(string campo)
{
string error = "";
try
{
OdbcCommand command = new OdbcCommand("SELECT * FROM tbl_wsrenap WHERE CUI = " + campo + " ;", cn.conexionbd());
OdbcDataReader reader = command.ExecuteReader();
reader.Read();
string nom1 = reader.GetString(0);
Console.WriteLine(nom1);
reader.Close();
return(reader);
}
catch (Exception err)
{
Console.WriteLine(err.Message);
return(null);
}
}
//----------------------------------------------------INSERTAR UNO ------------------------------------------------------------------------------------------
public OdbcDataReader guardar1(string uno, string dos, string tres, string cuatro, string cinco, string sestado)
{
try
{
cn.conexionbd();
string consulta = "insert into maestros values(" + uno + ", '" + dos + "' ,'" + tres + "','" + cuatro + "' ,'" + cinco + "' ,'" + sestado + "');";
comm = new OdbcCommand(consulta, cn.conexionbd());
OdbcDataReader mostrar = comm.ExecuteReader();
return(mostrar);
}
catch (Exception err)
{
Console.WriteLine(err.Message);
return(null);
}
}
//------------------------------------------------------------------------------------------------------INSERTS-------------------------------------------------------//
public OdbcDataReader guardarconcepto(string sCodigo, string sNombre, string sEfecto, string sestado)
{
try
{
cn.conexionbd();
string consulta = "insert into concepto values(" + sCodigo + ", '" + sNombre + "' ,'" + sEfecto + "','" + sestado + "');";
comm = new OdbcCommand(consulta, cn.conexionbd());
OdbcDataReader mostrar = comm.ExecuteReader();
return(mostrar);
}
catch (Exception err)
{
Console.WriteLine(err.Message);
return(null);
}
}
