Wappie29's Q&A profile

• SQL Server What exactly can sp_executesql parametrize?

  I am attempting to create dynamic SQL with sp_executesql. However, it seems that parameters can't be created arbitrarily in the query string. In particular, the name of the table apparently can't be parametrized, or I am doing something wrong. I use SQL Server 2000 with the latest service pack. The table task has a few columns of which TaskID is Primary Key and INT. This works fine: DECLARE @pot nvarchar(200) SET @pot = 1 DECLARE ...Show All

• Visual J# 100% CPU usage !!

  hellow to all .. i am runing visual j++ 6.0 on my centrino 1.6 and 512RAM ... and i am amesd that the j++ take 100 CPU usage and i can't even use it the laptop is so slow and i can not function at all !! not just on my laptop , my friends tould me the same !  i am runing windows xp sp2 .. hellppp !!! I've found a fix here: http://forums.asp.net/574242/ShowPost.aspx I had to delete my breakpoints.  I clicked the Debug drop-down m ...Show All

• Visual Studio 2008 (Pre-release) How to Serialize an Interface?

  I've got my service contract interface and it's implementing class set up and working. One of the things I want to be able to do is allow the service to send a custom class/type to the client. However I don't want to use the actual class I want the service method to return an interface that is implemented by the class. // Works public Person GetPerson() {} //Doesn't work public IPerson GetPerson() {} //where [ServiceContract(Name = "Ech ...Show All

• Windows Forms Displaying Flash with webbrowser control res protocol...doesn't work....why?

  I'm not sure where to ask this question....but had to pick somewhere... I embedded my website in a resource file...all files embedded using RC.exe. Unfortunately, now I discover that the swf files don't display. Just an empty box.  Assuming you're using  ...Show All

• SQL Server MSMQ & Integration Services

  I have a SSIS package in SQL Server 2005 that attempts to publish some data into a MSMQ Private queue located on another machine. While I was creating the package the connection string was pointing to the local server something like: localhost\private$\csin Now I'm trying to get to the remote machine but I'm not sure what type of connection string I need to enter: I tried: mw59\private$\csin where mw59 is the name of the remote mach ...Show All

• Windows Forms TreeNode label

  Hello, If I have a label in the edit mode, and the user makes a text selection, is there a way to capture the selected text only. There is an attribute on the text box that does that. Thank you Hi, I don't know the direct answer you're looking for, though I am sure there is an API you could use to get that information. Instead, have you considered using a TextBox and setting its properties to make it appea ...Show All

• Visual C# PixelFormat: why no 8bppGrayscale ??

  Hi All, I am trying to convert 8-bit grayscale TIFF to JPEG using the Bitmap class as intermediary; [.NET Framework 1.1] but there seems to be a puzzling omission in the PixelFormat enumeration that describes the possible types of Bitmap: there is no 8bppGrayscale ! (8 bits per pixel Grayscale). As is, my grayscale TIFF becomes a Bitmap with the 8bppIndexed PixelFormat by default. That's no good, because the subsequent call to myBitmap.Save(file ...Show All

• Smart Device Development Can u use managed stored procedures in sql server 2005 mobile edition

  Is this possible Thanks No, there are no stored procedures in SQL Mobile. ...Show All

• .NET Development ODBC Adminstrative tool in Windows Server 2003, Drives are not visible

  Hi I have Windows Server 2003 with Citrix and I have installed Oracle 10 and MDAC 2.8 When I want create a new data source with ODBC settings, I don't see drivers. The drivers are in the registry. risto Hi, Goto SysWOW64 folder and , from there launch odbcad32.exe This will open the ODBC Administrative tool for 32 bit drivers. Regards, Mahesh B. ...Show All

• .NET Development Client Certificate Storage Location

  Can anyone tell me if I download a user cert and import it in the Personal Storage what Registry key does it getting written to I have tried to run RegMon but without much success. Any help is greatly appreciated. The "personal" (aka "my") store is not in the registry, but in the user's profile.  The physical location of the stores are implementation details and may change at any time, so we do not recommend relying on ...Show All

• Visual Studio ReportViewer Flicker

  Hi, Is there a way to prevent my ReportViewer Control to flicker when I call ReportRefresh I have tried using DoubleBuffer on the form as well as SuspendLayout/ResumeLayout but it doesn't seam to have any effect. // Johan Bellander I have disabled "ShowProgress" so the "report is being generated" isn't displayed. I tried your suggestion and placed ResumeLayout in RenderingComplete, but it didn't have any affect. So if you or an ...Show All

• Visual Studio 2008 (Pre-release) Parametric Animation

  Is there some documentation I can refer to concerning parametric animation What I would like to do is feed in the value of the animated property at every "tick" based on a function. Actually...what would be even sweeter would be to have a "parametric animation object" that takes a function pointer to my parametric equation and then handles the rest for me! But I'll stick with being pointed to some details on doing it by hand. ...Show All

• Software Development for Windows Vista Workflow instance does not exists

  I have a workflow that hosted under a windows form application. The workflow is published as a web service. The winform client sends a request to the workflow and the workflow logic may escalate the request to a manager by sending an e-mail with an InfoPath attachment. The manager approves or denies the request through InfoPath. The issue that I am having is when the web service request comes to the workflow, I am receiving there is no workflow ...Show All

• Visual Studio 2008 (Pre-release) Bug: using a bool property in WHERE doesn't always work

  Hi, I think I've found a bug in the DLINQ expression tree-to-SQL mapper. It's an obvious enough one so I guess you've already fixed it, but I want to make sure it doesn't continue to bug me in the next release . The third sample from 101 LINQ samples, when the condition "!p.Discontinued" is changed into "p.Discontinued", produces a strange SQL like "CONVERT(Predicate,[t0].[Discontinued])". It does work when &q ...Show All

• Visual Studio Express Editions Cannot create a new project that opens startup form

  Have been using vb 2005 express final now for a week or too.  Have had no problems using and modifying example code and connecting to a MySQL database.  However i am now trying to create a new project and no matter what form is selected under startup form nothing displays when code f5 is pressed.  Message that build is ok in status bar screen refreshes and back to IDE.  However existing projects work ok.  Even creating a ...Show All