vonlinkerstain's Q&A profile

• SQL Server stored procedure to count matching words between two strings

  hi all, I want to know that how can i write a stored procedure that takes an input param, i.e., a string and returns the count of the matching words between the input parameter and the value of a column in a table. e.g. I have a table Person with a column address. now my stored procedure matches and counts the number of words that are common between the address of the person and the input param string. I am looking forward for any help in this matter. I am using Sql server 2005. Here is one of the possible solutions for your problem. It demonstrates the combination of .NET and T-SQL approach for handling string-related tasks. Another possible solution is to use .NET stored procedure that will handle th ...Show All

• Visual Studio Team System Field-name used in error message

  When the Label of a field in the FORM section is different from the name of the field and a rule is not fullfilled at commit-time, the error shows the name of the field and not the name of the label. However the user can not find a field with that name because on the forms only the Label-name is showed. E.g.: if the "Found In" field required and the label for the field on the form has been set to "Build Version" then the error shown when the field is not set becomes: "TF20012: Field "Found In" cannot be empty". There is no field with a such a name on the form. Sagar Sura wrote: This is by design. The labels for just for the display and nothing to do with f ...Show All

• Windows Forms Event to check whether a list box is empty or not

  I need to enable button when the list box has items (not empty) and disable it when list box becomes empty. What event can handle this Thanks in advance, Alex. There currently is no event you can handle that will be raised when the Items collection changes size. The best you can do is have a method in your form (or create a new class deriving from ListBox) that adds/removes items and updates your button's state based upon ListBox.Items.Count. ...Show All

• SQL Server SQL Server 2005 Service Pack 2 CTP is available

  Hi, SQL Server Service 2005 Pack 2 CTP (Community Technology Preview) is available... http://www.microsoft.com/sql/ctp.mspx The list of new features and fixed was published here on KB Article http://support.microsoft.com/default.aspx/kb/921896 Regards Nilton Pinheiro www.mcdbabrasil.com.br The communicated timeline is "this quarter". HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions registering Visual c#

  I want to register my installation of visual c#. I have the registration key, and I am supposed to click the help menu of visual c# and select Register product - but I can't find the Help menu! There is none on the home page of Visual c#. Help, anyone The Help menu is not found on the start page but is instead a menu near the top of the screen. Starting from Left to Right you'll have Menu's such as File, Edit, View and so on... Help should be the last one on the right. ...Show All

• Smart Device Development Help!!! Error while installing .Net Compact framework in PXA-270 with WCE5.0

  While installing .Net compact Framework in my target platform I had faced the problem. Error code is 3(I think it means insufficient memory but it has enough memory) 20/02/2007 15:05:48: Entered Install_Init(). First Call: Yes Previously Installed: No Installation folder is: '\Windows'. 20/02/2007 15:05:48: Build 2.0.6129.00 created on May 9 2006 at 06:29:32 20/02/2007 15:05:48: Device CPU: 'ARMV4I', 05020000 (84017152) 20/02/2007 15:05:48: MainstoneIII 5.00 20/02/2007 15:05:48: AKU string : '' 20/02/2007 15:05:48: OEM info : 'Nuark SIP Phone' 20/02/2007 15:05:48: Our trust level is: 2 20/02/2007 15:05:48: User LCID: 1042 20/02/2007 15:05:48: System LCID: 1042 20/02/2007 15:05:48: Invoker's command line: '"\My Documents\NETCF ...Show All

• SQL Server Populating levels and members

  The code given below helps in retrieval of dimension levels and members cubenamev stores the cubename dimyv stores the name of the dimension Dim dbConn As New ADODB.Connection dbConn.Open(strconn) Dim dtCatalog As New ADOMD.Catalog dtCatalog.ActiveConnection = CType (dbConn, Object ) 'code to populate levels and members Dim cubes As ADOMD.CubeDefs = dtCatalog.CubeDefs Dim cube As ADOMD.CubeDef Dim cubedefn As ADOMD.CubeDef cubedefn = cubes(cubenamev) Dim dimery As ADOMD.Dimension dimery = cubedefn.Dimensions(dimyv) Dim leveler = dimery.Hierarchies(0).Levels Dim level As ADOMD.Level Dim ...Show All

• Visual C# Using a class as a parameter

  Hi there! I have to pass a class (not an instance) as a parameter to a method, and I have no idea if I can do that -- tried various things and it doesn't work. It should behave like this: I have a BaseClass. Another ChildClass inherits it. The ChildClass has a method (or Property), static or not, that returns a class. The BaseClass has quite a few methods where this class is needed (to invoke static methods on it), so the BaseClass invokes the "GetClassINeed", which returns the static class and then uses it. The reason I need it is that I have about 30 of those ChildClasses, and they all need those methods defined in BaseClass. I don't want to add them in all of them if not needed. Also, to create instances of that Cla ...Show All

• Audio and Video Development audio/x-wav with attenuation

  Hi, Does attenuation work in HDiSim I've tried the following code: < object type =" audio/x-wav " src =" file:///dvddisc/ADV_OBJ/ding.wav "> < param name =" AttenuateL " value =" 100% "/> < param name =" AttenuateR " value =" 100% "/> </ object > Attenuation of 100% means silence, right Even if we do not set params like this: < object type =" audio/x-wav " src =" file:///dvddisc/ADV_OBJ/ding.wav "/> Specification tells us in 7.8.1-1 that default attenuation is also 100% i.e. silence again, right But HDiSim plays ding anyway. What's wrong Thanks in advance ...Show All

• Visual C# execute method from another form

  I would like to have a class with many methods used by all my project's forms. but how can access those methods available from inside of a form's class. thanks in advance, Edward there really isnt a best practice for this scenario perhaps. It all depends on the solution and architecture of your application. Generally if you needed to use the same object instances from various classes, then I would probably place them in a static class so you dont need to create an instance of the class which will have null/default values of objects, and that you can access the same instance/object throughout the lifetime of that application. I would have 1 class which will hold our commonly used objects, as a static ...Show All

• Windows Forms Merging Menus in .NET

  Hi there I need some help. Im creating a an application a little like Outlook. One shell which includes a verity of other sub applications loaded as plugins. My question is conserning the menu. What Id like to do is in my host application I create a menu with standard menu items like [File] > Exit [Help] > About. Those that are general for all plugins. Then when a specific plugin is loaded that plugin merges its menus into the host and again removes them when another plugin is activated. Very much like Outlook works where you have a New under File menu but when Mail is active New mean New Mail and when Calendar is active New means New Appointment. I have looked at ToolStripManager.Merge but I cant seem to get it working c ...Show All

• .NET Development failed to connect to an oracle 8i database

  Hello everybody, I hope someone would be able to help me… I need to programmatically talk to an Oracle 8 database located in a remote server. I have installed the client oracle 8 + Toad into my computers (Windows XP) and I have no problem connecting to this database by using toad. Then I added the System.Data.oracleClient dll to my project, imported it and tried to connect via my application, and had the ORA-12560 error. I can’t open the connection. My connection string is : “BaseName. UNIV-PARIS.COM (from the names.default_domain in the sqlnet.ora file); user id= ; password=” Have you any idea of what my problem is Thanks you for your help, Susana Hello ...Show All

• Visual Studio 2008 (Pre-release) Black Window on WPF RTM

  I just came back from TechEd Europe and installed Fx 3.0 on my production machine where I never installed any beta release before. As I open a WPF application, the screen become black. The only way to stop this is to shut down the WPF application (XAMLpad or VS.NET or other) via RDP on another PC (killing the process). Furthermore if I open a terminal service window on the same local machine, I see the window flashing and the ystem become unstable. I read this post ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=226400&SiteID=1 ) but I could not find any help or registry hack to solve. OS: Win2K3 R2 (all updates) - US language M/B: Asus P5WD2 Premium CPU: Pentium D Graphic Card: Nvidia GeForce 6600 Any help for this T ...Show All

• Architecture MVC when to use,MVC framework

  Hi, I need to know about MVC pattern.Is it the same what vs.net generates by default whenever we create a asp.net web application(generates a . aspx page and an . aspx.cs thus seperating model and view). If it is different , can somebody please let me know what exatly should be where.i read many article on MVC but didn't got any working sample to understand. Also need to know in what cases whould we use MVC pattern, as these days everbody talkes about that his application is based on MVC. Java has many MVC framewokrs.Do .net also have any such regards Model, View, Controller pattern is not the same as the code behind in visual studio. MVC splits the user interface into 3 parts. The Mode ...Show All

• Commerce Server Some problem importing 2002 catalog to 2007

  I was able to import a catalog from 2002 to 2007 without any error message. But when I inspected the catalog in catalog manager, products with variants are not being imported properly. For example: <ProductVariant listprice="5" Item_x0020_Number="614" rank="8" Color_x0020_Image="614_sw.gif" Variant_x0020_On_x0020_Sale="No" Variant_x0020_On_x0020_Sale_x0020_Through_x0020_Date="2006-10-31T11:56:33" Variant_x0020_Regular_x0020_Price="5" Out_x0020_Of_x0020_Stock="No" Variant_x0020_Sort_x0020_Order="8" > <Variant_x0020_Name Value="Misty Brown" language="en-US" /> <Color Value="SC10" language="en-US" ...Show All