PaulWill's Q&A profile

• SQL Server Query (count) question

  I am somewhat new to SQL and I have a simple question (I think)... I have a field called results that contains several numbers seperated by columns, such as 3,6,16,22 etc. I want to write a query that answers how many of each number occurs from the range. Example: Select (total) results  where id = 6 and results = 16  so the query would have to search within the string results for all the records retrieved and count the instances how would I do this I'd do the following. First you'll need a numbers table as in http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-numbers-table.html now create a view on your table that splits out the numbers create view Split ...Show All

• .NET Development C# Virus - Security and CLR

  Trying to find an antivirus program that work under Windows Vista Ultimate RC1 – there exist about four products (all not even main stream products). Next thinking is for CLR security and I have a question about that. Can anybody use C” to make a Virus and more important: Can antivirus program be made by C# For compatibility reasons whenever a .NET application is built the version of the framework it was compiled against is noted within so that when it is run later, it will ask to be run within the same version of the CLR. If the requested framework is unavailable the system will try to run it within a newer version provided there isn’t a rule preventing it such as the supportedRuntime value in the .config file. ...Show All

• .NET Development "Queued" requests...

  We are experiencing a strange problem on all our testing environments and our production environment as well. Here is the problem. We have a web service that exposes a series of methods, each method representing a type of request. Based on the method called different code is executed. The web service does not do much more than act as a dispatcher to the correct business object that will handle the request. The business objects are accessed via remoting. The issue we have is that IIS seems to be processing simultaneous requests in a serialized manner. Using a test .aspx form, if we submit two requests back to back (submit request #1 from one .aspx form and followed immediately by submitting request #2 from another .aspx form), request ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Visual Shader authoring software for 3ds max

  for all those artists or beginners to HLSL (i know i still am) http://lumonixsoftware.com/ has recently released "ShaderfX" a plugin for 3ds max that lets artists plug together simple and complex shaders with no programing knowledge and export them to .fx (They work perfectly with FX composer.) There is a free eval and the full version is very inexpensive (for anyone with at least a part time job.) I'm currently using it for my MMORPG project in conjunction with Kaneva game platform (elite.kaneva.com) I've been spreadign word aroudn so I hope this helps some of you out there. The eval version can create simple effects like Normal/pharalax/reflection" plus a lot more, but is limited to 8 nodes. ...Show All

• Windows Forms Refresh a "view" in datagridview

  How can i refresh a "view" in datagridview without having to save to underlying database I have to tables and a "view" table in dataset. The "view" table is binded to a datagridview, but this one do not show de changes made to the other tables, unless update the fisic database and then rebind the databindingsource. but then i can't undo the changes. ...Show All

• SQL Server Web Synchronization - Is Direct Connection to the Publisher Required ?

  Hi, I've been trying to setup a merge replication environment for a SQL Server 2005 publisher. This connection can only happen via the internet and Port 1433 cannot be opened. The replication has to be enabled only via the intenet, which is why i figured web synchronization would be a feasible choice. I've since enabled the publisher and also set up the web synchronization on a SSL based virtual directory. However, while setting up a subscription on the client machine (using Management Studio), the first step in the wizard is to connect to the publisher. Essentially, i need to configure a subscriber to synchronize with a publisher using web synchronization over the internet, with no direct connection to the publisher. I've foll ...Show All

• Visual C# quick help please... XML attributes

  Hi all, I have a DataGridView that displays an XML file in it... the table has these column names: Name, Value, Data. After I've populated it I need to compare (via a method call) the data in the Name cell with the string value in the XML comment. So basically I'm comparing the Name cells value with the comment value in the XML file. The XML file contains the useual <name>, <value> & <comment> tags. How would I do that Also I want to color the cells Name & Value if they do not match private void SeeForMatch() { XmlDocument doc = GetXmlDocument(); // loads XML file DataTable dt = datagridView1.DataSource as DataTable ; foreach ( DataRow rows in dt.Rows) // loops through the datagridview1 or ...Show All

• SQL Server Question about OUTPUT clause

  In the past when inserting a record into a table with an identity column, to return the new identity value I used one of SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY. Question: will this sql 2005 approach also provide the newly added identity value insert into TestTable -- ID column of testtable is an Identity field output inserted . id , inserted . col1 into @insertedRecords values ( 'row 20' ) select ID from @insertedRecords TIA, Barkingdog . Sure can. Did your attempts not work Here is a script to demo: create table testTable ( testTableId int identity primary key, value varchar(10) unique ) go declare @insertedRows table ( t ...Show All

• .NET Development HTTpListener

  Hi all. I'm building an application which supposed to handle both remoting and web requests. After considering it, the best design for me seems to be a single (not distriuted) application , with HttpListner running in it to handle the web requests. Now, excuse me for my ignorant , i'm not familiar enough with IIS technical details.I can't figure out what exacly are the drawbacks of using HttpListener and not IIS. I do understand that i'm giving up application pools , application recycling and ISAPI handling. But what else What about security and performance issues Can anyone answer that, or maybe give a good link explaining it Thanks, Ido I think this is a reasonable thing to ...Show All

• Windows Forms StatusBar ToolTip Crashing

  Hello All, Quick Background: I have a UserControl that uses a StatusBar and ToolTip to allow a user to navigate data displayed in the control. On the main application there are a number of buttons that will create a new Form at runtime and place a static instance the main applications single instance of my control on the newly create Form. This was done because generating the UserControl is complicated and costly as far as memory and rendering is concerned. The Problem: If I place my control on one of these newly created Forms and the user hovers over an item that has a ToolTip it works fine the first time. The problem comes in that when the user closes the form the UserControl is removed and the Form disposed, and a user will click ano ...Show All

• Microsoft ISV Community Center Forums using dll file

  I have created a dll file using VB.net. And I want to use the function of the dll file in VBA. How can I do it Thank you Derek Smyth wrote: Hi, Think I know whats going on. When you registered the DLL you should have created a type library file, think it's a tlb file although I cannot remember. This file describes to VBA the types, in this case HelloWorld, thats availiable in your managed DLL. The other computers must need this file. If this file wasn't there then VBA on the other computer doesn't know about the types stored in the DLL and it would through an error, especially when you created an instance of that type. Think you need to register the DLL on every machine also. Try it and s ...Show All

• Visual FoxPro Showing one form from another

  Situation: I am in a form A, click on a cmd, and it opens another form B and hides the current form A. In form B, I click on a cmd and I would like to show form A and release form B. The release of form B works, of course, but not the showing of form A. I have never seen anything about whether it is possible to make changes in or affect one form from another. Is it (I guess it would work with a form set ) Hans L Well, when it comes to names (individuals), for instance, I will be able to sort on both last and first names (I very often remember only one of them). In addition, I intend to create incremental search, that is, you press "L", and you get down to the "L" people, and then you pr ...Show All

• SQL Server Unicode text file messed up <> DTS

  Hello I need to import a unicode text file with a DTS. The textfile needs to be imported width fixed column width settings as there are no field delimeters. The data in the file is messed up (some columns are concatenated) when opened in Notepad. The data looks fine when opened in Wordpad and also all fields are nicely delimeted but then I end up with unicode characters which are not supported in Wordpad. Is there anyway around this Many thanks in advance! Best regards, Worf If it's fixed width it shouldn't matter if fields are delimited. You just need to know the feild lengths for each column. I don't understand your question about notepad and wordpad. You said it's nicely delimit ...Show All

• Visual Studio Express Editions Combining numbers

  Hi everyone, I am struggling to implement a combining numbers game with recursion. The game is about : you enter some numbers, and then a value, then the program tries to determine that wherher with these numbers, this value can be obtained or not. But when I compile the program, I got peculiar errors as the following: Would you please help me in correcting the errors ------ Build started: Project: hw2, Configuration: Debug Win32 ------ Compiling... SymmetricMatrix.cpp c:\documents and settings\mert\belgelerim\visual studio 2005\projects\hw2\hw2\symmetricmatrix.cpp(440) : error C2228: left of '.length' must have class/struct/union type is 'int []' c:\documents and settings\mert\belgelerim\visual studio 2005\projects\hw2\hw2\symmetr ...Show All

• Visual Studio Express Editions Just in time debugging - registry settings

  Ok, I have decided, in spite of the complexity and the problems encountered so far, I like this IDE and will switch to it. In the spring, when I get some spare change, I will purchase the pro version. Got to have a resouce tool and a little assembly stuff. On my PC, running VS2005 Prof, it is set to: "C:\WINDOWS\system32\vsjitdebugger.exe" -p %ld -e %ld I'd be surprised if the Express edition has JIT debugging support... ...Show All