//Methods for categoria
public static void insertValue()
{
IDbCommand dbCommand = dbConnection.CreateCommand();
Console.Write("Nombre");
string nombre = Console.ReadLine();
dbCommand.CommandText = "insert into categoria (nombre) values (@nombre)";
DbCommandHelper.AddParameter(dbCommand, "nombre", nombre);
dbCommand.ExecuteNonQuery();
}
public static void InsertValue()
{
IDbCommand dbCommand = dbConnection.CreateCommand();
//string nombre = "nuevo " + DateTime.Now;
Console.Write("Nombre: ");
string nombre = Console.ReadLine();
dbCommand.CommandText = "insert into categoria (nombre) values (@nombre)";
//IDbDataParameter dbDataParameter = dbCommand.CreateParameter();
//dbDataParameter.ParameterName = "nombre";
//dbDataParameter.Value = nombre; //"cat. 33"
//dbCommand.Parameters.Add(dbDataParameter);
DbCommandHelper.AddParameter(dbCommand, "nombre", nombre);
dbCommand.ExecuteNonQuery();
}