laboremus's Q&A profile

• SQL Server help with a stored procedure

  here is my sp create proc [login] ( @email as varchar(200) @password as varchar(200) ) as begin select customerid from customerlogin where email = @email and password = @password End print 'Welcome' print (@email) End This works fine, but if the email is wrong, what do I need to add to this to print that the email is wrong and not print 'welcome email' Help, please..... create procedure sp_login @email as varchar(200) @password as varchar(200) AS Select CASE WHEN ((Select COUNT(*) from customerlogin where email = @email and password = @password) = 0)                 ...Show All

• Windows Forms Why does Windows service just bomb out?

  I have a simple database read, The method handles exceptions correctly. But if there is an error in the query, my service just keeps running, but no error occurs and the service just stops working, even though it still appears to run. i.e if I call the following methods, and method2 has a query that returns an error. method3 or anything else never gets executed. method1(); method2(); method3(); Why is this In case anybody has this same problem, a simple restart of your computer, and a recompile of the service will do the trick. I only seem however to have this problem when working with MS Access. Maybe there is some bug in the OleDb Provider I've had this same issue on more than one devel ...Show All

• Visual Studio get subtotal value from matrix

  Hi! I have a report with a matrix and a textbox. I would like to get the subtotal value and show it in the textbox . Which expression should I place in the textbox to reference the subtotal of the matrix Thanks! ...Show All

• Visual Studio Express Editions how to build a web browser in build flash player like opera

  hi pls respond me quickly i also like how can we add tab at run time that is allowing the user to view more pages in web browser narasiman, What is the meaning of view more pages in web browser Would you like to see more contects or just some certain configurations on IE7 to see more tabs when you run the IE7 Generally speaking, when you close IE7 with several tabs, there is a dialog box shown after you click the close button. In the dialog box, you are asked "Do you want to close all tabs " with the follwoing two options: Open these the next time I use Internet Explore and Do not show me this dialog again. This piece of message will be shown when the RadioButton Show Options clicked. It means that the state of the Ra ...Show All

• SQL Server Custom dataflow component: How do you make properties editable?

  I have a custom component that takes in unicode stream and converts it to ascii text. However I would like to make my default string length and code page editable in the standard GUI editor. Right now I can set the default to 1000 characters, but when I try to change it, it says "Property value is not valid" Any ideas Thanks! I assume you define your property in ProvideComponentProperties Can you post the code just to be clear By default this is all you need to do, the property should then be listed in teh Advanced UI and also in the Visual Studio designer property grid. You would have to do some extra special stuff to make it read-only. I would check the data type of your property and se ...Show All

• SQL Server Advanced SQL Generation Options in VS2005

  Hi There im not sure if im in the right place but i was wondering why the above option is greyed out when creating a new sql datasource. This occurs even when i select all fields within the table (including primary key fields) Thanks Todd I'm not exactly sure which forum would be best for you  - you could try this one ... http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=7&SiteID=1   Donald ...Show All

• Visual C# Switch Statement vs. If-else if-else

  Hi Guys! Will I get better performance if I use a switch statement instead of If, else if and else statements ~Matt well apart from making the code more readable, it is apperent that the case statement will be faster than an if else statement. I found this to be interesting and think it may interest you: http://blogs.msdn.com/peterhal/archive/2005/08/12/451124.aspx ...Show All

• Smart Device Development getting GPS position from HP6915 PDA

  Hi, I am trying to write an app for WM5 .net CF 2.0. I am trying to communicate with the inbuilt GPSdevice. I need to retrieve just the current GPS position. What is the best way to do this any advice would be great. thanx. The GPS unit should be mapped to a serial port on your device. Then it is a simple matter of opening a connection to that serial port and the baud rate for your device. I'm sorry I don't have details for the 6915. If I am incorrect, someone please put me in my place :) ...Show All

• SQL Server SQL EXPRESS - WEB ASSISTANT Sp's

  I ve installed SQL EXPRESS ADV on fresh XP and I get this error when I try to run xp_makewebtask: Msg 17750, Level 16, State 0, Procedure xp_makewebtask, Line 1 Could not load the DLL xpweb90.dll, or one of the DLLs it references. Reason: 1114(error not found). (1 row(s) affected) I checked and xpweb90.dll is missing... but I do have the option to enable then... They took them out Or smthing is wrong on my pc (2 installations same problem) I also have a standard edition and developer edition wich are working fine. I tried to copy the files but I get same error /// Thks in advance for any help This has been removed from Express, there is nothing wrong with your computer. ...Show All

• SQL Server inquiry

  I just have a basic inquiry about sql server mngt studio. I have create about 50 tables under the Master database. i no longer want them there and would like to place all 50 of my tables into another database. The only way I can seem to go about doing it, is to go into the code and change "Use [Master]" to "Use [Quickwire]", where quickwire is my new database name. however, since there are so many tables this is a very tedious process. Is there an easier way...like a copy and paste concept Please let me know if there is.. you can use the "select into" statement with the 3 part naming convention use master select * into quickwire.dbo.dummy from dummy ...Show All

• SQL Server Problem in SCD transformation Using Oracle DataBase

  Hi, I am using SCD Transformation my source & destination is oracle database .while doing insert or update I am getting the following error. Does SCD support Oracle [ Slowly Changing Dimension [58]] Error: An OLE DB error has occurred. Error code: 0x80040E5D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E5D Description: "Parameter name is unrecognized.". please anyone help on this. Parameter name is unrecognized means What exactly we can do. Thanks & Regards, M.Jeyakumar I believe Oracle does not recognized parameters within SSIS. For an OLE DB Source component you can use variables ...Show All

• Visual Studio Express Editions Cloning an entry in a database

  I have coded an app that uses forms to populate word templates, specifically - budget proposals. I am in the process of linking this to a database and would like to know how to do one specific thing: I want to be able to add a "clone" command - this should use the currently selected entry and copy the contents to a new entry that the user can then modify for the ammended proposal. Any help would be appreciated. Dim ds As New TestDataSet ... Dim dr () As DataRow = ds . Tables (0).Select( "PrimaryKey = 1" ) OR Dim MyRow As DataRow = ds . Tables (0). Rows (0) ...Show All

• SQL Server Combining records/Foreach Loop

  I'm working on a data migration that requires combining rows/values from one table to update rows in another table, and I can't figure out if I need to do a nested FOREACH or something else. Here's the example. I have a table called Health that has a unique child record, key is childID. I have another table called Concerns that has multiple records for each child. The Concerns table structure has several Boolean fields that need to capture and retain a true value, no matter what the value is in the next record, i.e. once a field is true, it's always true. Then those values need to update the child record in the Health table. So if the Concerns table has the following records for a child: ChildID, DentalConcern, VisionConcern, H ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. EnumDevicesBySemantics

  I am working on a game and have run into a problem. When I call IDirectInput8::EnumDevicesBySemantics with this code: xDI->EnumDevicesBySemantics(NULL, &xDIActionFormat, &EnumDevicesBySemanticsCallback, hWnd, DIEDBSFL_ATTACHEDONLY); I get this error: error C2664: 'EnumDevicesBySemantics' : cannot convert parameter 3 from 'int (__cdecl *)(const struct DIDEVICEINSTANCEA *,struct IDirectInputDevice8A *,unsigned long,unsigned long,void *)' to 'int (__stdcall *)(const struct DIDEVICEINSTANCEA *,struct IDirectInputDevice8A *,unsigned long,unsigned long,void *)' The function has this prototype: BOOL EnumDevicesBySemanticsCallback(LPCDIDEVICEINSTANCE pdInst, LPDIRECTINPUTDEVICE8 pdDev, DWORD dwFlags, DWORD dwR ...Show All

• SQL Server Report Parameters creation via Code

  Hi, I have a report that that needs to be filtered by StartDate, where StartDate is the first day in the week of a specific year. The values will be each week of the year (52 weeks = 52 Start Dates) and the range of years is between 2006 (current year) back to 2003. My questions is how to generate these values for the StartDate parameter. I don't want to define actual database tables to store these values, as it seems like something I should be able to easily generate via some code. After trying it out for while and searching the forum, I'm starting to think I will need to statically store these parameters. Can anyone offer any advice on how to solve this parameter value generation issue Thanks, - Jim ...Show All