public void FillTravelersListGrid() { string TravelersList = ""; DataTable dt = new DataTable(); dt = VSWebBL.DashboardBL.DominoServerHealthBLL.Ins.GetTravelerServerDetails(); Session["TravelerServerList"] = dt; TravelersList = "0"; DataRow[] foundRows; DataRow statusrow; statusrow = statuslist.NewRow(); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (statuslist.Rows.Count > 0) { foundRows = statuslist.Select("Status = '" + dt.Rows[i]["Status"].ToString() + "'"); if (foundRows.Length == 0) { statusrow = statuslist.Rows.Add(); statusrow["Status"] = dt.Rows[i]["Status"].ToString(); statusrow["StatusCount"] = 1; statusrow = statuslist.NewRow(); } else { statusrow = foundRows[0]; statusrow["StatusCount"] = Convert.ToInt32(statusrow["StatusCount"].ToString()) + 1; } } else { statusrow = statuslist.Rows.Add(); statusrow["Status"] = dt.Rows[i]["Status"].ToString(); statusrow["StatusCount"] = 1; statusrow = statuslist.NewRow(); } } TravelersList = dt.Rows.Count.ToString(); } TravelerGridView.DataSource = dt; TravelerGridView.DataBind(); DataRow rolerow = srvroles.Rows.Add(); rolerow["Role"] = "Traveler"; rolerow["RoleCount"] = Convert.ToInt32(TravelersList); }
public void FillTravelerListGridfromSession() { DataTable DataServers = new DataTable(); try { if (Session["TravelerServerList"] != null && Session["TravelerServerList"] != "") { DataServers = Session["TravelerServerList"] as DataTable; } if (DataServers.Rows.Count > 0) { DataServers.PrimaryKey = new DataColumn[] { DataServers.Columns["ID"] }; } TravelerGridView.DataSource = DataServers; TravelerGridView.DataBind(); } catch (Exception ex) { Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } }