// prress key for update and delete student
private void gvStudents_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (gvStudents.SelectedCells.Count > 0)
{
int selectedrowindex = gvStudents.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = gvStudents.Rows[selectedrowindex];
string _id = Convert.ToString(selectedRow.Cells["id"].Value);
lblidStud.Text = _id;
string _qry = "";
DataSet ds = new DataSet();
string qry = "SELECT Student.Id, Student.FirstName, Student.LastName, Student.Contact, Student.Email, Student.RegistrationNumber, Lookup.Name, Lookup.LookupId " +
" FROM Student INNER JOIN " + " Lookup ON Student.Status = Lookup.LookupId where id='" + _id + "'";
ds = ajdbClass.GetRecords("tbl", qry);
foreach (DataRow dr in ds.Tables[0].Rows)
{
txtfname.Text = dr["FirstName"].ToString().Trim();
txtlname.Text = dr["LastName"].ToString().Trim();
txtcon.Text = dr["Contact"].ToString().Trim();
txtemail.Text = dr["Email"].ToString().Trim();
txtRegNo.Text = dr["RegistrationNumber"].ToString().Trim();
cmbStatus.SelectedValue = dr["LookupId"].ToString().Trim();
}
}
}
//delete student
if (e.KeyCode == Keys.Delete)
{
if (AskYesNo() == false)
{
return;
}
int selectedrowindex = gvStudents.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = gvStudents.Rows[selectedrowindex];
string _id = Convert.ToString(selectedRow.Cells["id"].Value);
string s = ajdbClass.DeleteFromDatabase("delete from student where id='" + _id + "'");
if (s != "Delete Record(s) Successfully")
{
s = "Unable to Delete. Record might be required in other tables";
}
MessageBox.Show(s);
string qry = "SELECT Student.Id, Student.FirstName, Student.LastName, Student.Contact, Student.Email, Student.RegistrationNumber, Lookup.Name, Lookup.LookupId " +
" FROM Student INNER JOIN " + " Lookup ON Student.Status = Lookup.LookupId ";
ajdbClass.popGrid(gvStudents, qry);
txtfname.Text = ""; txtlname.Text = ""; txtRegNo.Text = ""; txtemail.Text = ""; txtcon.Text = "";
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
Label lbldeleteid = (Label)row.FindControl("lblID");
AJ_DataClass aj = new AJ_DataClass();
aj.DeleteFromDatabase("delete FROM Purchase where Prid='" + Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString()) + "'");
gvbind();
}
// delete rows from clos
private void gvClo_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Delete)
{
if (AskYesNo() == false)
{
return;
}
int selectedrowindex = gvClo.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = gvClo.Rows[selectedrowindex];
string _id = Convert.ToString(selectedRow.Cells["id"].Value);
AJ_DataClass ajdbClass = new AJ_DataClass();
string s = ajdbClass.DeleteFromDatabase("delete from clo where id='" + _id + "'");
ajdbClass.popGrid(gvClo, "select id,name from clo");
ajdbClass.popCmb(cmbClo, "select * from clo", "id", "name");
lblrubricLevels.Text = "Rubrics Level - Settings Clo:" + cmbClo.Text;
}
}