Ranier's Q&A profile

• SQL Server Excel Numbers format

  Hi all i'm having an issues when i trying to do a report: i make a report and there is a field which contains data that can be numeric and numeric with letter: "77756" or "345WS" when i export my report to excel i and i open it i get like a make in the upper left coner of the cells that have only numbers asking me to convert this to numeric format, but this think is that i need this values to be string so i can apply filtering. is there a way that i can format my cell to string so the excel take it like that and allowme to do the autoifilter. I would really appriciate your Help Thanks I have this exact same issue. I have an Access Database that exports a tool report to ...Show All

• Visual Studio Express Editions Richtext,rtf System.ArgumentExceptio

  Try Dim strhtml As String = getdocHtml() MsgBox(strhtml.Substring(1, 4048), MsgBoxStyle.Information, "html") rtb1.Rtf = strhtml ' <== caused "A first chance exception of type 'System.ArgumentException' occurred in System.Windows.Forms.dll" rtb1.Show() catch End Try I could see the hml in msgbox but could not see anything being shown in richtextbox rtb1. what can I do to fix the problem I am using visual basic .net studio express 2005 thx. I got the value for strHtml from the first 4kbyte of webbrowser.document after naviagting to a website. So the question is does proper mean clean and complete with all required endi ...Show All

• SQL Server Query Results to Text

  With Query Analyzer I would run queries that returned text results that I would output to a text file. When I run the same queries using SQL Server 2005, the text output files are twice as large and the are non-printable characters visible between each printable character. It turns out that it's inserting a hex 00 between each charcter. How can I turn this off I need straght ASCII text output files. Thanks in advance,, rdomo Thanks Louis, that corrected the problem exactly. Kind of a pain to go though these additional steps/mouse clicks to get the job done. I thought i had something to do with Unicode characters and was thinking I had missed some configuration setting during the install. Ralph ...Show All

• Visual Studio 2008 (Pre-release) Thanks

  I wanted to say thanks to all the people on this forum for helping with solutions to problems, particularly the Microsoft guys for creating such a great platform and being prepared to participate with the developers. I started to experiment with WPF in January 2006 and had a 'vision' for a new product while recovering from a back operation in June 2007. The result is at http:/ www.glomey.com and is a clickonce deployed app written in Visual Basic using WPF and WCF. There are still some rough edges, and probably some bugs. Any feedback would be appreciated. Hope you find it interesting. There is a long way to go to fulfill the vision but at least it is a start. Thanks again, John From ...Show All

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

  I am try to rewrite my 2d game that was origianly in c++ and directx 9 to xna. I learned the basics of c# and mdx 2.0 while wrighting the map editor for it. In my original engine i wrote a lighting effect and wanted to recreate it in xna. I set up a quad and texture cordinates everything worked like it should. however i was using VertexPositionTexture for my vertices, when i switched them to VertexPositionNormalTexture and added the normal cordinates it now renders something very peculare , it renders something in the center that is mishaped and the texture cordinates are really messed up. I use using vertex and pixel shaders. nonIndexedCube = new VertexPositionNormalTexture[4]; compiledEffect = Effect.CompileEffectFromFile(&q ...Show All

• Software Development for Windows Vista Setting up the database for SqlWorkflowPersistenceService

  Hello, I used the Hands-on Labs Beta 2 for an introduction to the WWF. There were added special SQL scripts to create the database for the persistence service. Though I have read in a paper by Dino Esposito that there are some dialog-based utilities for download to easily create the target database. My question is : Where can I find these utilities Thank you very much in advance! Iris Stern Thank you, Bill, for your quick response. I had already found and used the SQL scripts from the labs before sending my message. These scripts have to be adapted manually, when you want to use e.g. other database names. So I asked if there exist dialog-based tools to create the databases for persis ...Show All

• Visual Basic FileSystemWatcher in arraylist

  Hi all, I'm trying to monitor changes in a number of folders using FileSystemWatcher. I have a procedure that accepts the path to monitor. A new FileSystemWatcher is created for that path, together with its event handlers, and added to an arraylist (watchList). This seems to work fine, however I would like to be able to modify the attributes of specific watchers at run-time. I'm doing something like this to stop the first watcher in the arraylist: Dim w As FileSystemWatcher w = watchList.Item(0) w.EnableRaisingEvents = False This causes a NullReferenceException at the last line. In break mode I see the arraylist has 3 elements of type Object, but adding a watch for watchList.Item(0).path (or any other watcher pro ...Show All

• Visual Studio Express Editions Which info is the best to identify a computer?

  Hi, for my new licensing-system I need a Information (a string) that is explicit. Also something like the mac-address but it need to be very hard / impossible to fake. And I want to get this Information with vb.NET. Thanks & regards, Fabian Golle Hi, Try the Hard disk physical serial number.>> See these threads.>> http://forums.microsoft.com/MSDN/Search/Search.aspx words=hard+drive+serial+number&localechoice=9&SiteID=1&searchscope=allforums and a few more here.>> http://forums.microsoft.com/MSDN/Search/Search.aspx words=hard+disk+serial+number&searchKey=&lcid=1033&searchscope=allforums&siteid=1&ForumID=-1&ForumGroupID=-1&GoButton=+Go +     ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Boing v.0.5

  My first "real" game. Just a pong game but I used a different way than just having on or two files. I'll show the source after I clean up the code and summarize it for others to follow. I'll keep adding onto the game to learn other things. Rate/Comment. Boing Version 0.5 looks really nice, i'd love to see the source code for this. only things i noticed was that the ball leaves the playing field slightly before bouncing back in, and it gets too fast too quickly (that may just be me). overall its a nice pong game and it looks really good. ...Show All

• Visual Studio Express Editions Saving time into database.

  I have a timer in a labelbox and I need to be able to save the contents into a database. Whenever I try to save it, I get this error: Column 'TimeOut' does not allow nulls. The error is right, it does not allow nulls, but I was trying to save a time in there, not leave it blank. The only thing I can think of is that it is not converting the labelbox display to a string. The line of code I have to copy it into the database is: NewDayOut.Item( "Time Out" ) = TimeBox.Text where newdayout is the name of the row I'm trying to add, Time Out is the name of the column, and TimeBox is the name of the labelbox I'm using to display the time. I'm going to keep working on it, but if anyone can help, it would be appreciated ...Show All

• Smart Device Development Which (rda, webservice) is the optimal method to use to send less Kb over the network?

  We need to send one data row to the main server over a network (Internet, GPRS). Which is the optimal method to use to send less Kb over the network RDA WebService Regards RDA/replication probably would be the about same. WS would be bigger. You could use any traffic monitoring tool to see which one is the best. It can run on a desktop for testing, no need to use a phone or GPRS. ...Show All

• Visual C# c# code parsing

  Hi all, I need a help from you regarding code parsing technique. Basically I need to parse c# code (which is a User interface class) and check for any business validation/rules written there and copy them into the corresponding business layer class. So, in order to parse the c# code do I have any readymade c# code parser (in object oriented model) so that I can make use of them to find out the validation routines, if condition, error codes, etc. Or should I only manually do string parse the c# code Regards Karthikeyan Given your requirements I think the VS extensibility model is the way to go. What you'll do is create an add-in that allows you to select a file or project (which b ...Show All

• Software Development for Windows Vista invoking xoml only workflow

  Dear all, I'd like to make a custom activity that can invoke xoml only workflow asyc. My xoml don't have x:Class attribute, because i'm thinking of XAML activation. XmlReader reader = XmlReader .Create( "myworkflow.xoml" ); WorkflowInstance instance = runtime.CreateWorkflow(reader); If i had a complied type it's simple as my code snipet shows. public Type WorkflowToInvoke; protected override ActivityExecutionStatus Execute(ActivityExecutionContext executionContext) { Dictionary<string, object> prms = new Dictionary<string, object>(); IStartWorkflow starter = executionContext.GetService<IStartWorkflow>(); starter.StartWorkflow(WorkflowToInvoke, prms); return ActivityExecutionStatus.Closed; ...Show All

• Visual Studio Express Editions Visual Basic Express Edition E-book

  Where in the registration portal is the link to download the e-book for the Visual Basic Express edition. Can anyone please help me. I am a beginner. Any ideas or recommendations woud help. Hello I just wanted to ask Can the e-book be redistributed as said by the EULA I never read that EULA... Email me knvb1123@gmail.com Keehun Nam ...Show All

• Visual C++ Hotkey For Build Ouput Go To Next Message

  I know this should be simple, but I can't find the hotkey or how to assign a hotkey for "Go To Next Message" in the build output window. The scenario: I press Ctrl-Shift-B to build my solution, I have build errors, and I want to press a key to cycle through these and fix the errors without fixing the error and then going to my mouse and selecting the next one. Excellent! Thanks very much, Viorel! Thats the exact answer I was looking for. Now, how did you figure this out It doesn't show up mousing over the button, and I can't locate it in the menus. So did you press every key till you found it ...Show All