void DeleteMemberByUsername()
{
if (IfMemberExist())
{
try
{
SqlConnection sqlConnection = new SqlConnection(_strcon);
if (sqlConnection.State == ConnectionState.Closed)
{
sqlConnection.Open();
}
string querry = "DELETE FROM Users WHERE Username='******'";
SqlCommand sqlCommand = new SqlCommand(querry, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
GridViewMemberList.DataBind();
ClearForm();
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + ".');</script>");
}
}
}
void UpdateMemberByUsername(string status)
{
if (IfMemberExist())
{
try
{
SqlConnection sqlConnection = new SqlConnection(_strcon);
if (sqlConnection.State == ConnectionState.Closed)
{
sqlConnection.Open();
}
string querry = "UPDATE Users SET Status='" + status + "' WHERE Username='******'";
SqlCommand sqlCommand = new SqlCommand(querry, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
GridViewMemberList.DataBind();
TextBoxAccount.Text = status;
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + ".');</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
GridViewMemberList.DataBind();
}
