You just mean chunking the file? I've not heard of 'multi-part FTP'. If that is what you mean, it's a very common pattern; roughly speaking: Stream inStream = GetInputStream(); // e.g. new FileStream() etc Stream outStream = request.GetRequestStream(); // Anything up to a few meg is okay, but making this similar to the TCP packet // size makes sense const int blocksize = 8192; byte[] buf = new byte[blocksize]; int read = 0; while(0 < (read = inStream.ReadBytes(buf, blocksize))) outStream.WriteBytes(buf, read);

A quick and dirty way would be to expose an IsSelected property on your parcel and bind to that. C# has already designed away most of the tedium of C++.

Michael J. Eber wrote: you will see that his answer was wrong and did nothing to fix my problem. Yes I noticed that after posting - sorry. Michael J. Eber wrote: As it turns out this screen was a prototype and we pumped in a quick and dirty way to get a functional boolean into the form. That would have been a better reply in the initial response, we all hack something up when developing. I'm glad you got the problem fixed - and published it so others can benefit. And you are right univoting is childish (although your answer on file access was incorrect and was voted on content)! Never underestimate the power of human stupidity RAH

Awesome! Was just about to send this... <UserControl.Resources> <ResourceDictionary> <ResourceDictionary.MergedDictionaries> <ResourceDictionary Source="/GlobalLibraryDefinitions;component/Themes/Generic.xaml" /> </ResourceDictionary.MergedDictionaries> <converters:IndexGreaterThanZeroToVisibilityConverter x:Key="IndexGreaterThanZeroToVisibilityConverter" /> </ResourceDictionary> </UserControl.Resources> Mark Salsbery Microsoft MVP - Visual C++ :java:

I wasn't being sarcastic. To help with diagnosing a code question one needs to post the code that is the source of the problem.

Hello! When i have similar situations i usually create a dummy SPROC that returns only empty data with the correct datatypes for each column. like: select CAST(0 as int) as CustomerNumber, CAST('x' as nvarchar(64)) as CustomerName, ....... and then comment all dynamic data in the SPROC. Then you can drag the SPROC into the dbml to get the correct return type. Once you hava a correct return type. restore your SPROC to the correct state. hope it helps Andreas Johansson IT Professional at Office IT Partner i Norrbotten Sweden What we don't know. We learn. What you don't know. We teach

You might also want to look at an outer join. I wrote something about this a while back: http://www.citrustechnology.com/blog/20100113

LongRangeShooter wrote: I intended to implement my own logic. One way could be to load all your permissions (to groups etc - via a web service) during logon and then display only those groups that you have access to in your menu.

Not sure I've understood you properly, but your subquery doesn't look correct. So try something like this: SELECT dbo.ContactMaster.BmcCustKey ,Sum(CASE WHEN dbo.LocationAccessGrant.CanAccessLocation = 1 THEN 1 ELSE 0 END) accesscount FROM dbo.ContactMaster LEFT OUTER JOIN dbo.LocationAccessGrant ON dbo.ContactMaster.CompanyID = dbo.LocationAccessGrant.CompanyID AND dbo.ContactMaster.ContactIdentity = dbo.LocationAccessGrant.ContactIdentity GROUP BY dbo.ContactMaster.BmcCustKey ,dbo.LocationAccessGrant.CanAccessLocation ORDER BY dbo.ContactMaster.BmcCustKey It should take care of your null values "When did ignorance become a point of view" - Dilbert

....so then nothing changes between 2007 and sp 2010?

Assuming that every contact will have 1 or more counted record then use an inner join from your existing view to the count view and this will filter form the filter. If not then do a left join. Never underestimate the power of human stupidity RAH

Dimitry -- I now have to add one additional field but this one is harder. Each contact has an AccessGranted table tied to them with the locations they can access. I need to reduce that table down to a boolean CanAccess. How do I do something like that when I don't really have a customer key to work with. This is what my view looks like right now: SELECT TOP (100) PERCENT dbo.CustomerMaster.BSACustomerKey, dbo.ContactMaster.ContactName, dbo.ContactMaster.BusinessPhone, dbo.ContactMaster.MobilePhone, dbo.ContactMaster.Email, dbo.ContactMaster.FirstName, dbo.ContactMaster.LastName, dbo.ContactMaster.EmergencyMaintenance, dbo.ContactMaster.NormalMaintenance, dbo.ContactMaster.NetworkAbuse, dbo.ContactMaster.IssuedSwipeCard, dbo.ContactMaster.CardNumber, dbo.AddressList.CustomerAddressLine1, dbo.AddressList.CustomerAddressLine2, dbo.AddressList.CustomerAddressLine3, dbo.AddressList.CustomerPostBox, dbo.CityEnumerator.City, dbo.StateEnumerator.State, dbo.AddressList.CustomerCounty, dbo.AddressList.CustomerCountry, dbo.AddressList.CustomerZipcode, dbo.ContactMaster.BmcCustKey, CASE WHEN dbo.ContactMaster.Role = 1 THEN 1 ELSE 0 END AS IsAdministrator, CASE WHEN dbo.ContactMaster.Role = 6 THEN 1 ELSE 0 END AS IsDecisionMaker, CASE WHEN dbo.ContactMaster.Role = 5 THEN 1 ELSE 0 END AS IsAccountingAP FROM dbo.ContactMaster INNER JOIN dbo.CustomerMaster ON dbo.ContactMaster.CompanyID = dbo.CustomerMaster.CustomerIdentity LEFT OUTER JOIN dbo.AddressList ON dbo.ContactMaster.ContactAddress = dbo.AddressList.AddressIdentity LEFT OUTER JOIN dbo.CityEnumerator ON dbo.AddressList.CustomerCity = dbo.CityEnumerator.CityIdentity LEFT OUTER JOIN dbo.StateEnumerator ON dbo.AddressList.CustomerStateorProvince = dbo.StateEnumerator.StateIdentity WHERE (dbo.CustomerMaster.CustomerStatus = 1) AND (dbo.ContactMaster.Status = 1) ORDER BY dbo.CustomerMaster.BSACustomerKey

My date/time compendium[^] holds that and much more. :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Getting an article published on CodeProject now is hard and not sufficiently rewarded.

Here are the reasons I was not getting these properties generated in my code: One table was defined to have only a single record in it. So I did not define a pk. But as a diner says: No PK, No Shoes, No Service. So I added a primary key to that table, put slippers on when I rebuilt the project and got my property change implementations. The other table required some off-the-wall thinking. I was connecting to the server with my network ID and I was the CRM administrator on the server....within the application. But as far as the server goes I had read-only rights to the table. Once I gave myself full rights to the table, I got IPropertyChanging, IPropertyChanged implementations in my code. So the lesson from this is 1) give your network ID full access to tables and 2) always give the bugger a primary key!

:laugh: It looks like you ran into exactly my issue. I have a keytracker table doing the same thing and it wasn't updating and I wanted to pull out my hair. Just change your table def as so: KeyFile primarykey int default 666 KeyPrefix ... KeySuffix ... I then always get my record with the 666 key and my update logic works! :doh:

You're right, I don't know anything about Linq to SQL ;P

Did you even bother to read the previous answer from Mycroft? SELECT dbo.CustomerMaster.BSACustomerKey, dbo.ContactMaster.ContactName, dbo.ContactMaster.BusinessPhone, dbo.ContactMaster.MobilePhone, dbo.ContactMaster.Email, dbo.ContactMaster.FirstName, dbo.ContactMaster.LastName, dbo.ContactMaster.EmergencyMaintenance, dbo.ContactMaster.NormalMaintenance, dbo.ContactMaster.NetworkAbuse, dbo.ContactMaster.IssuedSwipeCard, dbo.ContactMaster.CardNumber, dbo.AddressList.CustomerAddressLine1, dbo.AddressList.CustomerAddressLine2, dbo.AddressList.CustomerAddressLine3, dbo.AddressList.CustomerPostBox, dbo.CityEnumerator.City, dbo.StateEnumerator.State, dbo.AddressList.CustomerCounty, dbo.AddressList.CustomerCountry, dbo.AddressList.CustomerZipcode, dbo.ContactMaster.BmcCustKey FROM dbo.ContactMaster INNER JOIN dbo.CustomerMaster ON dbo.ContactMaster.CompanyID = dbo.CustomerMaster.CustomerIdentity LEFT OUTER JOIN dbo.AddressList ON dbo.ContactMaster.ContactAddress = dbo.AddressList.AddressIdentity LEFT OUTER JOIN dbo.CityEnumerator ON dbo.AddressList.CustomerCity = dbo.CityEnumerator.CityIdentity LEFT OUTER JOIN dbo.StateEnumerator ON dbo.AddressList.CustomerStateorProvince = dbo.StateEnumerator.StateIdentity WHERE dbo.CustomerMaster.CustomerStatus = 1 AND dbo.ContactMaster.Status = 1 ORDER BY dbo.CustomerMaster.BSACustomerKey ASC