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