chamsoft's Q&A profile

• SQL Server Return bottom 10 rows not working.

  Ok so this is more then likely very easy for most. But for me it's hard. I have a stored proc that I've been able to get to retun just the top 10 rows and have been able to order it asending. But it will only return the top 10 and I need to bottom 10 of the selection. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER proc [dbo] . [proj_ListFiles] ( @project_id int ) as select top 10 ( @project_id ) id , project_id , filename , contenttype , length from proj_file where project_id = @project_id How can I make it return to bottom 10. On a side note about this, when it returns the recordset they all have the 'id' of the 'project_id' that I selected. Not that the side note really bothers me as it will no ...Show All

• .NET Development StringBuilder.Replace

  My app reads text files and verifies the daa before it is processed. If a field is invalid, the app will note it and either space or zero out the bad data. The user will take the information and manually correct any incorrect fields. I am using a StringBuilder and the Replace method to change the invalid fields, however; the Replace method is not changing the data as I thought it would. My code is below. strInputText ... : Input file strHoldText ... : Holds the field data strTempText ...: StringBuilder variable The CheckIt method returns the changed data field, however; the field in the input record is left untouched by the Replace method. What am I missing here public string NumericCheck ( string strInputText ) { stri ...Show All

• Smart Device Development Prevent standby/keep app running in standby?

  Hi All I'm currently writing my diploma thesis and as a part thereof i am writing a WM based application to constantly log some data (various sensor input via Serial, picture capturing, audio recording and GPS via Bluetooth) which will later on be used for some data mining/context awareness stuff. It is absolutely crucial that i have a constant stream of incoming data that is not interrupted by e.g. standby, be it system or user initiated... And that is exactly where i am stuck now... :-( Does anyone know how i can prevent my wm 2005 PPC device from going into standby, even if the user clicks on power off button However, if this is possible, will the keys and the touchscreen still be locked (not a must, but would be nice) (Btw.We ...Show All

• .NET Development DNS.GetHostEntry doesn't display the hostname as dns.resolve did

  In a small console application I used DNS.resolve to obtain either the IP-address(es) or hostname depending on the parameter passed (computername or IP address). I've rewrited the little thing in Visual Studio 2005 and so I saw that I needed to use dns.GetHostEntry instead of dns.resolve because the last method has become obsolete. So I did. But when executing the code the behavior is somewhat different: dns.gethostentry doesn't retrieve the hostname if you pass an IP address, were dns.resolve has no problem in showing me the hostname found. Is this a known issue Is there a workarround or solution I want to thank Microsoft for ruining a perfectly operable code such as Dns.Resolve(stringIp). I ...Show All

• Visual C# File.Copy gets NotSupportedException or, does it?

  Hello, I have an application that copies files. fairly simple. I call the IO.File.Copy() method to do it. however, with some files I get an error. "The given path's format is not supported." The files this occur on are random and doesn't seem to tag to a specific file as if I rerun the program again it will copy the file that failed before without error. I figured it was just a problem with the string variable I used for the method as if it was incorrect or something. Here comes the weird part. I checked the location where the file is suppose to be copied to and the file is there. The exception is raised after the file is copied. I checked the file itself and there is no corruptions. I also checked the string variable b ...Show All

• SQL Server changing the sync_type option of a subscription

  If I create a subscription with a sync_type set to 'replication support only' is it possible to change that option to 'automatic' down the road without destroying and recreating the subscription -mike Automatic appears (and I need to do more reading on this) to give you a bit more flexability when adding items to a publication. For example, I have a publication and subscription (w/ sync_type = automatic) up and running and now I want to add another object to that publication. Once I've added the object all I need to do is regenerate the snapshot and that object is replicated to the subscriber. So, that being said, I have a very large database that takes around four hours to deliver the initial snapshot. D ...Show All

• Visual Studio Tools for Office Word - Page Extraction

    I'm not sure if this is the right place to ask this, but perhaps you'll be able to direct me to the right spot if not... I'm trying to open a word document and determine if it contains multiple pages, which I've been able to do... However, If the document contains multiple pages, I want to save each page as it's own document - and this is where I get hung up. It sounds simple enough, but that's usually the case... Any ideas or suggestions would be greatly appreciated. Regards, J. Conklin Well, a "more correct" place would be either http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.automation&lang=en&cr=US or h ...Show All

• Windows Forms OracleClient with Clickonce Deployment

  I am trying to deploy an application using Clickonce. I previously was using OleDbConnection to connect to an oracle database. However i would like to use the System.Data.OracleClient namespace instead. Upon publishing the application the users get an error when they try to connect to the database. Do i have to install the oracle connectivity files manually on the user's computer Is there a way to distribute the needed files as prerequisites Thanks for your help. I'm not up to speed on the Oracle client, and it's details, but here's a couple of generic answers. Check to see if the CilckOnce manifest continues to list the security permission for the Oracle client. I think it should. If y ...Show All

• Visual Basic as how we have wizard control in asp.net

  as how we have wizard control in asp.net is ther any control in vb.net for wizard i need this for parsing a resume and extracting the email adress,name,telephone no and ect ...Show All

• Visual Basic Best practice for deploying different app_name.exe.config files?

  Let's say I created an Visual Basic application that uses the .NET 2.0 settings architecture. My application settings are then stored in an xml file called app_name.exe.config. This stores stuff like database connection strings etc. Let's say I create a setup project to deploy this application. Let's say I have two environments to deploy my application. One is for testing purposes and the other is for production. Each environment uses different databases etc. That means different database connection strings are needed. Is there any way to do this so I have two versions of app_name.exe.config -- one for testing and one for production And to have a single deployment package that will automatically use the correct ver ...Show All

• SQL Server how to implement the sql server mirroring?

  i have two computers with Sql server 2000 std edition(SP4) and windows 2003 std edition(SP1). how should i do to balance the loading of sql server and sync these two servers The sql server mirroring means that if one server is down, then the other one will replace it ...Show All

• Visual Studio Express Editions How do I remove a color from a Bitmap (while creating it)?

  Greeting all, I hope this is clear. I create a Bitmap and then commence drawing images, lines and strings, however having drawn a line I find I need to remove some pixels of that line to tidy up the look of the line on the screen ( I want neat edges) I then load that bitmap into a Picturebox.Image. How do I remove the color of a pixel from the Bitmap. What is the actual color state of a Bitmap when it is first created (if that's the right term) Cheers in advance Bakerboy60 Many Thanks KitG, idea No.2 was just the answer I was looking for, you wouldn't believe the amount of time I spent looking for this solution. BTW, idea No. 1 would have also worked, but I was using the Bitmap o ...Show All

• Smart Device Development Problem with Device Emulator

  Hi, I encountered a problem with Device Emulator in VS2005. When I open Device Emulator Manager, I found nothing in the treeview except a single "other" node. And when I debug an application, the Device Emulator could not be connected. But It works well days before. Very appreciate you to help me. I have been following this thread and many others for a similar problem. Both my "Connect to Device" and "Device emulator manager" are empty. I have tried the remove corecon folders from both my profile and all users with no success. When I tried to install the mobile 6.0 refresh hoping that it will solve my problems, it goes upto the "Register with VisualStudio" ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. MouseCursor Component

  Here's a component that draws a cursor on the screen where the mouse is currently positioned. It has some events you can handle for button clicks. Still work in progress, but it's functional. Set the texture path property to define what texture the cursor is. Components are great. Just drop this in to your game and boom, you have a mouse cursor (well after you set the texture property). Oh and I assume you have a SpriteBatch already going that you use for drawing other things. If you don't, it's quick to add one yourself. Otherwise, set the Batch property to whatever yours is. using System; using System.Collections.Generic; using Microsoft.Xna.Framework; using Microsoft.Xna.Framework.Audio; using Microsoft.Xna.Framework.Components; u ...Show All

• Windows Forms Problems handling "VarBinary" field.

  Hi,   As I could read that "image" fieldtype would eventually disappear from next SQL version, (Ref: http://msdn2.microsoft.com/fr-fr/library/ms187993 )  I started using in one of my SQL table a "VarBinary" fieldtype in order to hold an image ( .bmp, .gif, .jpg, .jpeg).   My problem here is that, even after searching infos on the web on "VarBinary fieldtype", I still don't have a clue on how I can assign that "VarBinary" field value to the "Image" control I have on my form so it can display corresponding image.  Any trick   By the same way, any trick on how I can store my "Image" control's picture back to my "VarBinary" field Many thanks in advance, Stephane &n ...Show All