jluce's Q&A profile

• SQL Server dynamic query

  Hello friends, I want to create a dynamic query based on input of the parameter. If the user passes nothing then all fields should be displayed else use query based on parameter. I had view sample of MSDN ,but I got error [BC30203]. Is there another way to it Please help. u can use the query in this way, SELECT AreaName, AreaCode FROM Area UNION SELECT ' All' AS Areaname, '' AS AreaCode ORDER BY AreaName This will add 'All' n ur drop down box n using case statement in query u can get the desired results. regards Satyendra ...Show All

• Visual C# Deleting Directories off a network drive

  So here is an interesting concept that I have not quite figured out. I am attempting to deleted all directories on a network hdd.  The drive is obviously mapped already.  See if I create a temp folder on H: (hdd) named "A" and insert it into the path "H:\A", it will be deleted with this try.  I have a windows form with a button to execute the event.  I have a textbox to output the results.  My buddy says that I should be able to do this, but I catch an exception because its not an "absolute path".  There is a method call that will grab the string directories in an array.  GetDirectories( ) which is pa ...Show All

• Visual Studio Add IVsUIHierarchy to Team Explorer

  Hello, I've been trying to extend team explorer with my own hierarchy.  I can get it to the point where my root node shows up fine, and there is a plus icon next to it indicating that it knows there are leaf nodes inside of it, but if I try to expand it, the leaf nodes don't show up and the plus icon disappears. In my implementation of the BaseUIHierarchy class, I've added trace statements in ExecCommand and QueryStatusCommand, but they never seem to get called. Keep in mind I'm quite new to extending VS, and haven't been able to find any documentation for these classes. Thanks The PcwTESample was added ...Show All

• Visual Studio Team System Team Explorer - red cross on "documents"-folder

  Since installation of TFS I am unable to see the content of the documents-folder (teamexplorer) on a client-machine. There is always a red cross on the folder! If I start the team explorer on the server the documents folder is shown correctly. I tried to copy the http-url ( http://[servername]/sites/[Project ]) to an IE on a client and there the sharepoint site is shown without any problems. I did the changes required after installation of Sharepoint Portal Services SP2 ( http://blogs.msdn.com/robcaron/archive/2005/10/07/478336.aspx ). I think I also configured the users like mentioned in the install guide (TFSInstall-v50926.chm - Manag ...Show All

• .NET Development VERY slow binary serialization of strings coming from SQL

  Please help! This is probably the weirdest issue I've ever encountered. I'm trying, in C#, to binary serialize an array of strings that come from a SQL Server 2000 database.  Problem is, this takes orders of magnitude longer than if the strings don't come from the database. The EXACT same 35000-length array of strings takes 0.1 seconds to serialize if the strings don't come from the database, and 40(!) seconds to serialize if they do. So for instance: ...     SqlConnection conn = new SqlConnection("...");     //In my database, this will return 34769 rows     SqlCommand comm = new SqlComm ...Show All

• Visual Studio DMD -> DD helper tool (contribution)

  Hello. Modelisoft has created, for its own experimentations with the DSL Tools, a tool named Dmd2Dd  which makes it possible to remove and create shapes and connectors in the .dd file, when you rename or add concepts and relationships in the .dmd file. The created elements have reasonable names deduiced from the .dmd named elements. And some default resource bitmaps are created as well. This tool makes it possible to get a solution where the code is generated (by the "Generate All" command) and build without any warning / error (if, of course you start from a solution without warning / error) ! We think that this (very simple ...Show All

• SQL Server How to access data in resultset returned in variable by ExecuteSQLTask

  According to the BOL documenation of the ExecuteSQLTask you can populate a variable with a resultset. I specified a variable of type 'Object' and followed the instructions and everything is fine untill then. However later I want to access the variable in a script task and it appears that the variable is populated with a System.__ComObject. How do I access my rows from here Your suggestions would be appreciated. Regards, Henk Because I want to use the table as an in memory lookup table and need to look up the content from a script. ...Show All

• SQL Server Previous and Next functions

  Hi, I am tasked with duplicating many Oracle report in SRS. One uses a stored proc to get a list of people and sorts them by name. It then prints in red those names that are duplicates. It uses this bit of code to do it: If {PlayerName} = Previous ({PlayerName}) or {PlayerName} = Next ({PlayerName}) then Red else Black I don't find any quite so simple functions to do this. I'm at the moment using VS2003 against SQL Server 2005. Thanks, Fairfield We do have a Previous function http://msdn2.microsoft.com/en-us/library/ms156372.aspx Next is not currently supported. An alternative way of d ...Show All

• Microsoft ISV Community Center Forums How do you test a user's input for alphabets?

  Hello programming gurus! Is there anyway to test if a user's input contains only alphabets Thank you! Hello. You can accomplish this by utilizing regular expressions. Here is a brief article one how this is accomplished in VBA. http://www.mvps.org/access/modules/mdl0063.htm Here is a site to test your regular expression (has some nice tutorials too) http://regexlib.com/RETester.aspx ...Show All

• Visual Studio Tools for Office how to set the cursor at the end of the bookmark?

  Hi, I am adding a bookmark dynamically in word document using vb.net. All i want is i want to set my cursor position at the end of the bookmark text. Here is the code i am using to create bookmark. Dim rng As Object rng.Text = "bookmark1 text" Connect.applicationObject.activedocument.Bookmarks.Add("bookmark1", rng) Any help would be appreciated cheers Praveen Since this isn't a VSTO-specific question, the right newsgroup to ask this would be the Word programmability newsgroup: http://msdn.microsoft.com/newsgroups/default.aspx dg=microsof ...Show All

• SQL Server XML index fails

  I'm trailing SQL Server 2005 for an invoice management system. We are using the Universal Business Language (UBL) for our invoice format. The UBL is a rather complicated hierarchy of 19 schemas, but I can register them easily as one schema collection (CREATE XML SCHEMA COLLECTION - this was works much better than the Oracle schema registation system I must say). I can also create a table with a typed XMLType column which is bound to the UBL schema collection. The problem comes when I try and create a primary XML index on the table. I get an error saying that a composite primary key cannot contain more that 16 values. Has anyone had similar p ...Show All

• Visual Studio Express Editions Tutorial for working with VB 2005 & access?

  Does anyone know of a simple Tutorial for working with VB 2005 beta 2 & access - This cant be hard, I just cant find the info I need. I want to build a form to read from an access DB as well update the same DB. I just need to see in detail how the info gets passed. Thanks a bunch, Steve Yeah...patience never was my strong suit either   It gives ya something to look at while you wait for your book Most of the samples are for MSDE (free SQL Server with 2Gig limit) or SQL Server anyway. I just added a datagridview control which gave me a wizard to connect to an access database, chose a table to view i ...Show All

• SQL Server AS2005 September CTP Memory Error

  I get "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed." while executing query set with cube browser in SQL Server BI Dev Studio. The same error I get while executing query with VB code (via ADOMD). The source of the error is AS2005 OLEDB Provider. One important information: I have installed Sept CTP on clean Windows XP Pro, there were no previous versions of SQL 2005 installed. Any ideas what's up Maybe some missing parameter in connection string I agree.  I have gone through all sorts of uninstalls and ...Show All

• Visual Studio Deployment of Package in MS Dev 2003

  I am having trouble deploying my VSIP Package in Dev Studio 2003.  The merged menus are not available when running Dev Studio (this works in the debugger). I followed the directions in the Deployment guide, including: * Added the elements to the registry: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\7.1\Packages\{<guid>}] "ID"=dword:0000006a "MinEdition"="Standard" "ProductVersion"="1.0" "ProductName"="<product_name>" "CompanyName"="<company_name>" @="<short_name>" "InprocServer32"="C:\\WINDOWS\\system32\\mscoree.dll" "Class"="<fully qualified className>" "Assembly"="" "CodeBase"="<full path to DL ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. multichannel audio

  Hi there, I'm wondering if it is possible to program a soundcard with e.g. 5.1 option as if it had 6 mono channels. I already tried faking it with directsound3D but with no success... I wan't to be able to play a sound on e.g. channel 1 and 5 (frontleft and backright) but not on the other channels. If this is not possible using directx anyone got an idea on what else to use I think this must be possible ONE way... Thanks in advance, Patrick I havn't tried much, just starting out with audio in DirectX, but you might want to have a look at the Xact systems for your audio needs. "The Mi ...Show All