public OpenArticle(Article _ar) { InitializeComponent(); ar = new Article(_ar); DataContext = this; UpdateListView(); }
public OpenArticle(int art_id) { InitializeComponent(); ar = new Article(); GetArticle(art_id); DataContext = this; UpdateListView(); }
public Article(Article _ar) { Id = _ar.Id; Creator = _ar.Creator; Text = _ar.Text; Title = _ar.Title; Date = _ar.Date; }
private void FillArticleListView(DataTable dt) { List<Article> articles = new List<Article>(); Article ar; foreach (DataRow row in dt.Rows) { ar = new Article(); ar.Id = Convert.ToInt32(row["ART_ID"]); ar.Title = row["TITLE"].ToString().Trim(); ar.Creator = new Author { FirstName = row["FIRST_NAME"].ToString().Trim(), LastName = row["LAST_NAME"].ToString().Trim() }; ar.Date = Convert.ToDateTime(row["TIME"]); articles.Add(ar); } if(articles.Count < 1) { MessageBox.Show("Нічого не знайдено.", "Результат пошуку"); return; } GridView myGridView = new GridView(); GridViewColumn gvc1 = new GridViewColumn(); gvc1.DisplayMemberBinding = new Binding("DateString"); gvc1.Header = "Дата"; gvc1.Width = 70; myGridView.Columns.Add(gvc1); GridViewColumn gvc2 = new GridViewColumn(); gvc2.DisplayMemberBinding = new Binding("Title"); gvc2.Header = "Заголовок"; myGridView.Columns.Add(gvc2); GridViewColumn gvc3 = new GridViewColumn(); gvc3.DisplayMemberBinding = new Binding("ReturnCreatorName"); gvc3.Header = "Автор"; myGridView.Columns.Add(gvc3); resListView.View = myGridView; resListView.ItemsSource = articles; }
private void FillArticlesList() { string ConString = ConfigurationManager.ConnectionStrings["NewspaperDB"].ConnectionString; using (SqlConnection con = new SqlConnection(ConString)) { string strSQL = @"SELECT ART_ID, TITLE, TIME FROM ARTICLES"; SqlCommand cmd = new SqlCommand(strSQL, con); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable("Articles"); sda.Fill(dt); Article artcl; foreach (DataRow row in dt.Rows) { artcl = new Article(); artcl.Id = Convert.ToInt32(row["ART_ID"]); artcl.Title = row["TITLE"].ToString().Trim(); artcl.Date = Convert.ToDateTime(row["TIME"]); articles.Add(artcl); } } }
private void FillListFromDataSet() { string ConString = ConfigurationManager.ConnectionStrings["NewspaperDB"].ConnectionString; string CmdString = string.Empty; using (SqlConnection con = new SqlConnection(ConString)) { CmdString = "SELECT ARTICLES.ART_ID, ARTICLES.TITLE, ARTICLES.TEXT, ARTICLES.TIME, AUTHORS.AU_ID, AUTHORS.FIRST_NAME, AUTHORS.LAST_NAME FROM ARTICLES, AUTHORS, ARTICLES_AUTHORS WHERE ARTICLES.ART_ID = ARTICLES_AUTHORS.ART_ID AND ARTICLES_AUTHORS.AU_ID = AUTHORS.AU_ID"; SqlCommand cmd = new SqlCommand(CmdString, con); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable("Articles"); sda.Fill(dt); Article ar; foreach (DataRow row in dt.Rows) { ar = new Article(); ar.Id = Convert.ToInt32(row["ART_ID"]); ar.Title = row["TITLE"].ToString().Trim(); ar.Creator = new Author { FirstName = row["FIRST_NAME"].ToString().Trim(), LastName = row["LAST_NAME"].ToString().Trim() }; ar.Text = row["TEXT"].ToString().Trim(); ar.Date = Convert.ToDateTime(row["TIME"]); articles.Add(ar); } } }