//====================================================== private void RegisteredUsers() { string connectionstring = Properties.Settings.Default.AlchemyDatabaseConnectionString; SqlConnection connection = new SqlConnection(connectionstring); connection.Open(); string sql = "SELECT DateRegistered, Count(DateRegistered) AS NumberOfUsersRegistered FROM Users GROUP BY DateRegistered"; SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader = command.ExecuteReader(); GridViewRegistered.DataSource = reader; GridViewRegistered.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["role"] == null) { Response.Redirect("loginStaff.aspx"); } else { if (!IsPostBack) { TripDAO TripDAO = new TripDAO(); List <Trip> TripList = new List <Trip>(); int tripId = Convert.ToInt32(Request.QueryString["tripId"]); TripList = TripDAO.GetShortlisted(tripId); GridViewShortlisted.DataSource = TripList; GridViewShortlisted.DataBind(); TripList = TripDAO.GetRegisteredList(tripId); GridViewRegistered.DataSource = TripList; GridViewRegistered.DataBind(); TripList = TripDAO.GetRegisteredList(tripId); GridViewRegisteredExport.DataSource = TripList; GridViewRegisteredExport.DataBind(); TripList = TripDAO.GetWaitingList(tripId); GridViewWaitingList.DataSource = TripList; GridViewWaitingList.DataBind(); TripList = TripDAO.GetWaitingList(tripId); GridViewWaitingListExport.DataSource = TripList; GridViewWaitingListExport.DataBind(); TripList = TripDAO.GetNorminated(tripId); GridViewNorminated.DataSource = TripList; GridViewNorminated.DataBind(); TripList = TripDAO.GetNorminated(tripId); GridViewNorminatedExport.DataSource = TripList; GridViewNorminatedExport.DataBind(); TripList = TripDAO.GetRegisteredList(tripId); GridViewRegisteredIncharge.DataSource = TripList; GridViewRegisteredIncharge.DataBind(); TripList = TripDAO.GetNorminated(tripId); GridViewNorminatedIncharge.DataSource = TripList; GridViewNorminatedIncharge.DataBind(); TripList = TripDAO.GetWaitingList(tripId); GridViewWaitingListIncharge.DataSource = TripList; GridViewWaitingListIncharge.DataBind(); FeedbackForm cusObj = new FeedbackForm(); FeedbackFormDAO cusDao = new FeedbackFormDAO(); cusObj = cusDao.GetSpecificTrip(tripId); if (cusObj != null) { TripTitleLabel.Text = cusObj.TripTitle; CountryLabel.Text = cusObj.Country; LabelTripId.Text = (cusObj.TripId).ToString(); } } } LabelShortlistExport.Visible = false; LabelWaitingExport.Visible = false; LabelShortlistExport.Visible = false; LabelRegisterExport.Visible = false; }