kien's Q&A profile

• Windows Forms Hotfix available!

  visual studio just erased all my controls. some bug crept in to my code so the designer couldnt design the form. normally this results in the designer giving an error - but not this time.  it rather cleverly decided to erase all the design i had made, and of course, because this didnt actually come to light until i hit COMPILE this has now&nb ...Show All

• SQL Server Restore Analysis Backup to new DAtabase Name

  I have backed up an AS database. Now I want to restore it to a new name so I have two copies to play with.  How do I do this Thanks, Chris How do you get around the problem of credentials of multiple domains. Dev machine on one domain, server on anther (via VPN at client). I know I could problably copy all the files to the server and change the configs. Anybody researched this Thanks ...Show All

• Visual C# Selecting a pixel region ?

  Hi. Let's say I have a picture box with an image loaded in it...what I want to do is to select a certain region with pixels from this pictureBox and display them in another pictureBox...is there a way to do this... Thanks in advance! sure... what i want is do display a certain region from one picturebox into another...i tought that "selectin pixel region" is a proper name!maybe not :) yea...lets say i have a picturebox 80x80 and i want to display a region 10x10 from it....can you tell me how to select a region and display this region into another picturebox ...Show All

• Visual C# classname[from Metadata] file

  Why whenever i want to check a definition of a function, VS2005 take me to the file "anyclassname[from Metadata]" where it is like a class declaration with all the member functions and variables. it is located is a tempory folder. Why the IDE doesn't take me to the actual source code If you have added a dll you've compiled as a reference then VS doesn't know you have the source for that file. Perhaps a future solution would be to allow adding a solution file as a reference, VS could then find the assemblies and auto add their true references in a different colour and internally know where to fi ...Show All

• SQL Server Arithmetic Overflow error

  Can someone help me with this error: I need to change the datatype of a column from int to tinyint. I did this : ALTER TABLE EmailTracking ALTER COLUMN URLID tinyint and got this error: Msg 220, Level 16, State 2, Line 1 Arithmetic overflow error for data type tinyint, value = 74860. The statement has been terminated. how do i fix this thanks Rookie, perhaps you could try examining the maximum value on the data. Tinyint is only up to 255. If the maximum of your data is more than 255, perhaps you would consider smallint instead, which is up to 32,000. Int on the oth ...Show All

• Visual Basic How to obtain program directory

  How do you obtain the installed path for the program.  I need to check if a file is present in the directory where the main application is installed.    Thanks. In VB Express / 2005 My.Application.Info.DirectoryPath For More details... http://msdn2.microsoft.com/en-us/library/6whasz3x(VS.80).aspx ...Show All

• SQL Server DB Owner & SqlDependency Problem

  I deleted the account owning Test Database after creating Test Database. Everythings work well except SqlDependency. SqlDependency OnChange Event is not working. I have tested SQL 2005 ent RTM & VS 2005 Pro RTM. I'm curious why it happened. Thank you. SqlDependency needs the EXECUTE AS infrastructure to do it's work. If the account that created the database was deleted, EXECUTE AS user 'dbo' will fail, because it cannot retrieve the account info. Change the database ownership to a valid account: ALTER AUTHORIZATION ON DATABASE::[Test Database] TO [sa]; HTH, ~ Remus ...Show All

• .NET Development FtpWebRequest re-sending USER and PASS commands half way through download loop

  Well, the title says it all really: I'm using FtpWebRequest to download multiple files as follows: private string GetFile(Uri uri) { string un = Misc.ReadRegKey("ParserFtpUsername"); string pwd = Misc.ReadRegKey("ParserFtpPwd"); string file; NetworkCredential cred = new NetworkCredential(un, pwd); WebProxy pxy = new WebProxy(); pxy.UseDefaultCredentials = true; FtpWebRequest wr = (FtpWebRequest)WebRequest.Create(uri); wr.Credentials = cred; wr.Proxy = pxy; wr.UseBinary = false; wr.Method = WebRequestMethods.Ftp.DownloadFile; FtpWebResponse resp = (FtpWebResponse)wr.GetResponse(); ...Show All

• SQL Server Data Source View and Report Model

  Guys, I created a Data Source View that uses two different Data Source connections to two different databases. I was able to drop in the tables in the data source view designer from the two databases, but when I try to create the Report Model based on that data source view, it's complaining that it can't find table in the non-primary data source from the data source view. Here is the error I'm getting: An error occurred while executing a command. Message: Invalid object name 'dbo.[tablename]' Command: SELECT COUNT(*) FROM [dbo].[tablename] t Why can't it find the database to connect to since the data source view is a ...Show All

• Visual C++ A doubt in VC++.net

  hi, I have a doubt in VC++.NET's IJW feature. If we compile an existing VC++ 6.0 application inVC++.NET, almost (with slight code changes may be) it works. Even if the application contains objects from MFC or others, this technique works. I need to know 1. whether these will run under .NET CLR or not. 2. what is .NET's role & contribution to these application. will they still use older dlls 3. if i ship these application to a system where only the .net framework is installed, will they work Please make me clear thanks, 1) If all you have done is recompile that application then it won't run under the CLR: i ...Show All

• .NET Development Socket closed, Port still active

  Hi All, In the application being developed, i have problem in disposing Socket Object. Senario ------- I have multiple TcpListeners (as thread) retriving messages parallelly. One Listener is created for each source (or sender). Program is working fine. Each TcpListener object in stored in a collection. GUI is provided to Start/Stop each thread. Whenever thread is aborted, TcpListener is stopped by calling Stop method in stored object (TcpListener object). Socket is also closed by calling TcpListener_object.Server.Close(). Port is still active (i.e. not released). I have verified by using netstat (MS DOS Command). Kindly sug ...Show All

• Visual Studio Team System How can I define an alternate editor?

  We use XML Spy and another product internally to edit XML documents, DTDs and Schemas. How can I tell Team Explorer to use a different editor for these files Thanks, Chris Lively MRG Document Technologies Team Explorer (and the command-line 'tf view') use whatever is registered as the "Edit" verb in the Windows Shell. You can adjust this directly in the registry, in Windows Explorer -> Tools -> Folder Options -> File Types, or with any number of freeware tools. ...Show All

• .NET Development Parameterized queries

  When using a parameterized query such as: SELECT LocationID, StreetNum, StreetName, rowguid FROM tblLocations WHERE (StreetNum = @StreetNum) AND (StreetName LIKE @StreetName) Is there a way to automatically add % to the beginning and ending of the parameter I've tried the following command: SELECT LocationID, StreetNum, StreetName, rowguid FROM tblLocations WHERE (StreetNum = @StreetNum) AND (StreetName LIKE '%' + @StreetName + '%') But I get a FormatException. I don't want the user to have to type % in the parameter field. Any suggestions Thanks, Lee I have split this post into a separate thread, and ...Show All

• Visual Studio Express Editions Threads, UI, and Invoke (again)...

  I know this has been asked at least a few times before, but i am having horrible trouble trying to get this to work. Maybe i need it explained to me like a 5 year old... because i am new to C#. What I am trying to do, is, of course, update the UI of one form from another thread... In more detail, i mean, I am trying to simply appendtext to a richtextbox from one form from a thread on another .cs file that streams a simple TCP connection... i just want to post all messages from it to the richtextbox. I dont have code to paste since i deleted it all to start over. I need to append this variable of the connections message, to the end of a richt ...Show All

• Visual Studio Team System Beta 3 Setup Error: Windows SharePoint Services is not configured as recommended by Team Foundation Server

  I am trying to install Team Foundation Server Beta 3 as single server installation and installed all required software components. However, during the installation, it gives me "Windows SharePoint Services is not configured as recommended by Team Foundation Server" error under "Recommened Components" dialog box. I exactly have followed an instruction specified in setup guide for Team Foundation Server Beta 3 for SharePoint services installation. Could anybody tell me what the problem is Thanks in advance. Eric Following these directions helped with getting Sharepoint working on my machine, but running Report ...Show All