public void onSelected(object sender, SelectedItemChangedEventArgs e) { GroupChatInfo selectedItem = (GroupChatInfo)e.SelectedItem; if (selectedItem == null) { return; } Navigation.PushModalAsync(new GroupChatPage(selectedItem)); ((ListView)sender).SelectedItem = null; }
public static IList <GroupChatInfo> GetSqlGroups(string userID) { List <GroupChatInfo> sonuc = new List <GroupChatInfo>(); try { string query = @"SELECT T1.ID,T1.Name, T1.ImageUrl, T1.Adminid FROM[dbo].[Groups] AS T1 INNER JOIN GroupAndUsers AS T2 ON T1.ID = T2.groupID and T2.userID = @userid"; using (SqlConnection connection = new SqlConnection(conBuilder.ConnectionString)) { SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@userid", userID); connection.Open(); using (SqlDataReader oku = command.ExecuteReader()) { while (oku.Read()) { GroupChatInfo gc = new GroupChatInfo(); gc.ID = oku[0].ToString(); gc.Title = oku[1].ToString(); gc.ImageUrl = oku[2].ToString(); gc.AdminID = oku[3].ToString(); sonuc.Add(gc); } oku.Close(); } } } catch { } return(sonuc); }