private void DeleteRecordToolStripButton_Click(object sender, EventArgs e)
{
int rowIndex = StudentDataGridView.Rows.GetFirstRow(DataGridViewElementStates.Selected);
SqlDataReader dataReader;
try
{
if (rowIndex != -1)
{
int StudentId = Convert.ToInt32(StudentDataGridView.Rows[rowIndex].Cells["StudentId"].Value);
string query = "DELETE FROM dbo.Student WHERE StudentId='" + StudentId + "';";
SqlConnection Sqlcon = new SqlConnection(AppSetting.ConnectionString());
SqlCommand SqlCom = new SqlCommand(query, Sqlcon);
Sqlcon.Open();
dataReader = SqlCom.ExecuteReader();
SMSMessageBox.ShowSuccessMessage("Row Deleted");
while (dataReader.Read())
{
}
LoadDataIntoGridView();
}
else
{
SMSMessageBox.ShowErrorMessage("Please Select Row");
}
}
catch (Exception ex)
{
SMSMessageBox.ShowErrorMessage("Error Message");
}
}
private void saveRecordToolStripMenuItem_Click(object sender, EventArgs e)
{
if (isFormValid())
{
if (this.IsUpdate)
{
SaveOrUpdateRecord("usp_StudentUpdateNewStudent");
SMSMessageBox.ShowSuccessMessage("Record is updated successfully");
}
else
{
SaveOrUpdateRecord("usp_StudentAddNewStudent");
SMSMessageBox.ShowSuccessMessage("Record is added successfully");
}
}
this.Hide();
}
private void saveRecordToolStripMenuItem_Click(object sender, EventArgs e)
{
if (isFormValid())
{
if (this.IsUpdate)
{
SaveOrUpdateRecord("usp_BranchesUpdateBranchDetails");
SMSMessageBox.ShowSuccessMessage("Record is updated successfully");
}
else
{
SaveOrUpdateRecord("usp_BranchesAddNewBranch");
SMSMessageBox.ShowSuccessMessage("Record is added successfully");
}
this.Close();
}
}
