szzhouke's Q&A profile

• Visual FoxPro Determining opened files

  I would like to ask if anybody knows how to determine how many files are there in a form during run time. Yes I mean "tables", sorry about the confusions. Well I also found another way to get the number of tables used a by form. "nTotMem = AMEMBERS(amems,THISFORM.DataEnvironment,2)" Thanks ...Show All

• SQL Server Problem connecting to SQL Server 2005 database instance

  I have an old ASP app that I have had to migrate to use SQL Server 2005. I have two pages that are virtually identical (one is edit only the other makes provision for adding new records - I didn't write these apps but I am responsible for making them work now). One page connect successfully to the SQL Server Instance and the other does not. They are using EXACTLY the same connect string. The only weird thing that has transpired is that we migrated to Active Directory recently. The ASP app that connects successfully was already on the web server prior to AD migration. The one that does not connect successfully was migrated after AD migrati ...Show All

• .NET Development Application Configuration Settings error "is a type but is used like a variable"

  I'm trying to write to an application settings file.  I'm using VS2005 and am following the example found at http://msdn2.microsoft.com/en-us/library/ms171565.aspx I added a settings file to the application and it modified my app.config as you see below: < xml version="1.0" encoding="utf-8" > <configuration>     <configSections>         <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >             & ...Show All

• Visual C++ simple question

  i was reading mfc book by jeff. i had installed vs 2005 . i tried simple programme but it does not works just add this to onpaint CPaintDC dc(this); CRect rect; GetClientRect(&rect); dc.DrawText("hi ",-1,&rect,DT_CENTER); but there is no display in output That looks fine to me. What sort of project did you create Did you use a template What class is handling your onpaint method If you put in a breakpoint, does it get called ...Show All

• SQL Server Custom ControlFlow

  I am trying to design a Component which can be configured by a UI. After Configuration from the Design pane the Data should be passed to the back-end of the Component. When I look at some code samples I only see, that it's possible to pass simple data. What I want is to put a grid on the UI and connect it to a DataTable. This is used for displaying and changing a configuration as a table. Well, the question is: Can I pass the DataTable object to the backend-DLL as is If so then how THX Fridtjof Can you please clarify whether you are creating a custom Task or a custom Data Flow Component, or another type ...Show All

• Visual C# Cannot view XML input using XSL style sheet...What the f****

  I'm trying to add a web reference to my project. The web service was created from a microsoft tutorial that ships with the Express version. The following message is what I get when I try to add the 'convert' service. Any suggestions The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. ...Show All

• Visual C++ Refering API Dlls

  Hi, I have a very basic doubt. I'm having a static api dll and a header file for its function prototypes. how can i call it from a vc++ project. (I need very basic information like where to change the configuration to include that dll to project)... Advance thanks... Muthu R. Krishnan You terminology "static API dll" is confusing. Is it a static lib, or is it a DLL DLLs expand to Dynamic-Link Libraries, and are not static in nature. I'll assume you have a DLL. You'll need to #include the DLL's header file (you said you have one). There'll also be an import lib (that contains stub functions), which you'll need to a ...Show All

• Visual Studio 2008 (Pre-release) Package Load Failure

  Howdy.. Just got this nasty error and wondered if anyone could help me to resolve it fast I have been running Expression Interactive Designer on a test box along with the Cider extensions for VS.. all running sweet... I installed SQL2005 on the same box for some further testing and now when I go to open a XAML page in designer mode in VS, i get a Package Load Failure with the specific package being.. PresentationDesignVisualStudio Anyone Another strange side effect of this is that now when I went to repair the Cider extensions, it pops up with a dialog that says WinFX is not installed... I can assure that it is, and all to the very latest ...Show All

• SQL Server variables in sql command

  Hello I have an existing DTS package and I convert this to Integration Services but now I have a problem: i have in my dataflow an OLE DB SOURCE and an OLE DB DESTINATION In the source I have the following sql command: IF '<<FullLoad>>' = 'Y' BEGIN  SELECT *  FROM  Maintenance_Departments END ELSE BEGIN  SELECT *  FROM  Maintenance_Departments  WHERE Last_Updator_Date_Time BETWEEN '<<StartDate>>' AND '<<EndDate>>' END The <<FullLoad>>, <<StartDate>> and <<EndDate>> are variables, these variables must be replaced  with a value ...Show All

• Visual Studio Express Editions problem installing/running new Visual C#.Net express Beta2

  Hi, After uninstalling the Beta1 version of VCS.NET, I downloaded and installed the new VCS express Beta2. Upon starting the VCS, there's an error saying: Package 'Visual Studio Settings and Projects Designers Package' has failed to load properly, followed by some GUID. Resetting the 'starter page' as mentioned in the previous posts, doesn't work at all.. Upon continuing to create a new windowsApplication, I get the error : Could not load type 'Microsoft.VisualStudio.Shell.Interop. IVsRunningDocumentTable2' from assembly 'Microsoft.VisualStudio.Shell.Interop.8.0, Version=8.0.0.0, Culture=neutral,PublicToken=b03f5f11d50a3a' and the form will ...Show All

• Visual Studio Tools for Office Action Pane disappears

  I have an Excel Template solution developed using VSTO 2005 that has controls on the Action Pane. I have a custom menu button that the user can use to toggel the Action pane on and off, and everything works fine until the user attempts to open an additional Excel file. If a user opens another Excel file from Windows Explorer by double clicking or selecting open from the context menu, the Actions Pane goes away. I then switch back to the original VSTO document, and using my menu button attempt to restore the action pane. The code displays the paction pane, but now all of my controls are missing. Here is the code the I use to toggel the v ...Show All

• Windows Forms Where is sqlexpr32.exe?

  I have built a C# application that I'd like to distribute on CD with all prerequisites included on the CD so that the end user doesn't have to download any of the redistributables. They include .NET framework 2.0, Windows Installer 3.1, and SQL Server 2005 Express Edition. When I initially tried to publish with the "Download prerequisites from the same location as my application" setting, I was presented with errors such as: Error 5 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'SqlExpress\sqlexpr32.exe' in item 'SQL Server 2005 Express Edition' can not be located on disk. ...Show All

• .NET Development How to dynamically load schema from a file and then assign to xmldocument and validate it

  I am creating in memory xmldocument. Previously I were validating my file against a dtd file and then by the help of GetElementByID read my needed node. i.e. XmlDocumentType doctype = null; doctype = statementsDocument.CreateDocumentType("queries", null,statementsPath +"\\Validation.dtd", null); statementsDocument.AppendChild(doctype); nodeElem = statementsDocument.CreateElement("queries"); statementsDocument.AppendChild(nodeElem); .... Now I have created validate.xsd.I don't know how to validate through xsd file Sometime Later I want's validate from this validate.xsd then read my element by Get element ByID ...Show All

• Windows Forms Populate a listview from a datatable

  Hello All, I was wondering if someone might be able to point me in the right direction when attempting to populate a listview control by means of a datatable Could anyone provide a working example of this kind of iteration Cheers, sfx1 Loop through the datatable and add your items. In this example you should set the Listview to show details. At least it will get you started: <begin loop construct> ColumnHeader myHeader = new ColumnHeader (); myHeader.Text = "Header 1" ; myHeader.Name = "Header1" ; this .listView1.Columns.Add(myHeader); ListViewItem m ...Show All

• SQL Server SSAS 2005 with Kerberos/Delegation

  I tried posting this to the MS OLAP newsgroup, but didn't get much response, so I'll try here. I've been trying (and failing) to get Kerberos delegation to an SSAS 2005 server working. I've followed all of the steps on: http://www.mosha.com/msolap/articles/kerberos_delegation.htm But still no luck. Delegation is working fine with SQL Server, but not Analysis Services. I've verified the SPN, connection string, enabled delegation, configured with web site (typical IE to IIS to SSAS setup), etc, but no luck - the connection to the server always shows up in Profiler as "anonymous", and the connection fails. Are there any tools or tricks ...Show All