public static Link[] GetAllLinks() { List<Link> alist = new List<Link>(); SqlConnection conn = Connection.Open(); string sql; sql = SqlFormat.Format("SELECT description, whocreated, url FROM LINKS ORDER BY id ASC"); SqlCommand cmd = new SqlCommand(sql, conn); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Link l = new Link(); l.Description = reader["description"].ToString(); l.SubmitterName = reader["whocreated"].ToString(); l.Url = reader["url"].ToString(); alist.Add(l); } return alist.ToArray(); } }
public AddLinkDialog(Link link) { InitializeComponent(); this.Link = link; this.DataContext = link; FocusManager.SetFocusedElement(this, this.mDescriptionTextbox); // not working, annoying!!! }
private static void LoadLinksIntoViewModel(Link[] links, TriviaViewModel viewModel) { if (links == null) { return; } if (viewModel.Links.Count > 0) { return; // We've already got them } foreach (Link link in links) { viewModel.Links.Add(link); } }