Ok, I tried converting the following query into a LINQ outerjoin query select b.sProgID,a.sProgName1, a.nProgCode, b.bCurrentPrgrm from ABA.dbo.ResidentProgram as b left join ABA.dbo.Program A on A.sProgID=B.sProgID and A.nProgCode=B.nProgCode where b.nSSN = ? and bCurrentPrgrm = -1 and a.sProgID = b.sProgID I got upto the following before I had to post in here.. var q = from c in _DbAba.ResidentPrograms join o in _DbAba.Programs on c.sProgID equals o.sProgID into ps from p in ps.DefaultIfEmpty() select new { What I cannot figure out is how to translate the "A.sProgID=B.sProgID and A.nProgCode=B.nProgCode" into LINQ....Any help or advice would be greatly appreciated.

Sorry this maybe in the category of esoteric ..but has anyone ever developed an application that connects to merchantconnect to download reports. If so what is the website address. I ran around in circles till I threw up trying to get hold of anyone in the dev team @ merchantconnect.

Thank half-life. I was aware of the second way as well. I was experimenting with a few things so I thoiught of this CheckForIllegalCrossThreadCalls = false; thing I read on codeproject a while ago.

Found what I was looking for. It took a little while to do the right search. http://www.codeproject.com/KB/user-controls/AlternateMultithreadedGUI.aspx. The property I was looking for is CheckForIllegalThreadCalls = false. Back to drinking,

There was an excellent article that someone wrote on relation to updating GUI from a seperate thread. This article related to setting a property called RaiseExceptionOfSomeKind = false. Very simple yet very effecient. I am sad to report that I am blanking out compeltely on that article. If someone has the foggiest idea as to what am I talking about please post a link. This is what happens when you give up drinking..amnesia. Thanks

Ok here's the deal: I am testing / mocking up calling a Moss2007 webservice from a windows form and populating a listview with the results. Very simple( at least that's what I thought). Here is the code: webSvcWebs.PreAuthenticate = true; webSvcWebs.Credentials = System.Net.CredentialCache.DefaultCredentials; //new System.Net.NetworkCredential(mysignon, mypassword, mydomain); XmlNode sites = webSvcWebs.GetWebCollection(); here webSvcWebs = "http://rvisp02/\_vti\_bin/webs.asmx". Well as you can see above I have tried both credential ways and I still get the 401 unauthorized error. Any ideas. I seeing to be running out of them. Thanks for your help. Sameer

ok, good people..i have a following line of code.. using( MemoryStream mStr = new MemoryStream( ) ) { try { mStr.Capacity = totalByteCount ; } } Of course the dude i got inherited this code from is trying to put 141372000 in the memory buffer i.e the capacity. At this point i get the following error Exception of type System.OutOfMemoryException was thrown." } I am at a total loss. Have tried different things...So i throw a hail mary over to the code porject dudes. Thanks for your help Sameer

Well the QueryDataset is a type dataset and that does not implement te ISeralizable interface by default and I am pretty positive that casting QueryDataObject to a QueryDataSet maynot by me much, but I am going to try to implement the Iseralizable interface on the QueryDataObject and see what happens.

Ok, I have inhertied a some code in which I find that the previous developer has done something I do not agree with but..I have to work with what I have got. There is a typed dataset called QueryDataSet and there is an object called QueryDataObject that inherits from QueryDataSet. In the development enviorment all is well mbut when I get to my executable, I get the following error: "The constructor to deseralize an object of type WTI.Fortis.QueryDataObject was not found". I am thinking that the previous developer was changing the constructor protected QueryDataSet(SerializationInfo info, StreamingContext context) { that is genereated as a result of me autogenerating the dataset to public. Any thoughts on this matter would be greatly appreciated. Sameer

Hello everyone, I have inherited a piece of code that is using a resx file to embed icon in it. These icons are then used in a class. The icon node looks something like this iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 .... Well, I have never done anything like this before, but i need to add a "+" icon to my app. How do I go about getting the "binary value" for my icon. Any help would be tremendously appreciated. Thanks Sameer

Ok, I have an assignment in front of my that demands that I build a sql statement on the fly and then populate a listbox. No problem , except only retrieve say first 100 rows. Then as the user hits the right scroll retrieve 100 more at a time till such time no more rows are left. Any examples out there or suggestions. Thanks:^)

Ok,I have a generic Treeview component that I have inherited and it has the following error. When I try to click on the X on the control bar I get the following error: External component has thrown an exception. Here is the stack trace.. at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.ComponentManager.System.Windows.Forms.UnsafeNativeMethods+IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(ApplicationContext context).... I have traced this error to the SendMessage fuction i.e the following line [DllImport("user32.dll")] private static extern int SendMessage (IntPtr hWnd, int wMsg, IntPtr wParam,int lParam); If I comment this out in the code and all calls to this function it works fine. Any ideas on the correct fix for this. As always all help is appreciated. Sameer:^)

ummmmm just call DataAdapter.fill( Dataset ). That Shoot take care of it. If that does not, then you shoot the machine.

Ok, I have a listview and a treeview. Gif's are being dragged from Listview and borught over to the treeview. I have managed to create a Ghost icon of the GIF when the user clicks on the picture, but the problem I have is that when drag starts, the ICON changes from the ghost icon to the default NO cursor. When it gets in the treeview, its the drag icon. Can someone suggest as to where I may be going wrong. I can obviosuly post codes snippets, butI am not sure it will be of any help. Its something more basic as to the dragdrop effects that I am not setting. I mean the drag drop works, the Ghost ICON, would be the icing on the cake. Thanks for any input. Sameer

:confused:It's a good thing that I am familair with Oracle DBA stuff. Then again DB's are DB's its just a different way of doing things. I have already made backups of our MDF file, the transaction logs. I am not sure where the redo logs of Sql server are. Working on figuring that out.

:laugh:Cool thanks it seems to have worked, I am a c# guy being forced to act as a DBA for the time being. Good experience none the less.

I wish it was a joke, but our DBA passed away. Till such time we find a new DBA, I am the man. I have this script: exec sp_droprole 'SAM_USER' exec sp_addrole 'SAM_USER' exec sp_droprole 'Manage_Presentation' exec sp_addrole 'Manage_Presentation' grant select , insert,delete , update on Presentation to Manage_Presentation grant select , insert,delete , update on Presentation_Menu_Link to Manage_Presentation grant select , insert,delete , update on PresentationOwner to Manage_Presentation grant select , insert,delete , update on PresentationSlide to Manage_Presentation grant select , insert,delete , update on PresentationSlideOverride to Manage_Presentation grant select , insert,delete , update on PresentationSlideVerticalMenu to Manage_Presentation exec sp_addrole 'Manage_Slides' grant select , delete , update on dbo.Slide to Manage_Slides grant select , delete , update on dbo.Slide_Menu_Link to Manage_Slides grant select , delete , update on dbo.SlideComment to Manage_Slides grant select , delete , update on dbo.SlideFile to Manage_Slides grant select , delete , update on dbo.SlideType to Manage_Slides grant select , delete , update on dbo.SYSFile to Manage_Slides exec sp_addrolemember 'SAM_USER','Manage_Presentation' exec sp_addrolemember 'SAM_USER','Manage_Slides' --create user section of the database exec sp_addlogin @loginame = 'Sameer',@passwd = 'Sameer',@defdb = 'SAM_DEV' exec sp_grantdbaccess 'SameerHanda' exec sp_addrolemember 'SAM_USER','SameerHanda' Well all well and good, but when I signon as Sameer and do the following select * from Presentation, I ge this error: SELECT permission denied on object 'Presentation', database 'SAM_DEV', owner 'dbo'. Well what am I missing. Any help would be greatly appreciated Thanks Sameer PS: RIP Kev Dawg :((

Actually I am an idiot...the problem was in my DAL. When I wrote this function called RunSqlReturnDS( string cmd , table ) well lets just say I hardcoded the table array position..i.e m_dataHolder.Tables[0].Rows..you get the idea. So, it was returning rows from the previous run of the function.

Ok maybe I am going dumb here, but I cannot for the life of me figure this problem out. In the MSDE database there is a column called Slides. In that Slide table there is a Version column. Which is defined as a string. It contains data like 1.0.0. Well i am trying to create a typedataset where I just dragged and dropped the Slide table from the server explorer. That being said, when I go in for the Fill command, I keep getting the InvalidCastException. I tried changing the column types to double etc...but no go. Any suggestion. Thanks Sameer

Ok, I am trying to retrieve a list of names from the database and based upon the number of rows retrieved from the DB, I am trying to do the following: 1. Instantiate a array of command buttons. 2. Add those command buttons to the list view. I am assuming step 2 is possible since the item property is a collection of objects, I can add anything I want to add to it. Well it works fine except instead of actual command buttons, I am seeing the following , "System.windows.forms.Buttons, Text="rwqr"" What am i doing wrong.