private void ShowNewsList() { try { conn.Open(); command.Connection = conn; command.CommandType = CommandType.StoredProcedure; //set the commandText to the name of our stored procedure command.CommandText = "[dbo].[ListNewsItems]"; //command.CommandText = string.Format("select * from NewsTbl"); queryResults = command.ExecuteReader(); if (!queryResults.Read()) { //used emptydata template in News.aspx instead // lblError.Text = "No News Items recorded "; } ListViewNews.DataSource = queryResults; ListViewNews.DataBind(); command.Connection.Close(); } catch (Exception ex) { lblError.Visible = true; lblError.Text = ex.Message; } finally { conn.Close(); } }
protected void _OnItemCommand(object sender, ListViewCommandEventArgs e) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; string newsID = ListViewNews.DataKeys[dataItem.DisplayIndex].Value.ToString(); if (e.CommandName == "cancella") { DataSetMateraArredamentiTableAdapters.NewsTableAdapter taNews = new DataSetMateraArredamentiTableAdapters.NewsTableAdapter(); taNews.DeleteNewsEventi(int.Parse(newsID)); } else if (e.CommandName == "modifica") { Response.Redirect("AddModNews.aspx?tipo=" + ddlTipo.SelectedValue + "&NewsID=" + newsID); } else if (e.CommandName == "fotoGallery") { DataSetVepAdminTableAdapters.NewsTableAdapter taNews = new DataSetVepAdminTableAdapters.NewsTableAdapter(); int idNews = int.Parse(newsID); DataSetVepAdminTableAdapters.AlbumsTableAdapter taAlbums = new DataSetVepAdminTableAdapters.AlbumsTableAdapter(); int albumID = 0; DataTable dtAlbum = taAlbums.GetIdAlbum(idNews); DataTable dtNews = taNews.GetDataByID(idNews); string idScuola = (string)Session["ddlScuola"]; if (dtAlbum.Rows.Count == 0) { albumID = Convert.ToInt32(taAlbums.InsertAlbumRetID(dtNews.Rows[0]["Descrizione"].ToString(), true, idNews)); //nuova news inserita faccio una redirect e nella sessione ho già l'id_news! Response.Redirect("~/Admin/Photos.aspx?AlbumID=" + albumID.ToString()); } else { Response.Redirect("~/Admin/Photos.aspx?AlbumID=" + dtAlbum.Rows[0]["AlbumID"].ToString()); } } ListViewNews.DataBind(); }