public int Insert(DataChart worker) { SqlCeCommand Insert = new SqlCeCommand("INSERT INTO Employees (Name, Sale) VALUES (@Name, @Sale)", Employees._connectionString); Insert.Parameters.AddWithValue("@Name", worker.key); Insert.Parameters.AddWithValue("@Sale", worker.value); int returnQuery = Insert.ExecuteNonQuery(); return returnQuery; }
public void FillRandom(int value) { Random rand = new Random(); for (int i = 0; i < value; i++) { string randomName = rand.Next(1, 1000000).ToString(); float randomSale = rand.Next(1, 100); DataChart worker = new DataChart(randomName, randomSale); this.Insert(worker); } }