private void dataGridView1_CellContentClick_2(object sender, DataGridViewCellEventArgs e) { int curRow = int.Parse(e.RowIndex.ToString()); string currentrow; currentrow = dataGridView1.Rows[curRow].Cells[1].Value.ToString(); SqlConnection con = new SqlConnection(constring); con.Open(); SqlCommand cmd = new SqlCommand("Update ComposeRequest set CView='" + p1 + "' where CID='" + currentrow + "'", con); cmd.ExecuteNonQuery(); ViewUserRequests vur = new ViewUserRequests(); vur.ShowDialog(); }
private void button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(constring); con.Open(); SqlDataAdapter adp1 = new SqlDataAdapter("Select * from ComposeRequest where CID='" + label14.Text + "'", con); DataSet ds1 = new DataSet(); adp1.Fill(ds1); string status = ds1.Tables[0].Rows[0]["CStatus"].ToString(); if (status == "Success") { DialogResult dlg1 = MessageBox.Show("Request Already Sent To Manager.", "Message Box", MessageBoxButtons.OK, MessageBoxIcon.Warning); if (dlg1 == DialogResult.OK) { ViewUserRequests vur = new ViewUserRequests(); vur.Close(); } } else { for (int j = 0; j < ds1.Tables[0].Rows.Count; j++) { SqlCommand cmd1 = new SqlCommand("Update ComposeRequest set CReqToManager='" + comboBox1.SelectedItem.ToString() + "' where CID='" + label14.Text + "'", con); cmd1.ExecuteNonQuery(); SqlCommand cmd2 = new SqlCommand("Update ComposeRequest set CStatus='" + p4 + "' where CID='" + label14.Text + "'", con); cmd2.ExecuteNonQuery(); } DialogResult dlg = MessageBox.Show("Request Sent To Manager.", "Message Box", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); if (dlg == DialogResult.OK) { ViewUserRequests vur = new ViewUserRequests(); vur.Close(); } } con.Close(); }
private void button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(constring); con.Open(); SqlDataAdapter adp1 = new SqlDataAdapter("Select * from ComposeRequest where CID='" + label14.Text + "'", con); DataSet ds1 = new DataSet(); adp1.Fill(ds1); string status=ds1.Tables[0].Rows[0]["CStatus"].ToString(); if (status == "Success") { DialogResult dlg1 = MessageBox.Show("Request Already Sent To Manager.", "Message Box", MessageBoxButtons.OK, MessageBoxIcon.Warning); if (dlg1 == DialogResult.OK) { ViewUserRequests vur = new ViewUserRequests(); vur.Close(); } } else { for (int j = 0; j < ds1.Tables[0].Rows.Count; j++) { SqlCommand cmd1 = new SqlCommand("Update ComposeRequest set CReqToManager='" + comboBox1.SelectedItem.ToString() + "' where CID='" + label14.Text + "'", con); cmd1.ExecuteNonQuery(); SqlCommand cmd2 = new SqlCommand("Update ComposeRequest set CStatus='" + p4 + "' where CID='" + label14.Text + "'", con); cmd2.ExecuteNonQuery(); } DialogResult dlg = MessageBox.Show("Request Sent To Manager.", "Message Box", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); if (dlg == DialogResult.OK) { ViewUserRequests vur = new ViewUserRequests(); vur.Close(); } } con.Close(); }