private void button4_Click(object sender, EventArgs e) { int selectedRowCount = dataGridView2.Rows.GetRowCount(DataGridViewElementStates.Selected); if (selectedRowCount != 1) { MessageBox.Show("Only one row must pe selected!", "Error selection", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { DataGridViewRow row = dataGridView2.SelectedRows[0]; int id = int.Parse(Convert.ToString(row.Cells["resourceId"].Value)); ResourceModify rm = new ResourceModify(id, companyId, Convert.ToString(row.Cells["name"].Value), Convert.ToString(row.Cells["description"].Value), int.Parse(Convert.ToString(row.Cells["cost"].Value)), true); this.Hide(); rm.ShowDialog(); // refresh gridview table conn.Open(); int pageNumber = 1; OleDbDataAdapter adapter = new OleDbDataAdapter("Select * from ( select a.*, rownum r__ from (Select * from resourcesMaterializedView where companyid = " + companyId + ") a where rownum < (" + pageNumber * 10 + ")) where r__ >= (" + (pageNumber - 1) * 10 + ")", conn); DataTable dt = new DataTable(); adapter.Fill(dt); dataGridView2.DataSource = dt; conn.Close(); this.Show(); } }
private void button8_Click(object sender, EventArgs e) { ResourceModify rm = new ResourceModify(-1, companyId, "", "", -1, false); this.Hide(); rm.ShowDialog(); // refresh gridview table conn.Open(); OleDbDataAdapter adapter = new OleDbDataAdapter("Select * from resourcesMaterializedView where companyid = " + companyId, conn); DataTable dt = new DataTable(); adapter.Fill(dt); dataGridView2.DataSource = dt; conn.Close(); this.Show(); }