protected void ButtonLeave_Click(object sender, EventArgs e)
{
using (SqlCommand sqlCmd = new SqlCommand())
{
Button button = sender as Button;
String RSOID = button.CommandArgument;
conn.Open();
sqlCmd.Connection = conn;
sqlCmd.CommandText = @"DELETE FROM User_RSO WHERE (id_RSO = @RSOID AND id_User = @UserID)";
sqlCmd.Parameters.AddWithValue("@RSOID", int.Parse(RSOID));
sqlCmd.Parameters.AddWithValue("@UserID", userID);
sqlCmd.ExecuteNonQuery();
conn.Close();
for (int i = 0; i < dtRSO.Rows.Count; i++)
{
DataRow dr = dtRSO.Rows[i];
if (dr["id"].ToString() == RSOID)
{
dtRSO.Rows.Remove(dr);
break;
}
}
RepeaterDiv.Style.Add("height", dtRSO.Rows.Count * 150 + 150 + "px");
RepeaterRSO.DataSource = dtRSO;
RepeaterRSO.DataBind();
}
}
private void LoadRSO(int UserID)
{
using (SqlCommand sqlCmd = new SqlCommand())
{
conn.Open();
sqlCmd.Connection = conn;
sqlCmd.CommandText = @"SELECT B.id, B.name, B.description FROM User_RSO A, RSO B WHERE (A.id_User = @UserID AND A.id_RSO = B.id)";
sqlCmd.Parameters.AddWithValue("@UserID", UserID);
dtRSO = new DataTable();
using (SqlDataReader sqldr = sqlCmd.ExecuteReader())
{
dtRSO.Load(sqldr);
}
conn.Close();
RepeaterDiv.Style.Add("height", dtRSO.Rows.Count * 150 + 150 + "px");
RepeaterRSO.DataSource = dtRSO;
RepeaterRSO.DataBind();
}
}
