James Cornell's Q&A profile

• SQL Server Trying to return DISTINCT COLUMN data with varying information

  I'm trying to find the best way to return distinct data from a column (Message). The problem is that the messages are not distinct. Ex. Message1 - An unhandled exception occurred type 123456 Message2 - An unhandled exception occurred type 346742 Both of these messages are being returned since they are not unique. Now I was thinking about doing a character length and dropping the message after x number of chars, however, there are other issues like the unique data in the message isn't always in the same location. Any ideas of how to query this would be much appreciated. This to me sounds like a job for the people that put out those error messages. I mean, this is a lot of unnecessary work to decide that t ...Show All

• .NET Development UI Language and system literals

  I'm trying to find a way to access the dictionary of the system's current UI language phrases, but I've had no luck so far (e.g. how do I know what text the system will display on "Cancel" buttons). The suggestions I've seen are all based on custom dictionaries, but of course there must be a way to directly tap into whatever Windows itself is using. Any ideas There are a bunch of reasons I can think of (Windows API, security, stability, piracy, legacy, compatibility), I just not sure which is the true reason. Perhaps localizing an entire operating system takes a bit more than a dictionary. The fact remains, each and every Windows .exe and .dll stores its language sensitive strings as strin ...Show All

• .NET Development GUI freezes while using TCPclient in VB.net

  Hello everyone, My programm supposed to send commands to an external device(by textbox1) and receive responses from the deivce through textbox2.If I send the command once by clicking button1,I receive the responce once,although the external device should send continuously responses so I added a loop now it responds and refreshes Textbox2 continuously but GUI freezes,I can't exit the programm by clicking button2(Quit)...I am not a programmer I am using VB.net since 70-75 days so I am too confused...I hope someone can show me the right way to follow... Kindest regards, Can my code: Imports System.NET Imports System.NET.Sockets Imports System.Text Public Class Form1 Dim tagid As String Dim tc ...Show All

• Smart Device Development how to start develop C#.NET application on Windows Mobile 5

  i have install VS.NET and WM 5.0 SDK on my pc but i don't know how to config it to develop and run my application on my emulator what happens if you don't close the emulator it appear like this ( http://www.free4up.com/Image/51/182200164069045.png ) is i need to wait it for while full screen after it finish deploy (ready) http://www.free4up.com/Image/51/029069064202065.png i have create new project and add new form (name "Main"), in my form have 1 button and 1 textbox code (Main.cs) : using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace AdvWorksMobile {     public partial class M ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. setup desktop resolution as static

  is it possible in current version of DX10 in Vista setup desktop resolution as static In result if any application tryies to change resolution, DX change it virtually, but actually will work with desktop resolution. I think it would be nice to have this feature for current LCD displays, which is not good to support natural resolutions. This is possible on D3D10 -- DXGI API enables apps to resize targets of swap chains, thus supporting different resolutions from the desktop resolution. ...Show All

• Visual C# Interfaces - a beginners question

  Hi all, In most of the books I've read on C# they make the statement "C# only supports single inheritance, but you can implement as many Interfaces as you wish". To me, this seems to suggest that Interfaces serve a similar purpose to inheritance, but from what i've read and understood, this doesn't seem to be true. To my mind, an interface simply gaurantees that anly class that implements that interface will have those methods/properties the interface requires. However, as far as I understand, each class that implements an interface has to contain all the code necessary to implement that interface; so, for example, if I have two classes that implement an interface, then each class has to have its own code for that implement ...Show All

• SQL Server SQL Server 2005 and Vista x64

  Hi guys! This is sort of an SQL Server question... I have an opportunity to install Vista on my machine and I'm wondering which version I should install if I plan on doing development on SQL Server 2005 and VS 2005. Should I install Vista x64 or x86 Is there a significant performance increase when running x64 (I have an Intel E6400 and 2 GB RAM). Thanks in advance guys!!! Running on x64 does not mean better performance and in some cases could be slower. Since your goal is doing development either will be a fine choice. Here is some information on x64: http://www.microsoft.com/sql/editions/64bit/overview.mspx Thanks, Peter Saddow ...Show All

• Visual Basic copying a file to the root of a drive

  I am trying to use filecopy() to copy a file from my hard disk to the root of a USB drive and I get the error message "Could not find a port of the path 'e:\' any ideas thanks how are you copying it Are you sure that the USB drive is on drive E:\ to copy, usually this would do it: System.IO.File.Copy("drive:\ sourceFile ", "drive:\ fileNameToCopyAs ") example:   System.IO.File.Copy(" C:\myFile.txt ", "E:\ myFile.txt ") ...Show All

• Visual Studio 2008 (Pre-release) Sending Attachments in WCF

  Hi i am trying to send attachments from my client app to my service app in WCF with the help of the samle provided at " http://weblogs.asp.net/cibrax/archive/2006/03/29/441398.aspx " I am using Beta2. But when i try to add service reference to the client in that sample i am getting an exception stating "Compression Header is missing". I am not sure which CTP the sample is. Need help regarding this. let me know is there any other sample available for sending the attachments . TIA Cheers Jithendrian. R Here are some general guidelines for large messages (I'm assuming that you aren't streaming): Create a separate contract for operations with large uploads, make al ...Show All

• Visual C# Typecasting Arrays

  Hi, I am facing some problem while typecasting arrays. I have folowing line of code (test code) // Define in one function that returns object (array of float, double, int etc.) float [] test = new float [2]; test[0] = 1.1F; test[1] = 2.2F; object obj = test; // When I recieve this object back to caller fiunction I have to manipulate these individual elements // So I typecasted this to object[] object [] objArray = ( object [])obj; Now this line of code gives me run time error. Is it that we can not type cast arrays Thanks Nitin I got the way to do it in C# but internal remains still opaque to me L Excerpt from http://msdn2.microsoft.co ...Show All

• SQL Server Get connecting client PC's name or IP address

  Hi All, Is it possible to retrieve the client PC's computer name through SQL I'm storing workstation specific data in a table and want to be able to retrieve it in order to persist the state of the application between sessions. Perhaps there's a better way to do this that I'm not aware of If so, please advise. Thx For PC name you can use HOST_NAME() for IP you can use these methods SQL 2005 you'll find it in the sys.dm_exec_connections dynamic managment view in the client_net_address column. SQL 2000 DECLARE @Hostname VARCHAR(255) SET @Hostname = host_name() CREATE TABLE #Results ( Results VARCHAR(4000) ) DECLARE @Commandstring VARCHAR(300) SET @Commandstring = 'ping ' + @Hostnam ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SkyBox Effect using a BasicEffect

  HI Guys, I am currently creating a skybox for my game and I need help with the BasicEffect settings . Right now my skybox looks like a cube with a texture on each internal face. I would like the inside of the cube to appear like it is one continual texture, not showing the corners and edges. I will be creating a skybox with a custom effect later, but right now I would like to use a basiceffect. Can you tell me what basiceffect settings I should configure to create this effect. thanks in advance. Alan You need to disable lighting, zbuffer, zwrite, etc LIGHTING = FALSE; ZENABLE = FALSE; ZWRITEENABLE = FALSE; ALPHATESTENABLE = FALSE; ALPHABLENDENABLE = FALSE; and ...Show All

• Windows Live Developer Forums map loaded event

  Is there anyway to programaticaly know if the map has completely finshed loading I would like to know if this event can be cought not only when the map is being initiated but even when zooming in/out, changing the map type or panning the map. Thanks Derek.. I am trying to show a "loading " icon or text while the map is still loading layers. I need to implement this functionality because some of the custom layers might be carrying no data...and the user must be notified when the map is actually not loading anymore....in its absence the user might think that my application has broken... I would not mind switching the loading on/off every time a tile is being loaded..it would be nice to know which layer that tile bel ...Show All

• .NET Development writing to XML and VSTO in windows mobile 2005.

  hey there...       I am new to visual studio and programming in general and was wondering how i might accomplish these tasks. any help is greatly appreciated...             1. How do I make a button that when pressed writes its value to an xml or excel xls file             2. How do I make a button that when pressed runs another program             3. Does VSTO work on "windows mobile 2005" and "pocket excel"              Also, does anybody know any good beginner tutorials that could help me o ...Show All

• SQL Server bcp import error on dates

  i have a csv file with a date field like "fev 1 2006" (french format). I can't import the file with bcp without converting manually all the dates to the US format (fev => feb, avr => apr, ...). Is there any solution or option that would avoid me to convert manually the dates I installed SQL Server in french, on a french Windows Server 2003, but i still can't import french dates. ...Show All