Amjath's Q&A profile

• SQL Server Improving conversion performance

  I have a varchar(max) field that is on its way to a Term Lookup task, so it requires conversion to DT_NTEXT before it gets there. The conversion is taking a really, really, really long time. In my current example I have about 400 rows. Granted the length of the varchar(max) if I 'select max(len(myColumn))' is approximately 14,000,000 so I understand that I'm moving a lot of data. But I'm on a x64 machine with 4 dual core processors and watching Task Manager I can see that I'm only using 1 core out of 8. Anything I'm missing that can speed this up Thanks, Frank Thanks for the pointer to the excution thread information. It was taking upwards of 20 minutes to convert the sampling of rows I had. I w ...Show All

• SQL Server Auto Print

  I am using Visual studio 2005. This may be a vb question but it deals with reporting services. I have a local report using the reportviewer control. (rdcl 2005 fmt) It displays perfectly, and when i click the print button it prints flawlessly. How do i print the document to the default printer automatically This seems like a basic function that i can't seem to find the answer to. Thanx Jerry Cicierega I found the answer. Its not as bad as it looks. Thois is a form called "slip.vb" I am printing to a slip printer. The form has a rpt viewer on it. The form nevers shows. It is just used as a containor for the report. I created the report as an RDL report. I coppied it into ...Show All

• SQL Server Running Access XP Macro with script task

  I found this and have done everything it says to do, but I can't get the script to compile. Any ideas on how to run a access macro in SSIS Baiscally to execute an Access Macros in SSIS package we need to Download Microsoft .Office.Interop.Access DLL from Office XP PIAs. Download site http://www.microsoft.com/downloads/details.aspx FamilyId=C41BD61E-3060-4F71-A6B4-01FEBA508E52&displaylang=en 1) Extract the Microsoft.Office.Interop.Access DLL from Oxppia.exe 2) Drag and Drop Microsoft.Office.Interop.Access DLL to Global Assembley Directory(GAC) ie: C:\WINNT\assembly for Windows 2000 -- C:\WINDOWS\assembly for ( Win Xp and Win 2003) 3) Copy paste Microsoft.Office.Interop.Access to C:\WINNT\Microsoft.NET\Framework\v2.0.50727 ...Show All

• Software Development for Windows Vista Shell Namespace Extension's default action not called

  Dear Friends I have a shell namespace extension registered under "My Computer". It is working well in Windows XP. I got some problems in Windows Vista. I am unable to navigate my NSE items by double click in the listview (The single click in treeview working fine). Nothing happened when I double click on an item. But in windows xp the item opens and all child items are shown While debugging I have find that vista's explorer never invokes the GetUIObjectOf() with riid for IContextMenu during the duoble click. If I right click an item Vista's shell asks the IContextMenu interface and the menus are shown correctly Is there anything changed in vista Also I find some other unknown interface's requested in GetUIObjectOf() &am ...Show All

• Visual C# Chess in C#

  Someone Know where have a example a open source about chess, because I'm wanting to see a modol.. Thank you! There are many Chess applications written in C#, take your pick: Valil.Chess Yet Another Chess Board Control #Chess A Chess Program using C# Just to name a few. ...Show All

• Visual Studio Express Editions Insert problem with Stored Procedures !!

  Hi ,i'm writing a win app with C# Express and SqlExpress , when i insert a new row to my DataBase with the following syntax , any thing works good ,but the Data will not really insert to the database, and when i restart the application i see that the insert statement didn't affected, please help me about it: Stored Procedure : ALTER PROCEDURE dbo.CatAdd ( @CatName nvarchar (50) ) AS INSERT INTO Categories ( Name ) VALUES (@CatName) RETURN C# Code : using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; namespace Library { class Categories { public void CatAdd( string CatName) { ...Show All

• .NET Development WinFX and Interop

  Hello everyone! Right i was wondering since WinFX (.Net 3) is part of the Subsystem in Windows Vista if its possible to use the Managed API framework to communicate with other running applications using User32.dll in .net 2.0 i have to use Interop to import the dll and manually managed the code. But since WinFX is a subsystem surely there is already a managed API for User32 or something I cant find anything about the new WinFX features or documentation on the new procedures, namespaces and classes. Does anyone have any links or ideas to some form of documentation or anything of interest Thanks Thanks for the article link. Why do Microsoft continue to make silly mistakes Since .net 3 isnt actually anyth ...Show All

• Visual Studio Uninstalling Visual Studio 2003 Standard after installing Visual Studio 2005 Standard Upgrade

  Does anyone know whether or not it's completely safe to uninstall Visual Studio 2003 Standard after installing the Visual Studio 2005 Standard Upgrade good question. hmmm I always thought that you need the previous product installed if you have done an upgrade. I guess you could restore it back if things went wrong using System Restore ...Show All

• Windows Forms How to have Application Name be the same but have different versions in Start-Programs

  We would like to have a Test version of our application and a Production version that can be installed on the same machine at the same time. However, we would like the *.application name to be the same. We just want the name that appears to the end user in the Start Programs list to be different (like "AppName - TEST" versus "AppName - PROD"). We're having trouble accomplishing this. Is this possible and if so, what variables do you set up to accomplish this Thanks much. You should be able to do that using mageUI by editing the Name and Description [Publisher, Product] of the application file. Let me know if this is what you're looking for... ...Show All

• SQL Server Using dynamic paths in XQuery

  Hello all, I'm trying to retrieve data from xml by using a variable for the path which will be set dynamically. Here's the code xml-1: <LOOKUP source=" /Catalog/Participant/@rating "> ... </LOOKUP> xml-2: <Catalog> <Participant rating="30"/> </Catalog> sql: declare @src varchar(100) set @src = @xmlNode.value('( LOOKUP/@source)[1]' , 'varchar(100)') select xml_data.value('sql:variable("@src")','int') from xmlTable I set the @src variable to the value of the source attribute from xml-1; that value is the path to the integer value in xml-2 stored in the xml_data column. The error I'm currently getting: Conversion failed when converting the nvarchar value '/ ...Show All

• Visual Studio Team System Exception thrown when executing unit test

  I have VS2005 Team Edition. In my test, I am creating an instance of a class that I intend to test. When I execute, the 'new' statement throws an exception: Test method UnitTest2.UnitTest1.TestMethod2 threw exception: System.TypeInitializationException: The type initializer for '<Module>' threw an exception. ---> <CrtImplementationDetails>.ModuleLoadExceptionHandlerException: A nested exception occurred after the primary exception that caused the C++ module to fail to load. ---> System.Runtime.Serialization.SerializationException: Serialization error.. The assembly containing the class does have a reference to a C++/CLR (interop) project. When I modify the experiment to instantiate a class in the interop project, I ...Show All

• .NET Development datatable.Compute(expression, filter) How to incorporate a function into the expression

  Can ADO.NET do this Is there a solution because iterating record is time consuming. Here is the code : private Bool EvenStatus(int myFieldData) { if (myFieldData % 2 ==0) return True; else return False; } Here is what I would like to do : incorporating the local method above "EvenStatus" into the compute method : messageBox.Show(dataset1.myFile.Compute("Count( EvenStatus (total) )","total>10").ToString()); How about just creating a calculated column DataTable and DataColumn Expressions in ADO.NET - Calculated Columns Regards, Dave ...Show All

• Windows Forms combobox help

  i use a combobox to in my programme to dispay text Me .comboBox1.Items.AddRange( New Object () { "Capacitor" , "Polycapacitor" , "EHT" , "Remote" , "Resistance" , "IC/Transistor" , "Other" }) now i want that user can only selct from above chice & can't type his choice in combobox combobox to work like a list box from which user can chose only from choces but can't write ...Show All

• .NET Development Fatal Flaw in the Large Object Heap?

  Hi All, After playing with the GC I find the following interesting. The problem domain I typically work in requires the allocation of very large arrays for image processing. We have discovered some issues when our processes are long running. We run out of memory and can not reclaim it. Our only recouse is to restart our processes. In an effort to discover why I uncovered the following: The LOH (Large Object Heap) is never compacted. I think this is a fatal flaw in the GC. I understand MS stated reason for this, but shouldn't there be someway to compact the LOH if necessary, at least a method call that forces the issue Does anyone know of anything that can be done Any workaround is better than killing the process... Here is a demo ...Show All

• Smart Device Development Accessing data on a form opened usin ShowDialog

  Hi, I'm using VS2005 .net2 form Windows Mobile 5 I have Form1 and Form2. From2 is opened from Form1using ShowDialog(). I want to return text from a textbox on Form2 to Form 1. The following code works of standard Windows form applications but fails to compile for .net compact applications. The error msg is 'Form2' does not contain a definition for 'TextBox1' ,. Even though it does. I have set the 'Modifier' property for Form2 to public but it still does n't recognise it. Does anybody know of a solution Thanks Form2 testDialog = new Form2 (); // Show testDialog as a modal dialog and determine if DialogResult = OK. if (testDialog.ShowDialog() == DialogResult .OK){ MessageBox .Show(testDialog ...Show All