private void addbutton_Click(object sender, EventArgs e) { //open the addprojectadvisore page AddProjectAdvisor a = new AddProjectAdvisor(); a.Show(); }
private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e) { AddProjectAdvisor form5 = new AddProjectAdvisor(); //when edit button clicked if (e.ColumnIndex == 4) { form5.Change("Update", dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString() ); form5.Show(); } if (e.ColumnIndex == 5) { var confirmResult = MessageBox.Show("Are you sure to delete this item ??", "Confirm Delete!!", MessageBoxButtons.YesNo); if (confirmResult == DialogResult.Yes) { //SqlConnection conn = new SqlConnection("Data Source=TALHAALI;Initial Catalog=ProjectA;User ID=sa;Password=talhaali"); //conn.Open(); //String cm4 = string.Format("Select Id from Person where Email='{0}'", dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString()); //SqlCommand comm4 = new SqlCommand(cm4, conn); //SqlDataReader reader2 = comm4.ExecuteReader(); //int studentid = 0; //while (reader2.Read()) //{ // studentid = Convert.ToInt32(reader2["Id"]); //} //conn.Close(); conn.Open(); String cm1 = string.Format("Delete From ProjectAdvisor where ProjectId=ANY(Select Id from Project where Title='{0}') and AdvisorId=ANY(Select Advisor.Id from Advisor INNER join Person On Advisor.Id=Person.Id where FirstName+' '+LastName='{1}' )", dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString()); SqlCommand comm1 = new SqlCommand(cm1, conn); comm1.ExecuteNonQuery(); //String cm = string.Format("Delete From Person where Id='{0}'", studentid); //SqlCommand comm = new SqlCommand(cm, conn); //var row = comm.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Deleted"); object sende = null; EventArgs er = null; dataGridView1.Rows.Clear(); this.ProjectAdvisor_Load(sende, er); } else { MessageBox.Show("Not Deleted"); } } }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { AddProjectAdvisor a = new AddProjectAdvisor(); if (e.ColumnIndex == 4) // if we want to update { a.setpara("Update", dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString() ); a.Show(); } if (e.ColumnIndex == 5) //deleting stuff { var ConfirmResult = MessageBox.Show("really want to delete this", "Confirm Delete!!", MessageBoxButtons.YesNo); if (ConfirmResult == DialogResult.Yes) { con.Open(); String cmd2 = string.Format("DELETE From ProjectAdvisor WHERE ProjectId = ANY(Select Id from Project where Title='{0}') and AdvisorId = ANY(Select Advisor.Id from Advisor INNER join Person On Advisor.Id = Person.Id WHERE FirstName+' '+LastName='{1}' )", dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString()); SqlCommand query2 = new SqlCommand(cmd2, con); query2.ExecuteNonQuery(); con.Close(); //after deletion MessageBox.Show("Deleted"); object sende = null; EventArgs er = null; dataGridView1.Rows.Clear(); //load the project advisor again this.ProjectAdvisor_Load(sende, er); } else { MessageBox.Show("Not Deleted"); } } }
private void button1_Click_1(object sender, EventArgs e) { AddProjectAdvisor ADP = new AddProjectAdvisor(); ADP.Show(); }