Pat Jones's Q&A profile

• .NET Development Connect to Access DB and want to count number of Tables, Get Names of Queries

  Hi, I have connected to Access 2000 using ADODB written in VB.Net (Windows Form) and want to find a way to count the number of tables that exist and get a collection of tables names, query names, form names. Does anyone have any idea how I would do this Thanks in advance. Grant. Query the system table SELECT MSysObjects.* FROM MSysObjects; You can get the queries, tables etc. based on the Flags value. ...Show All

• Visual C++ Getting Error - Regarding stdafx.h

  I'm trying to fool around with the new Visual studio version (2005 Beta 2) and for some reason it keeps telling me: \Practice.cpp(1) : fatal error C1083: Cannot open include file: 'stdafx.h': No such file or directory A long time ago someone told me to go into the properties of the project and change the default to CLR support. I did this time but it doesn't seem to build.  Can someone tell me what to do   Here is my code: #include "stdafx.h" #using <mscorlib.dll> using namespace System;   int _tmain() { int Number = 5, Number2 = 0, Number3 = 7; int sum = 0; Console::WriteLine( "hello world." ...Show All

• Windows Forms Open Child Window ONCE

  Hi, I created a Parent form and a main menu, where user can select and click a menu item and Show a child MDI form. I'm able to add a "tick" beside this menu item on the main menu, but how can I "disable" this menu item so that user can NOT click on this menu item AGAIN and open n x this child form   ...Show All

• Visual Basic Mathcad DLL

  Can I write a Mathcad DLL using Visual Basic 2005 Maybe making one from a class The last VB program I wrote was in VB6 and I've never written a C program, so I am very new to this. I have to make a function available to Mathcad and I only have very old C examples. Don't worry Bill The transition from Older versions of languages to .NET versions is something that many of us have dealt with an concepts may vary but once you get it and do more development using newer versions - you not want to look back. The forums are designed for you to ask questions, get answers and gain knowledge. ...Show All

• .NET Development sitemap issue: Enable securityTrimming will disable external link in sitemap

  The Enable securityTrimmingEanbled is set to "true" in my web.config file in order to protect admin only sitemap menu. The problem is I can't use external link such as http://www.youwebsite.com in the sitemap. The menu item will disappear from the navigation bar. If I don't use "http://", just www.yourwebsite.com , sitemap will treat it as local server link. If I set Enable securityTrimmingEanbled to "false", this will take care the "http://" problem. But then the admin menu will show up to public. I don't know this is a bug. Sure I have an old school way to work around it but I would really lik ...Show All

• Architecture Designing web apps in the enterprise

  Hi all, In my organization we have multiple web apps, each of them serving a different part of the organization. Because the vision is that all apps will be using the same infrastructure and might share information (pages and services), the original design of the web site was to declare a single web site (single virtual directory), and each of the apps will just be a folder in the site (meaning all apps will use the same iis application). Of course there is another option in which the infrastructure is built into usable assemblies (cache management, security utils ...) and each of the applications will have it's own virtual director ...Show All

• SQL Server COnfiguring Number of records per page?

  Is there a way I can specify how many records per page should be displayed > This is a very basic functionality that needs to go in the deployment at any cost for us ...any ideas. thanks I want to display more records in one page however, it seems at most display 55 records per page Is it right If so, how to change that Thanks ...Show All

• SQL Server stored procedure return/result behaviour change from 2000 -> 2005 ?

  Hello, Can someone please help explain if the way MS SQL Server 2005 returns result from stored procedures is different from MS SQL Server 2000 The problem i am having is that i have lots of code that used to connect to SQL-2000 and did this: SqlDataAdapter da = new SqlDataAdapter(sqlCmd); ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) //process rows SqlCmd Type is a StoredProcedure btw, in SQL-2000 if the stored procedure result is empty, i still get one table in the dataset tables collection "table[0]", and the table is empty; in SQL-2005 however i get NO tables at all if the result is empty, whi ...Show All

• Visual C# How to connect to microsoft excel workbook?

  How can i connect to microsoft excel workbook so that i can insert, update and delete data from my program i am using microsoft .net framework 1.1 Hi, Yes your right there. The Jey Provider only retrieves data. If you want to modify the source then I suggest to access the excel worksheet via VSTO (Visual studio tools for Office) or use the PIA(Primary Interop Assembly) for Office and lastly you can access it via COM objects. Here is a useful link that might help you: http://support.microsoft.com/kb/q301982/ cheers, Paul June A. Domag ...Show All

• Windows Forms Dynamically loading MDIchildForms in runtime

  Hi all, I would like to create an application where i can easily add / update components (e.g. inventory component, customers component) to the application without modifying the main project. I tried to design the architecture based on a MDI-application where I define the components in MDIchilds. The MDI-parent is then the main project. Each MDI-child has to be registered in a database and subsequently based on a user's credentials, this MDI-child can be loaded. Also based on these credentials, the user menu is dynamically created. But the problem I have at hand is that the MDI-child forms have to be declared during design-t ...Show All

• Microsoft ISV Community Center Forums Charts.Add method causing error

  I needed a macro to add a chart with a very specific format. I created a macro that usually works, but I am getting an error that I don't understand. Here is a snippet from the macro: Set chartRange = Selection Charts.Add ' This line results in a "Type Mismatch Error" the first time it is run ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=chartRange, PlotBy:=xlColumns '... When I open a new sheet, and put some data in and run the macro, I get a type mismatch error for the Charts.Add line. When I abort the macro and try the very same thing again it works fine for as long as I have the workbook open. Then, if I close t ...Show All

• Software Development for Windows Vista WinFX Runtime Components 3.0 Beta 2 installation problems

  Hello, I was using the February CTP until Beta 2. I’ve downloaded the new WinFX Runtime Components 3.0 Beta 2 and I can’t install them. I’ve uninstalled older version using the tool Microsoft has provided ( the MSI file ) and I’ve also removed several other components that I thought could cause the problem. I’m still receiving the following error: [05/24/06,00:29:52] VS Scenario: [2] CPrevProductInstalledCheck failed : <font face=Verdana size=8pt> Thank you for participating in the Beta program. You must uninstall all pre-release products in a specific order before you can continue with setup. For detailed information, see ...Show All

• Visual C++ Exposing the base constuctors from derived classes.

  Hi, I'm trying to extend the std::basic_string class by adding some additional overloads here and there... I know that you can "re-expose" functions ahta re hidden by the derived class by using "using BaseClass::FunctionName". However, I can't do it with base constructors... it goes something like this: class BaseClass { public: BaseClass( int i ) { cout << "Base: " << i << "\n"; } BaseClass() { cout << "Base\n"; } void print( char *str ) { cout << str; } }; class DerivedClass : public BaseClass { public: DerivedClass( float f ) { cout ...Show All

• SQL Server How can I join information from different datasets?

  I want to know how to join information that is in 2 different datasets into a single table. Thanks P.S. Also having problems with data driven subscription, it simply won't connect to the database with subscribers, always getting the logon error. Thank you for your answer. P.S. Do you have any guidelines for me for the second problem Also posted it in another thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=124613&SiteID=1 ...Show All

• SQL Server Script Component - Overidable Methods/Functions.

  I am looking for a list of either generally used or a full list of overridable methods/functions for a script transformation I tried looking in the Visual Studio behind the script component but it only gives one method namely, Input0_ProcessInputRow, or if you make it asynchronous then it gives you another method CreateNewOutputRows. I am basically looking for all the available overridable methods behind a script component in various situations. Thanks, Andy. Position the cursor outside of Input0_ProcessInputRow method but still within the class definition. Then type: "public overrides & ...Show All