detzX's Q&A profile

• Visual Studio Team System Writing a better test advice

  -- DDL CREATE TABLE [dbo].[users] ( [user_id] [int] NOT NULL IDENTITY(1, 1), [username] [varchar] (288) NOT NULL, [firstname] [varchar] (200) NOT NULL, [lastname] [varchar] (200) NOT NULL ) ON [PRIMARY] CREATE PROCEDURE [dbo].[UserGetInfo] ( @username varchar(288) ) AS SET NOCOUNT ON SELECT user_id, username, firstname, lastname where username=@username -- database unit test for dbo.UserGetInfo DECLARE @username VARCHAR (288) SELECT @userId = -1, @username = NULL DECLARE @locUserId INT DECLARE @locUsername varchar(288) SET @locUsername='testuser' insert into users (username,firstname,lastname) values (@locUsername,'test','user') select @locUserId = SCOPE_IDENTITY() EXEC [dbo].[UserGetInfo] @locUsername In the p ...Show All

• Visual C++ vector::resize causes floating point exception

  Hello, I'm hoping for a reality check here. The following program generates a floating point exception in the vector::resize call. I compiled it under VC 2005 using the command line in the comment below. I've disassembled the executable and found that vector::resize creates a default Point object which is then copied to the new empty elements at the end of the vector. But note that the Point constructor doesn't initialize the x and y members. This means the bits are garbage, and vector::resize will copy the garbage to the new elements. This is no biggie because I don't use the uninitialized elements. However, the problem is that the compiler uses the floating point processor to copy the doubles. Whe ...Show All

• Gadgets Pre-instalation of Gadgets for all users

  Hi, I need to create a disk-image of a Vista system that will be put on several computers and there a sidbar gadget that is supposed to be pre-installed for every user. I tried installing the gadget as administrator, but if a new user opens an account on the computer the sidebar is wiped clean. Do you know if there's a way to have a widget installed for all users Thanks. Hi, thanks for the idea, but this is a little bit different solution, than modifying the Program Files contents. And I don't think these gadgets will be available for any already existing user, do they ...Show All

• Visual Basic Cascading combo lists

  Does any one know how to create cascading combo lists where in one combo list, you select a product and another combo list would display the sub-products/subcategory related to the product. How would the database design work so that the information can be correctly displayed in the combo lists. I have been trying to get my head around implementing this, but I have not found any suitable answers on the web. Any help would be great. Regards Dipendra you can declare the connectionstring globally and use that than having to create multiple instances of them. Example:   public class myClass    private connectionString as String = "connectionString"    ... ...Show All

• Visual Studio Express Editions how some help fix my code?

  'Create a new MailMessage object and specify the"From" and "To" addresses Dim Email As New System.Net.Mail.MailMessage(" From@abc.com ", " To@abc.com ") Email.Subject = "test subject" Email.Body = "this is a test" Dim mailClient As New System.Net.Mail.SmtpClient() 'This object stores the authentication values Dim basicAuthenticationInfo As _ New System.Net.NetworkCredential("username", "password") 'Put your own, or your ISPs, mail server name onthis next line mailClient.Host = "Mail.RemoteMailServer.com" mailClient.UseDefaultCredentials = False mailClient.Credentials = basicAuthenticationInfo ...Show All

• Visual Studio Express Editions How Do I Give the user a choice to stop a Popup From poping up Again

  Usualy my Post never get answered but maybe they will this time.. Im new to Visual Basic Express And i am trying to make my own internet explorer (I Has Watched all the tutorials And know a little bit... but i just started 3 days ago... and im Only 14) I made a dialog popup box informing the user on what they were doing... and that is bout it so far... what i really want to know is how can i make it so the user can choose if he wants the popup to not show up again by checking a box... i would really appriciate it if someone could help me with this... Thanks Well that fixed everything but Private Sub form1_load() Handles MyBase .Load Im still getting the error message: Erro ...Show All

• SQL Server Basic rounding question

  Hi, I've just started SSR2005 this week, and I'm unsure of how to round down a number in my expression. My code is: =reportitems!TotalSeconds.Value Mod 60 Basically, the total seconds could be coming in as 74.564, but I want the remainding seconds after dividing by 60. In other words, I would want to return 14, rather than 14.564. I have noticed that if I put N0 in the format, it rounds it up. Also I'm not sure how to use the round function, and it would appear to round up ( ). Can somebody help please Thanks, Dan. Hello Dan, Can you try this and see if it fixes your issue: =Floor( reportitems!TotalSeconds.Value Mod 60 ) Hope this helps. Jarret ...Show All

• Windows Forms Need to see code samples of using an ActiveX control from a Windows Form.

  Are there any examples in MSDN (or anywhere else) that show using an ActiveX/C++ control from a Windows Form I'd like to see some non-trivial examples if possible. Tnx Mark ...Show All

• SQL Server temporarily drop FOREIGN KEY constraints to truncate a table

  I am testing Insert, Update etc. and messing up my database with "dirty" data. Is there a way to temporarily drop FOREIGN KEY constraints to truncate a table after testing without dropping the whole table and rebuilding it Newbie /**************************************************** This script creates 2 types of scripts: 1 - to drop all Foreign keys 2 - to re-create all foreign keys It actually does not drop them, just creates the scripts to the output Manipulate with Print statement to get one or another type of script, on lines 65 and 119 Play with them carefully !!! ****************************************************/ declare @fk_constraint_name sysname, @fk_ ...Show All

• SQL Server AS2K5. Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3267, function 'PFFileSto:HandleDataPageFau

  I have a simple query, that produce internal server error. Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3267, function 'PFFileStore::HandleDataPageFault'). WITH MEMBER [Product].[Product].Slicer AS [Product].[Product].&[ 214 ] SELECT ([Date].[Fiscal].[Fiscal Year ].&[ 2005 ]) ON COLUMNS, CROSSJOIN({[Product].[Days to Manufacture].[All Products],[Product].[Days to Manufacture].[All Products].children},{[Measures].[Internet Sales Amount]}) ON ROWS FROM [Adventure Works] WHERE ([Product].[Product].Slicer) Another MDX query produce wrong result. WITH MEMBER [Product].[Product].Slicer AS [Product].[Product].&[ 214 ] SELECT {([Date].[Fiscal].[Fiscal Year ].&[ 20 ...Show All

• Visual Studio Team System How to manage the files only on my local in TFS, without upload to server?

  I mean, I have some files only controlled by myself, so I don't wanna upload them to the server. How to achieve it Thx in advance. Hi: TFS Version Control does not provide versioning capabilities in the client machine only. All of the versioning takes place on the server so for you to get versioning you need to check-in the files. Nevertheless, we do support a client side isolation known as workspaces. Workspaces act as a sandbox for users allowing them to code without affecting server versions. In addition, we also provide shelvesets as a way to archive your work and files on the server. From reading your question, it seems that you want to use shelvesets to be able to backup your work withou ...Show All

• Visual Studio 2008 (Pre-release) Specifying config file to use at runtime in WCF client

  Hi, Is there any way of specifying at run time, the path/filename of client config file to use in WCF client proxy Here is my use case: I have a client that uses the generated client side proxy (proxy.dll). The generated proxy/config file are in a different location than the client process. We need to load the generated proxy using reflection (using LoadFrom) and invoke the service. When I try loading the client proxy and create an instance using reflection, I get an exception “ Could not find default endpoint element that references contract 'Foobar' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matc ...Show All

• Visual Studio Express Editions visual basic express problems

  what is the code to update a database, the code i use tells me an error the perameters that my book tells me are formname. datamembercontrolname.update(me.datasetname.tablename) the formname is the form that has the binding source which is mainview the datamembercontrolname is songfields the datasetname is reclistdataset the table name is songfields, but it has three fields artist; song; year; so i assume it wants the table name of the field that stores the data which is artist newrec is the name of the project addsong is the name of the procedure that instigates the update, so what does it not like ...Show All

• .NET Development is a .NET EXE a assembly?

  Hi can anybody tell me whether a .NET EXE is also an assembly Thanks Yes, a .net exe file is an assembly. From the MSDN page on assemblies: "Assemblies can be static or dynamic. Static assemblies can include .NET Framework types (interfaces and classes), as well as resources for the assembly (bitmaps, JPEG files, resource files, and so on). Static assemblies are stored on disk in portable executable (PE) files. " http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconassembliesoverview.asp Hope that helps -Chris ...Show All

• Smart Device Development can not find System.Data in Compact Framework 1.0 project

  Hello everyone, I have used Visual Studio 2005 to create a C# .Net Compact Framework 1.0 application on Pocket Pc 2003 device. But when building the application, there are some errors dealing with System.Data can not find. I have solved this issue by manually add System.Data from References of project, and it is working now. I am wondering whether we should manually add reference to System.Data in an application based on .Net Compact Framework 1.0 (Pocket PC 2003). thanks in advance, George VS 2005 adds reference to System.Data automatically for NETCF V1 project but not to System.Data.Common.dll. Last DLL includes some classes which are normally found in System.Data on desktop. ...Show All