// edit private void button3_Click(object sender, EventArgs e) { button3.Enabled = false; button1.Enabled = false; button2.Enabled = false; string type = ""; string desc = ""; double fare = 0.0; if (dataGridView1.RowCount > 0) { int rowIndex = dataGridView1.CurrentCell.RowIndex; string item = dataGridView1.Rows[rowIndex].Cells[0].Value.ToString(); string sql = "SELECT * from TransportationData where Type like '" + item + "'"; SQLiteCommand sqlCommand = new SQLiteCommand(sql, transportData); SQLiteDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { type = reader["Type"].ToString(); desc = reader["Description"].ToString(); fare = Convert.ToDouble(reader["Fares"]); } AddTransportData add = new AddTransportData(item, desc, fare); add.ShowDialog(); if (add.type != "" && add.description != "" && add.fare != 0.0) { string test_update = "UPDATE TransportationData SET Type = @Type, Description = @Description , Fares = @Fares Where Type = @itemToSearch"; SQLiteCommand command = new SQLiteCommand(test_update, transportData); db.updateSpecificDataInDB(command, add.oldType, add.type, add.description, add.fare); dataGridView1.Rows.Clear(); dataGridView1.Refresh(); displayDataFromDB(transportData); } } button3.Enabled = true; button1.Enabled = true; button2.Enabled = true; this.Cursor = Cursors.Default; }
private void button1_Click(object sender, EventArgs e) { button1.Enabled = false; AddTransportData add = new AddTransportData(); add.ShowDialog(); string t = "insert into TransportationData (Type, Description, Fares) values ( @Type, @Description, @Fares)"; SQLiteCommand command = new SQLiteCommand(t, transportData); this.Cursor = Cursors.WaitCursor; if (add.type != "" && add.description != "" && add.fare != 0.0) { db.addDataToTransportation(add.type, add.description, add.fare, command); dataGridView1.Rows.Clear(); dataGridView1.Refresh(); displayDataFromDB(transportData); } button1.Enabled = true; this.Cursor = Cursors.Default; }