kalle vanska's Q&A profile

• SQL Server CSV String

  Hi, I have a variable like @states=NY,VA,AL,CA. Now i want to use the above string in the IN clause.How to separate those string and use. Select * from xxx where @State IN('NY','VA','AL','CA') Thanks in advance Here are a couple of pretty good references: http://www.sommarskog.se/arrays-in-sql.html http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=326300&SiteID=1 ...Show All

• Visual Studio Express Editions Visual Express Confusion? Very Basic questions!

  If I install Visual C#, does that mean I don't need to load SQL Server 2005 Express If I install Visual C#, does that mean I don't need to load Visual Web Does "Visual Studio 2005 Express" really just = = Visual Basic and therefore I will never need to download Visual Studio 2005 express because I'm not interest in VB at this point in time I'm just so confused as to what a person really has to down load with regards to Visual Express software. I desire is to only learn the language C#, to access an sql database and post the results on a web page. Really an intranet to start and then maybe full web application. But very simple to start with! I'm also confused with the various sample downloads: will the samples say the Adventure ...Show All

• Software Development for Windows Vista CardSpace & OTP (one time passwords)

  Hi, If you want to issue a managed card which is linked to an OTP system, what do you need to do Can somebody explain conceptually the steps needed to integrate OTP with CardSpace Thanks Jean The ws-* protocols that we use do not have a definition for OTP at this point. You have a couple of options: 1. Ask for the OTP out of band of the CardSpace user experience... Get the security token from CardSpace, and then ask for the user's OTP. 2. (ab)use the Username/password managed card type and use the OTP as the authentication factor instead of a password. g Garrett Serack | Program Manager |Federated Identity Team | Microsoft Corporation blog: http://blogs.msdn ...Show All

• Visual Studio Team System Virtual Users on a load test

  I still can't understand clearly how load test works...From what I know, when load test runs a set of virtual users are used to simulate the webtests...now my question is, what if my webtest includes a login process, does the load test still create virtual users If not, then is it correct to say that if a webtest in a load test involves a login, then I should use data binding on my web test to simulate multiple users logging in... Another followup to this would be...assuming we have a 10 user load...does this mean that 10 users are using 1 PC or 10 users are using 10 PCs I guess my problem here if 10 users are simulated using 1 PC, then how does load testing handle cookies Coz I tried manually simulating 2 users logging in and b ...Show All

• .NET Development Add SSL WebService Reference to VS.NET Project

  When i try add web reference to ssl webservice. the error 403 appear . How can i add reference to SSL webservice the error print screen attached . This problem is Microsoft Known BUG in VS-2003. but you can used the workaround. You must download the WSE 2.0 SP1, if you haven’t already ( http://www.microsoft.com /downloads/ThankYou.aspx familyId=dab3ad9f-be8f-42e1 -95fe-9aae41a487f3&displayLang =en ), and add a reference to Microsoft.Web.Services2 in your project. and you need change your code by adding mannualy the certificate to Instance of Webservice object, this is a sample code: using WseX509 = Microsoft.Web.Services2 .Security.X509; [...] // Create web servi ...Show All

• Visual Studio Express Editions How do you convert an array into a stream to make a bitmap?

  I am trying to make a bitmap from an array without setting each pixel and I all I could find for a bitmap is a stream and I thought I could serialize it somehow into a stream like this Dim memStream As New MemoryStream(size) 'memStream.Read(numb, 0, nums.Length - 1) 'LiveBitmap = New Bitmap(memStream) or Dim s As Stream = New Str Dim formatter As New BinaryFormatter Try formatter.Serialize(s, numb) or formatter.Serialize(memoryStream, numb) Catch e As SerializationException Console.WriteLine( "Failed to serialize. Reason: " & e.Message) Throw Finally End Try LiveBitmap = New Bitmap(s) or LiveBitmap = New Bitmap(memoryStream) ...Show All

• Visual Studio 2008 (Pre-release) video example not working

  public Scene1() { this.InitializeComponent(); MediaPlayer player = new MediaPlayer(); player.Open(new Uri("pack://application:,,/rock.wmv")); VideoDrawing aVideoDrawing = new VideoDrawing(); aVideoDrawing.Rect = new Rect(100, 100, 100, 100); aVideoDrawing.Player = player; player.Play(); I took this from the msdn page but changed the Uri as I had added a .wmv to the project. All I get is a blank screen. Any help would be great - thanks Hi barkest, pack://application doesn't work with a media file, but siteoforigin will. Also, You've mentioned "If I use MediaElement inside the xaml instead of using c# then it works fine". Could you show me that line of xaml Because I ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Source Control

  It appears there's no way to plug in source control in XNA Game Studio Express. Is there a fix for this coming up And supposing that there is no fix, is there a way to use XNA with a different IDE Thanks. The express edition of XNA will not plug into any of the retail versions of Visual Studio. However, theorectially you could manually use the XNA assemblies with the retail versions. But you will loose all support for the content pipeline tools that will be included in the release version of XNA. This has actually been one of the most asked questions on this board. If this feature is important to you, I would suggest takeing a look at this post on David Weller's blog and follow the directions: Subm ...Show All

• SQL Server Getting the latest data from different fields in one SQL

  Hi, I'm trying to write some SQL which will give me the following result from the table below.. Currently I can do each of the PRICEx fields in a seperate query then join the results together. I do this by getting the MAX(Date) WHERE PRICEx IS NOT NULL then using that date to get PRICEx, and then repeat until I've done all the PRICE fields. This is acceptable for a small selection, but for a large selection this can get quite slow. I was just wondering if there is there a way to do this in one single SQL without having to join the table to itself 3 times (for all 3 PRICE fields) Limno, Your subquery isn't grouping by ProductID and MarketID so it's not going to return the correct results if theres different ProductIDs ...Show All

• Windows Forms How do I set my own browser to a different home page?

  Is the above in the registry, or can you just change the URL Property on the WebBrowser control If the question you are asking is how to change the first startpage showing up in a WebBrowser control: that's by setting the Url property. I created a WinForms application, dropped a WebBrowser control on it, set the Url property to http://bloggingabout.net/blogs/rick and started the application. First thing to show up was my blog ... If this is not what you're looking for, maybe you can clarify your question ...Show All

• Visual Studio Team System To test Javascript

  Hi, Iam configuring VSS to test our website. Is there any way I can test the Javascript in our website. either thru the test script coding or thru the plug-in. Can any one lemme know about this Thanks You can use a coded webtest or a webtest plugin to add code to your webtest to simulate the javascript actions that your site depends on. You can also use Validation Rules and Extraction Rules to aid in this from either Declarative webtests (via the webtest editor) or code. Within the coded webtests/plugins you have access to each request as well as the responses. If their is a specific problem you're having with javascript in your pages please follow up with the details of your situation and we will be able to provide mor ...Show All

• Smart Device Development StackOverFlow Exception

  Hi, I’m working on a Pocket PC application in VB.Net on Compact Framework. There are many modules in this project, including 5 games. This an Icon based project and these icons are displayed using PictureBoxes. The problem: There are 3 events (Mouse Move, Mouse Down and Mouse Up ) associated with the array of Picture Boxes(icons). We are facing a problem: Multiple clicks results in a “ StackOverFlow Exception ” and the application crashes! (This might be because each click triggers 3 events as mentioned above ) Is it possible to detect the status of the stack and if so, how can the contents be deleted to avoid this Exception Can anybody suggest how this can be solved ...Show All

• SQL Server Visual Studio .NET 2005 includes SQL Server 2005

  Visual Studio .NET 2005 includes SQL Server 2005 May I ask you a question Is the SQL Server 2005 a fully SQL Server that I can use like SQL Server 2000 Thanks for your responses :-) Thats a thing of definition :-) VS 2005 comes with SQL Server Express which can be also used for other applications, it sure has limitations which can be found here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Gadgets Restart Gadget

  hi every one any one have a code to restart a the gadget, or force js array to loaded from file not from memory please any one know solution send it thanks window.location. reload (true); which should reload the Gadget, or setup an interval timer to reload it ie: timer1 = window.setInterval("refreshGadget()", <ms>); ... function refreshGadget() { <code to reload array and update HTML elements> } ...Show All

• Software Development for Windows Vista Is there a possibility to run the SendEmail Activity with Lotus mail server?

  Hello, Is there a possibility to run the SendEmail Activity with Lotus mail server if it's how would I proceed My mistake. I didn't even know that this sample existed. Does it let you pass credentials to the SMTP server If so, then I guess the second option that I mentioned has already been done for him. ...Show All