public List <Dato> ObtenerListaDato()
{
List <Dato> lista = new List <Dato>();
try
{
this.comando = new SqlCommand();
this.comando.CommandType = CommandType.Text;
this.comando.CommandText = "SELECT * FROM tabla_uno";
this.comando.Connection = this.conexion;
this.conexion.Open();
this.lector = comando.ExecuteReader();
while (lector.Read())
{
Dato item = new Dato();
// ACCEDO POR NOMBRE, POR INDICE O POR GETTER (SEGUN TIPO DE DATO)
item.id = (int)lector["id"];
item.cadena = lector[1].ToString();
item.entero = lector.GetInt32(2);
item.flotante = float.Parse(lector[3].ToString());
lista.Add(item);
}
lector.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
if (this.conexion.State == ConnectionState.Open)
{
this.conexion.Close();
}
}
return(lista);
}
public bool ModificarDato(Dato param)
{
bool rta = true;
try
{
this.comando = new SqlCommand();
this.comando.Parameters.AddWithValue("@id", param.id);
this.comando.Parameters.AddWithValue("@cadena", param.cadena);
this.comando.Parameters.AddWithValue("@entero", param.entero);
this.comando.Parameters.AddWithValue("@flotante", param.flotante);
string sql = "UPDATE tabla_uno ";
sql += "SET cadena = @cadena, entero = @entero, flotante = @flotante ";
sql += "WHERE id = @id";
this.comando.CommandType = CommandType.Text;
this.comando.CommandText = sql;
this.comando.Connection = this.conexion;
this.conexion.Open();
int filasAfectadas = this.comando.ExecuteNonQuery();
if (filasAfectadas == 0)
{
rta = false;
}
}
catch (Exception)
{
rta = false;
}
finally
{
if (this.conexion.State == ConnectionState.Open)
{
this.conexion.Close();
}
}
return(rta);
}
public bool AgregarDato(Dato param)
{
bool rta = true;
try
{
string sql = "INSERT INTO tabla_uno (cadena, entero, flotante) VALUES(";
sql = sql + "'" + param.cadena + "'," + param.entero.ToString() + "," + param.flotante.ToString() + ")";
this.comando = new SqlCommand();
this.comando.CommandType = CommandType.Text;
this.comando.CommandText = sql;
this.comando.Connection = this.conexion;
this.conexion.Open();
int filasAfectadas = this.comando.ExecuteNonQuery();
if (filasAfectadas == 0)
{
rta = false;
}
}
catch (Exception e)
{
rta = false;
}
finally
{
if (this.conexion.State == ConnectionState.Open)
{
this.conexion.Close();
}
}
return(rta);
}