private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SqlConnection con = new SqlConnection(constring);
con.Open();
int curRow = int.Parse(e.RowIndex.ToString());
string currentrow;
currentrow = dataGridView1.Rows[curRow].Cells[1].Value.ToString();
SqlDataAdapter adp1 = new SqlDataAdapter("Select * from ResManagerToAdmin where ResID='" + currentrow + "'", con);
DataSet ds1 = new DataSet();
adp1.Fill(ds1);
SqlCommand cmd = new SqlCommand("Update ResManagerToAdmin set RView='" + p2 + "' where ResID='" + currentrow + "'", con);
cmd.ExecuteNonQuery();
SqlCommand cmd1 = new SqlCommand("Update ResManagerToAdmin set RFinalView='" + p2 + "' where ResID='" + currentrow + "'", con);
cmd1.ExecuteNonQuery();
status = ds1.Tables[0].Rows[0]["RStatus"].ToString();
if (status == "Success")
{
ViewAdminResponses var = new ViewAdminResponses();
var.ShowDialog();
}
else
{
RecordNotFound rnf = new RecordNotFound();
rnf.ShowDialog();
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int curRow = int.Parse(e.RowIndex.ToString());
string currentrow, currentrow1;
currentrow = dataGridView1.Rows[curRow].Cells[1].Value.ToString();
currentrow1 = dataGridView1.Rows[curRow].Cells[7].Value.ToString();
SqlConnection con = new SqlConnection(constring);
con.Open();
SqlCommand cmd = new SqlCommand("Update ResManagerToAdmin set RView='" + p1 + "' where ResID='" + currentrow + "'", con);
cmd.ExecuteNonQuery();
if (currentrow1 == "Record Not Found")
{
RecordNotFound rnf = new RecordNotFound();
rnf.ShowDialog();
}
else
{
ViewAdminResponses var = new ViewAdminResponses();
var.ShowDialog();
}
con.Close();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int curRow = int.Parse(e.RowIndex.ToString());
string currentrow, currentrow1;
currentrow = dataGridView1.Rows[curRow].Cells[1].Value.ToString();
currentrow1 = dataGridView1.Rows[curRow].Cells[7].Value.ToString();
SqlConnection con = new SqlConnection(constring);
con.Open();
SqlCommand cmd = new SqlCommand("Update ResManagerToAdmin set RView='" + p1 + "' where ResID='" + currentrow + "'", con);
cmd.ExecuteNonQuery();
if (currentrow1 == "Record Not Found")
{
RecordNotFound rnf = new RecordNotFound();
rnf.ShowDialog();
}
else
{
ViewAdminResponses var = new ViewAdminResponses();
var.ShowDialog();
}
con.Close();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SqlConnection con = new SqlConnection(constring);
con.Open();
int curRow = int.Parse(e.RowIndex.ToString());
string currentrow;
currentrow = dataGridView1.Rows[curRow].Cells[1].Value.ToString();
SqlDataAdapter adp1 = new SqlDataAdapter("Select * from ResManagerToAdmin where ResID='" + currentrow + "'", con);
DataSet ds1 = new DataSet();
adp1.Fill(ds1);
SqlCommand cmd = new SqlCommand("Update ResManagerToAdmin set RView='" + p2 + "' where ResID='" + currentrow + "'", con);
cmd.ExecuteNonQuery();
SqlCommand cmd1 = new SqlCommand("Update ResManagerToAdmin set RFinalView='" + p2 + "' where ResID='" + currentrow + "'", con);
cmd1.ExecuteNonQuery();
status = ds1.Tables[0].Rows[0]["RStatus"].ToString();
if (status == "Success")
{
ViewAdminResponses var = new ViewAdminResponses();
var.ShowDialog();
}
else
{
RecordNotFound rnf = new RecordNotFound();
rnf.ShowDialog();
}
}