leshan01's Q&A profile

• SQL Server Variables in CONTAINSTABLE. IS IT POSSIBLE? NO ERRORS AND NO RESULTS.

  I know the use of variables is allowed with CONTAINS but I can't seem to get return results with CONTAINSTABLE My test Code: DECLARE @textstring varchar(4000) DECLARE @firstword varchar(80) DECLARE @secondword varchar(80) SELECT @textstring = ltrim(rtrim('SAP America Inc') select @firstword = dbo.GETWORDNUM(@textstring, 1, ' ,.:') --Returns the first word with no spaces, commas or colons select @secondword = dbo.GETWORDNUM(@textstring, 2, ' ,.:') --Second word select @thirdword = dbo.GETWORDNUM(@textstring, 3 , ' ,.:') --Thirdword SELECT c.companyIntID, c.CompanyName, KEY_TBL.RANK FROM Companies as c INN ...Show All

• Software Development for Windows Vista SqlTrackingService and Sql Injection

  Looking around the SqlTrackingService, I noticed that it does a lot of dynamic sql generation. The problem is that it makes it (fairly easily) subject to SQL injection attacks because it sometimes does this with tracking information coming from activity data, which possibly might even come from external inputs. For example, it's easy to cause the SqlTrackingService to generate invalid SQL with a simple ' char passed to Activity.TrackData() as part of the string data to track. Heck, with a little more work you can craft a string like this: this.TrackData("Test", "', @UserData_Blob=0x00, @UserDataNonSerializable=0;INSERT INTO Ev ...Show All

• SQL Server How to install Express Manager tool?

  After wasting several days trying to get SQL 2005 installed on my test server & to connect to a virgin database (DotNetNuke), I'm reverting to simply using Express. That should be simple, right ! It's even installed with Visual Studio 2005 (June CPT)!   Lookoing, the only thing under Start|All Programs are Microsoft SQL Server 2005 CTP|Configuration Tools with threee entries: SQL Server Configuration Manager.lnk, SQL Server Error and Usage Reporting.lnk and SQL Server Surface Area Configuration.lnk Ah, I'll use the ConfigManager to create my blank database, since the other two tools obviously are for other things. I start it up, try ...Show All

• Visual C++ Cannot change build configuration in 2005 release candidate

  I have recently downloaded and installed the VS 2005 release candidate, and am trying to build a multi-project solution upgraded (with no problems) from VS 2003. When I use Build/Batch Build I can get both release and debug builds. However, when I try to compile individual files or to build either the entire solution or individual projects, it always does a debug build, even though I have supposedly changed the configuration to "Release" and it says "Release" for the solution configuration in the toolbar. I have tried every way I know how to change the configuration but nothing works. Does anyone know what might be going on ...Show All

• .NET Development XslCompiledTransform.Transform very slow

  XslCompiledTransform is taking more time to transform xml file using xslt files. XslCompiledTransform.Load() , loads and compile xslt faster, but XslCompiledTransform.Transform() is taking more time to transform then using XslTransform class. I have C# code in xslt files for data manipulations and sometimes xml files may be big in size. I would like to look at your XML and XSL files and the way you load them (XmlDocument, XPathDocument, etc.). If possible, please send them to this address . Thanks, Anton ...Show All

• Visual Studio Tools for Office Creating xll files (excel library files) in visual c++ 2005 express

  Hey. I know this forum isn't specific to excel, but I haven't gotten any responses from the excel.programming newsgroup so I thought I would try here. I am trying to create xll files for excel so I can use my existing c++ code to do custom functions through excel. I have a book which explains the basic ideas, but it says to include xlcall.h and xlcall32.lib from the excel 97 sdk. These files won't compile in visual c++ 2005 express. i was wondering if anyone knew where to locate equivalent files which would compile in visual studio 2005 express, or any good resources on using visual c++ 2005 express to create custom functions for excel using ...Show All

• Visual Studio 2008 (Pre-release) TargetName Does not work for me.

  I have problems getting the Targetname property in ANY setter to work (inside a datatemplate). How Do i access specific elements within a datatemplate to change/animate with a animation/property trigger  Let me just emphasize this is within a datatemplate. Outside the datatemplate works reasonably well    ...Show All

• Visual Studio Team System TFS Verification

  I'm on my third installation of TFS. First time  All went OK bit I couldn't create projects. Second, Wouldn't install at all. Third and this time. Totally rebuilt server and now it's all installed. Before I attempt to create a project can anybody give me a checklist of things that should and shouldn't work. For example at the moment I'm logged on the machine as TFSSETUP who is a member of local admins.  I have Foundation Client installed also. 1. http://localhost/ = Under Construction 2. http://localhost/reports = Reporting server website and I've added our develpment NT group and tfsservice to system administrator role 3. http:// ...Show All

• Windows Forms ClickOnce Deployment Issue

  I have successfully published my ClickOnce application via Visual Studio 2005 Beta 2, but when I try to launch the application I get the following error log: PLATFORM VERSION INFO  Windows    : 5.1.2600.131072 (Win32NT)  Common Language Runtime  : 2.0.50215.44  System.Deployment.dll   : 2.0.50215.44 (beta2.050215-4400)  mscorwks.dll    : 2.0.50215.44 (beta2.050215-4400)  dfdll.dll    : 8.0.50215.44 (beta2.050215-4400)  dfshim.dll    : 2.0.50215.44 (beta2.050215-4400) SOURCES  Deployment url   : http://trainingadmin.li ...Show All

• Visual Studio 2008 (Pre-release) Changing the cursor programmatically

  Hello, can anyone tell me how I can set my cursor in the code with a relative path to my .cur tnx in advance, kimme button.Cursor = new Cursor("foo.cur"); Note that we only support cursor files on the file system, not pack: or http:. ...Show All

• Visual C# How do I embed an SQL Server Express database with a C# application?

  I haven't been able to find any decent tutorials for easily deploying a C# application with a bundled SQL server 2005 express database. Does anyone have any good information regarding this Using SQL express database is really simple, if you are already used SQL Server. There is only difference in connection string where instead of Setting Data Initial Catalog, you should set AttachDbFilename with file path to your database mdf file. Data Source attribute has to be changed and in case of default installation of SQL Express that is .\SQLEXPRESS One thing about connection is important and that is, authent ...Show All

• Visual C# MS, MVP feedback, question: casts / conversions -- some way to automate?

  Is there some way to adjust the warning level and other compiler flags so that the c# compiler is 1) not so darned finnicky about expressions using mixed floating point and integer types and 2) actually performs automatic conversions more correctly than it does, like a 'C++' compiler some feedback on this also -- requiring explicit casts in so many situations is all downside, as far as I am concerned: Its very time consuming having to add all the (float) casts required now, and the casts make the code much harder to read. I find I code far more errors than I would otherwise because of the visual distractions added by all the pa ...Show All

• Visual Basic System.IO locking my files preventing another Sub to run properly

  Once I get to this point and call this function below, I get a lock error on the incoming .mnt and .naf files that it tries to move.   here's my entire code: http://www.webfound.net/allcode.txt Here's the Error System Error Information: The process cannot access the file because it is being used by another process.Place: 6 System.IO.IOException: The process cannot access the file because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.__Error.WinIOError() at System.IO.File.Move(String sourceFileName, String destFileName) at HEDI2.Module1.MoveInputFiles() in Y:\ine ...Show All

• Visual C# How do you REMOVE or DELETE Items from Recent Projects list in VS2005 RC?

  I have been testing  VS2005 RC and as a result, I have built many applications. Most I am no longer interested in or use and would like to DELETE them from the RECENT Projects list, but I dont see how ! I have been achieving this by manualy deleting the project from IIS, but there's got to be a better way ! Any ideas cheers, yousaid >> The suggested solution is to have a "clear recent projects history" button on the start page. uhm, maybe I am blind, but in the released version I have still not found an easy way to cleanup your "recent projects" list. I also believe that t ...Show All

• Windows Forms App Config file problem w/ No-Touch Deploy 2

  Hi Guys, This is continuous to a previous thread "App Config file problem w/ No-Touch Deploy". It was left unsolved and I'm facing the same problem now. Problem: When I add  an application config file to my app - the app fails to run using No Touch. It's unable to read from the config file stating that my "key does not exist" in th ...Show All