pittpantha's Q&A profile

• SQL Server Retriew number of sunday,s for a given month in sql server

  hello i am student and developing project having the fallowing problem 1: i want to calculate the number of sunday,s in a given month. OR between two given dates like 01/02/06 and 28/02/06 . thanks Hi, this should solve the problem, input is the day of the week you want to get. CREATE FUNCTION NumberOfWeekdays ( @StartDate DATETIME, @EndDate DATETIME, @Weekday TINYINT ) RETURNS INT BEGIN DECLARE @dt DA ...Show All

• Visual Basic checkbox problem

  Can anyone help me find information on how to handle check boxes and groupboxes I'm new to visual basic. Any suggestions are much appreciated. Thanks a lot in advance Alex What part do you want to know Checkboxes have a property to tell you if they are checked, and fire an event when they change. If you google with site:msdn.microsoft.com, you can search the microsoft docs for more info. ...Show All

• Visual C# I need information aboud .NET in Denmark

  Hello. I am looking for information about salaries of .NET developers in Denmark, links to websites with job offers (in Denmark) and companies which use .NET technology. Can anyone help me Best regards Marcin Obel Hi, These forums are for posting questions related to programming issues in .net. Please look into career websites like www.monster.com or www.dice.com which will give you a better inf ...Show All

• Windows Forms PNG pictures in pictureBox

  I've tried to add a transparent PNG to a picturebox but i can't get it to work. It looks good in the form-designer but when i start the program i only get a grey box. I've tried with a PNG that's not transparent and it also looks good in the designer but this time i get a black box when i start the program. Is it possible to use (transparent) PNGs in pictureboxes and how do you do it It should wor ...Show All

• SQL Server Problem creating an enumerator?

  Hi, I tried to create an enumerator using Vb.NET but it will give me an error in this statement: <DtsForEachEnumerator(DisplayName = "LSParseEnumerator" , Description = "Returns an Enumerator by separating items in a String by a certain character" , UITypeName = FullyQualifiedTypeName , AssemblyName , Version = 1.00.000.00 , Culture = Neutral , PublicKeyToken = "" )> _   The error is in the Version = 1.00.0 ...Show All

• Visual C++ Platform SDK help files

  I downloaded and install the latest Platform SDK, and compiled a sample, it works fine. (under Visual C++ 6) Now I'd like to visit the Help files to get more information about the APIs and other useful information. However I don't know have how to view / open these help files (Help 2). After a desperate huge search over the Internet, I rely on this forum to get some help. Thank you. I had the same problem ...Show All

• Windows Forms AppUpdater and IIS6 problem

  Hi, I am using the AppUpdater-component as used in the TaskVision app.  Since moving to IIS6, it stopped working.  I found that it is unable to load my .exe-file.  IIS6 keeps responding it cannot find the file.  Has anyone experienced this ...Show All

• SQL Server key columns heeeeeeelp

  hi i need some help,, i have a dimension like this: dimgeo fiDWHgeoid as my primary key and these attributes ficanalid fidivisionid figciaid with thier description fields: fcdesccanal fcdescdivision fcdescgcia the problem: how can i make a unique key that includes the three id`s i listed in only one and unique key so when i browse my cube it will display the correct match.. i'm really really new in this, i saw a property which is key ...Show All

• Windows Forms DataGridView: why not remove new row when saving?

  I have a DataGridView bound to a BindingSource which in turn is bound to a collection of objects. In the BindingSource's AddingNew event, I will create a blank object, like this:     private void myBindingSource_AddingNew(object sender,         AddingNewEventArgs e)     {         MyClass obj = new MyClass();         e.NewO ...Show All

• Visual Studio Team System Error 32000 TFSSetup Application tier

  Hi, I tried to install Team Foundation Server (CTP July) with SQL 2005 (CTP June DEV). The Data-tier installation worked well. There are 3 Windows 2k3 Server participating(DC, App, SQL). All of them are running in a Virtual Server environment. But during install of the application tier I got the following Error: file - dd_vsinstall80.txt: [08/30/05,13:52:37] vs70uimgr: DisplayMessage_START:Error 32000.Failed to execute action. last r ...Show All

• SQL Server Management Studio Gets Disconnected While in Standby

  Hi, I installed MS SQL Server 2005 Developer Edition on my laptop.  With MS SQL 2000, I can create temp tables and then put my laptop into standby mode.  When I come back and wake up my laptop, the temp tables will still be there because the query analyzer does not get disconnected from the standby mode.  With the new SQL Server 2005 whenever my laptop goes to standby mode, the management studio gets disconnected. A ...Show All

• Visual C# Events

  Hello, I want to learn how can I realize if an eventhandler is attached or not For ex, I want to learn if something is atteched to PutFileProgress or not. private void button1_Click(object sender, EventArgs e) { if (m_object.PutFileProgress == null ) MessageBox.Show("Available"); } Compiler complains about this code,stating that only += or -= operators can be used with an event. Thanks. Only the class t ...Show All

• Visual Studio Express Editions C# Express Namespace error in example code

  I am using C# express edition 2005. I am trying to execute the following example " How to: Use COM Interop to Create an Excel Spreadsheet ( C# Programming Guide)" at link: ms-help://MS.VSExpressCC.v80/MS.NETFramework.v20.en/dv_csref/html/d5d0eda3-6817-4b03-8b26-42ced3975b18.htm I follow the example by 1.)create the console project named CreateExcelWorksheet 2.)select project and add reference "Microsoft Excel 11.0 O ...Show All

• SQL Server About Indexes & Where caluse

  Hi, I am struggling with the sequence of parameters in my where clause. In my databse table i have index on Broadcast_Date(some table field).The Index also include some other parameters which might become part of where clause. The first field of the index is broadcast date. So I want to know whether it is always compoulsory to have broadcast date as my first field of where clause. Will it not scan the index if my where clause is ...Show All

• Software Development for Windows Vista Questions about vista

  I dont have vista beta or anything, but I would just want to know a few things(for those with beta or anyone that can answer), and some comments to make. Comments: 1. I am hoping that windows vista will make it so Sticky keys is off automatically, as I find it annoying(along with everyone else I know) and its a pain to turn off, because when I say turn off following the instructions, its still on until about the 3rd time I turn it off. 2. ...Show All