JRC Systems's Q&A profile

• .NET Development XML as a data source and holding it in memory

  I am trying to get an application working that would use XML as a data source. I need help in getting this to work with the data designer in VS 2005 (I am using the express version right now). I like the data designer due to the ease of use and I basically would like to use XML using some kind of table adapter in VS 2005. I would also like to hold the data in memory while the app is running ( with a save periodically) I am trying to avoid reloading the data for each form. If this is a simple question I apologize. All help is appreciated. SG ...Show All

• SQL Server Exporting Stored Procedures to a file

  I have a need to export all of the stored procedures in a database to files on the server dirve. I know that this can be done through the management interface but I need a way to do it programatically. I need to have a script or stored proc that dumps all of the procedures to a defined location on disk. Does anyone know how this can be done Thanks! There is an article with a stored procedure that does this at http://www.databasejournal.com/features/mssql/article.php/2205291 Also a slightly different approach to the same problem at http://www.databasejournal.com/features/mssql/article.php/3401081 , though the first way is prob ...Show All

• Visual FoxPro Connecting VFP applications on Wide Area Network (Client-Server).

  How do I connect VFP Application running on windows Small Buisness Server through WAN What do you mean Do you mean connect a VFP frontend application from a remote site to your VFP data residing on your Small Business Server host Please tell what do you want to fulfill with your app. ...Show All

• .NET Development How can I use and RSA securID to strengthen authentication

  I would like to use a username/pin/rsa securID to gain access to my application. Has anyone used the RSA securID with a forms app Does the .NET 2.0 framework natively support RSA, or do I have to buy some 3rd party stuff Thanks. Check out the following link, hope that might help http://www.codeproject.com/dotnet/RSACryptoPad.asp ...Show All

• Visual Studio Express Editions Visual C++ 2005 Express Edition with OpenGL -- Can't get started

  I'd like to get started using OpenGL with Visual C++ 2005 Express Edition. I've installed VC++ and the PSDK. I've tried to start a new Win32 application, and here's the exent of my code: // OpenGL Stuff 2.cpp : Defines the entry point for the console application. // #include "stdafx.h" #include <GL/gl.h> int _tmain( int argc, _TCHAR* argv[]) { return 0; } The error returned when I try to "Build -> Build OpenGL Stuff 2" is as follows: c:\documents and settings\mfunke\my documents\visual studio 2005\projects\opengl stuff 2\opengl stuff 2\opengl stuff 2.cpp(5) : fatal error C1 ...Show All

• Windows Forms Control the size of the Context Menu Popup?

  I have a context menu: m_AddRowContextMenu = New DMS.ToolBox.ContextMenuStrip() Add some Items (200 maybe...): For i As Integer = 0 To 200 m_AddRowContextMenu.Items.Add("Item" & i.ToString() ) Next Show the context Menu: m_AddRowContextMenu.Show(Me, mousePoint) The popup is HUGE! I want to show about 20 Items, with scrolling. I can't figure out how to change the size of the popup. It makes itself whatever size it wants. How can I set this programatically Thanks, Sean I don't see the benefit of showing huge ContextMenu. At any rate, isn't window ...Show All

• Visual Studio Express Editions Adding OWC Components to the ToolBox

  When I tried to add the OWC Pivot Component to the ToolBox by going to the Tools, Choose Toolbox items, I can not add a Pivot Table Component that I can drag and drop. I can see the item listed but it is greyed out. I usually just add the component as a another scripted tag on the page, but to access the component from VS, I think that I need to drag it from the ToolBox to enable the server-side script to access it. I can drag the HTML components, so I know that the installation is not obviously corrupt. What am I being stupid about Thanks, Leo   ...Show All

• Visual Studio Team System getting associated changesets for work items

  Hi, I took a code snipit from James Manning's blog: http://blogs.msdn.com/jmanning/archive/2005/09/21/472524.aspx For some reason, the LinkingUtilities object could not be resolved. Does anyone know where the assembly for this object is We upgraded to RC1; would this matter Is it still supported Also, I was wondering if there was a way to get historical changes to work item links. Suppose I added and deleted links associated to a specific work item. If I retrieve the original revision of that WI, can I retrieve the original list of links as well Thanks. The links and attachements are ver ...Show All

• Visual C++ Share Projects in one solution

  Dear all, I create two projects, say A and B, in one solution in VC.net 2003. They are basically 2 executable applications, A.exe and B.exe.   In project A, it uses some classes created in project B. I include the header B.h in A.h, and add Additional Include Directories to which B.h resides.   Compile is OK but when linking it looks like the LINKER does not know where to link obj in B project and gives the error messages like this: ATest error LNK2019: unresolved external symbol "public: __thiscall HelloWorld::~HelloWorld(void)" ( 1HelloWorld@@QAE@XZ ) referenced in function _main I do not want to c ...Show All

• Visual Studio C# Express 2005 and Report

  Dear All,   I am using C# Express 2005 and SQL Server Express 2005 as well. I am planning to use no-touch deployment as well. At the moment, I am stuck as I cannot find any report designer to make my report work in the enviroment of C# Express. Is there any way or extension that I can include into the C# Express so that I can use to build the report Highly appreciate your advice.   Regards,   LG Install Visual Web Developer 2005 Express Edition ( http://msdn.microsoft.com/vstudio/express/vwd/download/ ). Then install the Report Designer and Report Viewer control from http ...Show All

• SQL Server Retrieve Values from SQL Server into Winforms

  Hi all, I want to insert information like SQL Server Version, current sql server user etc into a form, How will I achieve this   I have followed this question at http://www.vbforums.com/showthread.php t=357605  ,but I havent had an answer to my question yet.  Please help, I am stuck and can't go on with my application until I have figured this out. Thanks alot in advance Rudi Groenewald You can use various SQL Server Functions for this ( http://msdn.microsoft.com/library/default.asp url=/library/en-us/tsqlref/ts_fa-fz_7oqb.asp ).  Here's an example: select serverproperty('ProductVer ...Show All

• SQL Server Performance, handling 1.2 million rows takes 7-8 hours?

  Hi! I'm working on a project restructuring some data using SQLIS. The problem is one package that is handling about 1.2 million rows takes about 7-8 hours to complete. To my question, is there any of the dataflow components that are know to be slow that you should avoid regarding performance issues The following list is a brief specification over the component that are contained in the package: ------------------------------------------------------------------------------------- 3 OLEDB Data sources. 2 OLEDB Data sources. 3 Derivied column objects. 1 Union which unions all rows from the sources above. 2 look up component ...Show All

• SQL Server convert minutes to hours

  hi, I want to convert minutes to hours. for example field_minutes=130minutes to 2:10 hours... select field_minutes from table---> how can I do Not sure what this has got to do with SSIS but its an interesting little puzzle for a Friday afternoon anyway. Paste the following into SSMS/QA and run it: declare @mins int set @mins = 130 select cast ( @mins / 60 as varchar ( 5 )) + ':' + RIGHT( '0' + cast ( @mins % 60 as varchar ( 2 )), 2 ) There are probably other, better, ways!!! -Jamie ...Show All

• Visual Studio HTML Editor Context Menu

  Does anyone know what the Guid and ID to hook the HTML editor context menu is There is additional information regarding this post in the GetMarkerCommandInfo in HTML Editor thread ...Show All

• SQL Server CLR SP to Transform Xml (SecurityException)

  I am in the process of creating a simple managed stored procedure using C# and VS2005. The goal is to transforms an Xml document with a Xslt file that may contain a very simple script . < msxsl:script language = " C# " implements-prefix = " user " > <![CDATA[ public static string Lower(string value) {return value.ToLower();} ]]> </ msxsl:script > At this stage my stored procedure code is extremly simple. [Microsoft.SqlServer.Server. SqlProcedure ] public static void Manufacture( string xsltFile, string xmlFile ) { XslCompiledTransform xslt = new XslCompiledTransform ( fals ...Show All