/// <summary> /// create responsive table for each table by looking at the url /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { dataTableName = GetDataTableName(Request.Url.AbsoluteUri); if (dataTableName.Equals("users")) { table.CssClass = "table users-table Report1942Font"; sqlConnection = new SqlConnection(resources.ResourceManager.GetString("Connection_String")); sqlConnection.Open(); string sqlCmd = "SELECT * FROM [Users]"; SqlCommand sqlCommand = new SqlCommand(sqlCmd, sqlConnection); SqlDataReader reader = sqlCommand.ExecuteReader(); string[] titles = { "ID", "Username", "Password", "Email", "Content Creator", "Content Consumer", "Validated", "RandomKey", "User Color", "Admin" }; GenerateHeaderRow(titles); TableFooterRow footer_row = new TableFooterRow(); int i = 0; int counter = 0; if (reader.Read()) { footer_row = GenerateFooterRow(reader, ref counter); } do { table.Controls.Add(GenerateTableRow(reader, i, ref counter)); i++; } while (reader.Read()); reader.Close(); sqlConnection.Close(); title.InnerHtml = "USERS"; table.Controls.Add(footer_row); } if (dataTableName.Equals("models")) { table.CssClass = "table models-table Report1942Font"; ws = new maker_service.WebService(); string[] titles = { "Model ID", "User ID", "Date", "Data Path", "Name", "Description", "Thumbnail" }; GenerateHeaderRow(titles); ws.OpenConnection(); DataSet dataset = ws.GenericReaderQuery("SELECT * FROM [Models]"); TableFooterRow footer_row = new TableFooterRow(); int i = 0; int counter = 0; DataTableReader reader = dataset.Tables[0].CreateDataReader(); if (reader.Read()) { footer_row = GenerateFooterRow(reader, ref counter); } do { table.Controls.Add(GenerateTableRow(reader, i, ref counter)); i++; } while (reader.Read()); reader.Close(); ws.CloseConnection(); title.InnerHtml = "MODELS"; table.Controls.Add(footer_row); } if (dataTableName.Equals("downloads")) { table.CssClass = "table models-table Report1942Font"; ws = new maker_service.WebService(); string[] titles = { "Download ID", "User ID", "Model ID", "Download Date" }; GenerateHeaderRow(titles); ws.OpenConnection(); DataSet dataset = ws.GenericReaderQuery("SELECT * FROM [Downloads]"); TableFooterRow footer_row = new TableFooterRow(); int i = 0; int counter = 0; DataTableReader reader = dataset.Tables[0].CreateDataReader(); if (reader.Read()) { footer_row = GenerateFooterRow(reader, ref counter); } do { table.Controls.Add(GenerateTableRow(reader, i, ref counter)); i++; } while (reader.Read()); reader.Close(); ws.CloseConnection(); title.InnerHtml = "Downloads"; table.Controls.Add(footer_row); } if (dataTableName.Equals("ratings")) { table.CssClass = "table models-table Report1942Font"; ws = new maker_service.WebService(); string[] titles = { "Rate ID", "User ID", "Model ID", "Value" }; GenerateHeaderRow(titles); ws.OpenConnection(); DataSet dataset = ws.GenericReaderQuery("SELECT * FROM [Ratings]"); TableFooterRow footer_row = new TableFooterRow(); int i = 0; int counter = 0; DataTableReader reader = dataset.Tables[0].CreateDataReader(); if (reader.Read()) { footer_row = GenerateFooterRow(reader, ref counter); } do { table.Controls.Add(GenerateTableRow(reader, i, ref counter)); i++; } while (reader.Read()); reader.Close(); ws.CloseConnection(); title.InnerHtml = "Ratings"; table.Controls.Add(footer_row); } }