SmartDeviceProject1.SqlCeStorageHandler.GetAllItems C# (CSharp) Method

GetAllItems() public method

public GetAllItems ( System.Guid listId ) : List
listId System.Guid
return List
        public List<Item> GetAllItems(Guid listId)
        {
            var items = new List<Item>();

            using (var command = new SqlCeCommand())
            {
                command.Connection = GetSqlCeConnection();
                command.CommandText = GET_ALL_ITEMS;
                command.Parameters.Add("@ListID", SqlDbType.UniqueIdentifier).Value = listId;

                SqlCeDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    var i = new Item
                    {
                        ID = (Guid)reader["ID"],
                        Name = reader["Name"] as string,
                        Description = reader["Description"] as string,
                        ListID = (Guid)reader["ListID"],
                        Priority = reader["Priority"] as int?,
                        Status = reader["Status"] as int?,
                        UserID = (Guid)reader["UserID"],
                        ServiceMetadata = new OfflineEntityMetadata()
                        {
                            IsTombstone = (bool)reader["IsTombstone"],
                            Id = reader["_MetadataID"] as string
                        }
                    };

                    items.Add(i);
                }
            }

            return items;
        }

Usage Example

Beispiel #1
0
 private void RefreshItems()
 {
     var storageHandler = new SqlCeStorageHandler();
     ListBoxItems.DataSource = storageHandler.GetAllItems(ListId);
     ListBoxItems.DisplayMember = "Name";
 }