KenRumble's Q&A profile

• SQL Server Any full-text gurus - Help writing a query

  I'm not sure how I can best phrase this, but I need help writing a query that is inflectional, thesaurus and non word ordered specific. In other words, say a user is looking for a "car wash" but types in "wash auto" or "auto wash" or "vehicle wash" or "cars washed" or "washing cars" or "car and auto wash" or "automobile car wash", etc.  I still want a result produced of the entry in the database "car wash", how can I produce this query. Another example, say I want to produce a result of a record in the db "server administrators - sql" and a user searches for "sql server administrator" or "sql administrator", how can I produce the r ...Show All

• SQL Server small scale (light weight) SQL search engine (basically a stored procedure) to search through Products Table

  Hi, I am attempting to build a small scale (light weight) SQL search engine (basically a stored procedure) to search through Products Table. I am passing a search string, which i break up by the ' ' (space) delimiter. next for each [value] (after breaking up) in the search string I want to be able to count the number of occurences of each [value] in the [ProductName] [ProductDescription] fields of the [Products] table. However I am confused as if its even possible. We can count the number of rows(or products) that contain the [value] in either of the [products] data table fields but i don't know if its possible to count the number of occuren ...Show All

• Visual Basic Trying to sum using the input box function

   I have some questions:  1.)  How do I sum (i.e. check amounts) using the inputbox function. 2.)  How do I get the input box to average the sum of the checks divided by the number of checks entered into the input box function  3.)And, how do I  have the results show up in a lable using words to introduce the sum. There are some problems here I haven't quite conquered:  the summing of any amount of numbers, method,  combining a to string method with a double precision floating point number and averaging any amount of #'s.  All the code I find just relates to st ...Show All

• Windows Forms WebBrowser Control and the "PATH" environment variable in XP vs. 2000

  I have an application that requires a WebBrowser WinForms control that will load pages containing ActiveX Controls that are pre downloaded as part of the application installation process. Part of the installation requirement is that we not have to register the controls. We've been able to do that by using Environment.SetEnvironmentVariable to set a "PATH" variable for the process to the location of the controls. However, this does not seem to work on Windows 2000. IE in both cases has been updated to the latest version possible and the settings on the browsers are identical aside from the settings that exist in XP and not 2000. Does ...Show All

• SQL Server Complex sql (inefficient multiple column count)

  Hello, I'll simplify this to the minimum. I have a table kind of like this. CREATE TABLE prospect (     prospectID     int,     groupName    varchar(10),     statusID          varchar(2) ) There could be thousand of records with many different combinations of each groupname, or statusID. e.g. 1000,'Control','A' 1001.'Control,'B' 1002,'Base','A' 1003,'Test','B' statusID could be 'A' or 'B' or 'C'.  and groupname could be something like 'Control', 'Base', 'Test'. I am trying to make ...Show All

• Visual C# how will i know that the checkbox is clicked not an item in a listview control?

  I get this ArgumentOutOfRange exception everytime I click the checkbox column in my listview. I'm using the Click event and not the SelectedIndexChanged for some reasons. heres the event code: public static int sel_index = -1; private static string selectedItem = "" ; private void lvwCategory_Click( object sender, System. EventArgs e) { sel_index = lvwCategory.SelectedIndices[0]; //the error is here, the index 0 selectedItem = lvwCategory.Items[sel_index].SubItems[1].Text; } I got it: if (lvwClientCategory.SelectedIndices.Count > 0) { sel_index = lvwCategory.SelectedIndice ...Show All

• Windows Forms ToolboxBitmap doesn't work

  Hi, I'm trying to associate TextBox's image with my UserControl that contains TextBox and Label... I've put an Image with the name of the control in the project folder and it works, but when I try the following, iI just see the standard wheel (for custom control): [ ToolboxBitmap(typeof(System.Windows.Forms.TextBox))] public partial class MyTextBox : UserControl Any ideas Thanks, Marina { Hi...  What I'm trying to do is to list all the controls in a form with their images in a treeview (like document outline), but most of my controls in a form are UserControls so I don't want to show a "w ...Show All

• .NET Development C# Finalizer for .Net Framework class System.Security.Principal.WindowsIdentity

  Ok, first I'll not bark at the obvious poor choice made to not support a 'delete' statement to force finalizing an object; rather I'll assume your approach is correct... According to everything I've read, If you allocate unmanaged resources within an object one should support the System.IDisposable interface and free resources there. This post is to point out that in the Framework 1.1 the class System.Security.Principal.WindowsIdentity allocates a global windows handle when instantiated with a security token.  This handle is not released until the destructor is called.  This is contrary to your own best practice, is it not Backgro ...Show All

• Windows Forms RegionMaster C# to VB.NET References

  I'd like to use the RegionMaster functionality in my VB .NET application. I have followed Mike Harsh's instructions on MSDN TV - though the components have been coded in C#. When I add a reference to my VB project by browsing to the RegionMaster DLL I don't get any components appearing within my toolbox - what do I need to do to achieve this ...Show All

• Visual Studio WebService project for multiple solutions

  hello, I've got 2 solutions which are referencing 1 common webservice project. this webservice project references project, which are part of one of the 2 solutions) If I want to build the solution 1, the webservice project can't find the references to the projects in solution 2 (because I can only add references which are part of the solution). I already created a postbuild step (referencing the .dll files), which copies the dll into the /bin dir of the webservice project, but the problem is, that this dir is "readonly" because it's checked in. So I can't proceed using this way. Does anybody have a possible solution, how t ...Show All

• Smart Device Development view animated GIF files?

  How can i view animated GIF files using netcf 1.0   http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnnetcomp/html/animationcontrol.asp frame=true   ...Show All

• SQL Server Linked server distributed query doesnt work

    Hi,  The distributed query seems to work on the management studio of the server where I have linked the other server to but not accross the network on other management studio with the same impersonated logins. The error I get is.   OLE DB provider "SQLNCLI" for linked server "usbo-sql01" returned message "Communication link failure". Msg 10054, Level 16, State 1, Line 0 TCP Provider: An existing connection was forcibly closed by the remote host. Msg 18452, Level 14, State 1, Line 0 Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. ...Show All

• Visual Studio 2008 (Pre-release) Messages larger than 12K fail with security enabled

  Hi, I have an operation that returns a large data structure. If the structure exceeds 12k in size then I get a timeout at the client side, but only if SecurityMode is set to SecurityMode.Message. This is the case for bith NetTcpBinding and WSHttpBinding. Any ideas If I enable trace at the client side I can see the following exception is present in the trace file: System.ServiceModel.Security.MessageSecurityException: Message security verification failed. ---> System.Xml.XmlException: The maximum array length (16384) has been exceeded. at System.Xml.XmlExceptionHelper.ThrowXmlException(XmlDictionaryReader reader, String res, ...Show All

• Visual C# Windows Media Player Help

  Is there any way of retreiving Windows Media Player's current playing track i've been looking through all of the classes, interfaces, and everything else in wmp.dll but i cant find anything. is it possible to get the name of the song what i mean by that is the ID3 song info. i know how to do this but i dont know how to make an instance of it using new.         WindowsMediaPlayer media = new WindowsMediaPlayer();         IWMPMedia m = new media.currentMedia();         string z = m.name;   that's the current code that im us ...Show All

• Visual Basic So where are the tutorials? (DirectX)

  So I've downloaded visual basic several weeks ago, done alot of tutorials, and downloaded the directx sdk (april release). So where are the tutorials for vb Do you have to download them somewhere else There are some in the coding for 4 fun developer center . ...Show All