Joe A.'s Q&A profile

• SQL Server How to code DateTime-Literal in SQL Server

  Hi, I'm a newbee to SQL Server. I have a very simple question to you experts: How should I code a literal of the "datetime"-Datatype For Example in the VALUES-clause of an SQL-statement. I have tested several "formats" ('20.04.2006 11:15:00' with an 4-digit year enclosed in single apostrophes) but all i earned is an exception! Any help very appreciated! Thanks in advance and best regards Reiner PS.: I'm using ...Show All

• Visual Basic Most wanted code snippets and resources

  Hi Everyone, We'd like to hear your ideas and opinions on Intellisense Code Snippets . - Which new code snippets would be most useful - Which code-snippet categories already in Visual Studio would need additional code snippets - What new snippet categories would you add to the ones already in Visual Studio - Which code snippet resources would you find most useful in your everyday experience using, authorin ...Show All

• SQL Server How to quickly evaluate SSIS, programmer perspective

  SSIS looks interesting .  I haven't loaded any Yukon or read the 2005 BOL, so I'm coming in with a clean slate. In the past I have found the graphical programming interface for DTS, limiting, annoying and unnatural.  I much prefer coding in an OO language the conventional way. I'm interested in evaluating SSIS as quickly as I can.  The ideal is programming with a standard .NET language.  I am happy if a de ...Show All

• SQL Server Deploying Analysis service solution

  Greetings, How do I deploy an Analysis services project on to diference machines. I have followed the process laid out in MSDN and changed the server to the remote server name while deploying. It throws up an error that the user does not have permissions to create objects on remote server. Please help me understanding the process of deployment and how the analysts can open up the deployed cube in their machines Thanks/Regards Shiv ...Show All

• Windows Forms Add controls to a child control at design time.

  Does anyone have a solution to this problem: When implementing a ControlDesigner or ParentControlDesigner, if one has a UserControl that contains child controls as follows: +========UserControl=========+ | +-----------------------------------+ | | | Caption Panel | | | +--------------------------------- ...Show All

• Windows Forms EventDescriptor and discovering attached handlers?

  Given an EventDescriptor, how do you discover the attached event handlers I had orginally thought this might be impossible since you don't know how the event is implemented (i.e. it might not be backed by a Delegate) but I suspect CodeDomSerializerBase.SerializeEvents is doing it somehow.   Thanks, Ray This IEventBindingService appears to allow me to bind to events easily but it does not appear to give ...Show All

• Visual Studio Team System TeamBuild pulls entire source tree, not just what is needed

  Hello, I have an automated build configured in TFS Beta 3 Refresh with 2 solutions (1 set as a dependency of the other). The overall TF project contains multiple solutions, some of which have been deleted (of course not permanently, since we can't currently do that). When the build runs it pulls the entire source tree over to the build server during the "Getting Sources" step, even though about 60% of it is not needed. Is there a wa ...Show All

• Software Development for Windows Vista Dialog Box Shadow

  Is there any way to get a shadow drawn under a dialog box with no frame. Prior to Vista I used a thin frame, which gives a shadow, but under Vista the thin frame is thick and allows selection and dialog box movement, thus I now have to use no border to get a non-moveable dialog box. As far as I'm aware, dialog boxes never had a shadow, regardless of frame thickness, so I don't see how you were getting this on Windows XP either. (And frame t ...Show All

• Software Development for Windows Vista Windows Photo Gallery Problem

  I dont know what happened, but When the Photo Gallery isnt in Slideshow mode. it will not display the picture i want to see like so.... IMAGE As you can see, it says the picture SHOULD be displaying but it isnt. Can someone help me troubleshoot this it doesnt matter, all images will not Display. bmps, gifs, jpgs, jpegs, png, etc. ...Show All

• Visual C# asp.net

  hello i have an asp form in which i have added checkboxes for a field "hobbies". now i want to retrieve the values of all the checkboxes that are checked, in another asp form. can anyone help me how i can do that thank you If you want your results to be viewed in other aspx you need to use CrossPagePostBack.... But if it is on the same page then foreach(Control ctrl in Page.Contro ...Show All

• Windows Forms No Animals teleport to my machine.

  Hello there! I've already read a lot of these problems on other postes but none of the solutions seems to apply. I'm behind a firewall, the 50000 port is redirected to my machine and the redirection seems to be ok according to the online Port&n ...Show All

• Visual Basic Screen.BitsPerPixel VB 2003

  VB 2003 Hi. I'm looking to detect the screen color depth when my application launches. I'm told that Screen.BitsPerPixel should work but it doesn't appear to be a memeber of the system.windows.form.screen class. Further research seems to indicate that it is only available using the .Net 2 Framework... Is there anyway I can get this to work with VB 2003 or do I need VB 2005 Neil. Try Screen.Primar ...Show All

• .NET Development TableAdapter Update problem

  Hello, i have problem in my application. I create dataset with single table. In MainForm i have 2 texboxes and update button. This is code for update button: [CODE] Klient klient = new Klient(); klient.ShowDialog(); KlientDataSet dataSet = new KlientDataSet(); Serwis.KlientDataSet.KlienciRow klientRow = dataSet.Klienci.NewKlienciRow(); klientRow[0] = Guid.NewGuid(); klientRow[1] = klient.Imie; klientRow[2] = klient.Nazwisko; ...Show All

• Windows Forms Save position in DataGridView after refreshing

  I have DatagridView on a form. When user click to save changes I save tham and then re-red data agin to reflect latets updates from database. Question how I can return pintor on current record after refreshing Otherwise user clicj save and find himself on first row of DataGridView. It is really annoyning scrol to old position especially on big table Thanks here we go http://www.dotnet247.com/247reference/msg ...Show All

• Visual Studio Team System Getting an Error while acessing Work items in MSProject.

  Hi, We installed VS 2005 April CTP with team foundation client  We can able to access the team projects in vs 2005, team explorer. In MS Project, we could able to access the team projects, on selecting one of them and trying to retrieve the work items we are getting an error "Unable to retrieve data from the work items database server". This works with the TFSSETUP user, but not with another user say "Developers".& ...Show All