public SearchResultPage(string search) { InitializeComponent(); #region string connectionString = @"Data Source=JAMES-SPLEEN;Initial Catalog=WoozyTune;Integrated Security=True"; using (var connection = new SqlConnection(connectionString)) { connection.Open(); string select = $"SELECT * FROM Tracks WHERE [Title] LIKE '%{search}%'"; var command = new SqlCommand(select, connection); var reader = command.ExecuteReader(); int i = 1; while (reader.Read()) { grid.RowDefinitions.Add(new RowDefinition { Height = GridLength.Auto }); var trackViewUserControl = new TrackViewUserControl((int)reader.GetValue(0), reader.GetString(5), reader.GetString(6)); Grid.SetRow(trackViewUserControl, i++); grid.Children.Add(trackViewUserControl); } } using (var connection = new SqlConnection(connectionString)) { connection.Open(); string select = $"SELECT * FROM Tracks WHERE [Artist] LIKE '%{search}%'"; var command = new SqlCommand(select, connection); var reader = command.ExecuteReader(); int i = 1; while (reader.Read()) { grid.RowDefinitions.Add(new RowDefinition { Height = GridLength.Auto }); var trackViewUserControl = new TrackViewUserControl((int)reader.GetValue(0), reader.GetString(5), reader.GetString(6)); Grid.SetRow(trackViewUserControl, i++); grid.Children.Add(trackViewUserControl); } } using (var connection = new SqlConnection(connectionString)) { connection.Open(); string select = $"SELECT [UserId], [Username] FROM [UsersData] WHERE [Username] LIKE '%{search}%'"; var command = new SqlCommand(select, connection); var reader = command.ExecuteReader(); int i = 1; while (reader.Read()) { grid.RowDefinitions.Add(new RowDefinition { Height = GridLength.Auto }); var trackViewUserControl = new FollowUserControl((int)reader.GetValue(0), reader.GetString(1)); Grid.SetRow(trackViewUserControl, i++); grid.Children.Add(trackViewUserControl); } } #endregion }