qpeHukc's Q&A profile

• SQL Server Looping through an excel spreadsheet

  Being new to SSIS I wish to loop through a series of excel spreadsheets and within each workbook loop through each sheet. I am aware of the For Each container but how can the each sheet in the workbook be referenced Steve Thanks Jamie, my problem is for each spreadsheet I loop through how do I reference each sheet / tab within the spreadsheets returned by the For EachLoop. Thanks Steve ...Show All

• Windows Forms Binding ComboBox and DataTable including a None entry.

  Hello. We would like our customers to select a country, but it is not required. Thus, the top-most entry shall be "<None>". We read the countries from our database and bind the DataTable to the ComboBox. How do we go about adding a None entry to the ComboBox We can't add a None row to the DataTable or DataView. Is there a property on the ComboBox I'm missing or something Cheers, Chris ...Show All

• Visual Basic Trying to get StatusStrip on a Form to display text

  Hi I am trying to display lines of text I am reading from a file to the status bar.  I want to see progress of the programme through the file contents, but not through the message box as I have to close it for each line and their long files and that soon get tedious! Please see code below... All I get is the hour class - I need to trap end of file but first I wanted just to display the progress. Ideas anyone Appreciated - Regar ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Maya exporter problem

  I use microsoft's exporter in Maya 6.5. But when load the mesh, vertexformat in meshData is None. So we cann't compute the vertex normal. How can we solve this problem ...Show All

• Visual Studio Team System Is there a way to get more detailed scan results of FxCop?

  Hi, We are making a tool that displays the data generated by FxCop. However we couldn’t get the total scanned rules of FxCop, FxCop Analysis Report only contains the details of failed rules. (Screenshot: http://www.ssw.com.au/SSW/Standards/BetterSoftwareSuggestions/images/FxCopAnalysisReport.gif ) Is there a way to get the data to make a report that shows more information like SSW Code Auditor report (Screenshot: h ...Show All

• SQL Server Database is read-only.

  Hi I have been learning on how to use the new features of the .NET 2.0, and Well I using VS2005 and everything is pretty straight foward. I did a Membership webform where you log in and create users and roles etc. I installed the SQL Server 2005 express as my Data provider and thats where my Tables are. I used the aspnetsql_reg comand to integrate the server to this application. Anyway my problem started when i decided to copy my project to my ...Show All

• Visual Studio Problem installing Vs2005 on Vista Feb CTP

  I've seen this problem discussed on the forums before, bit with Vs beats. When installing VS2005 on Vista 2005 Feb CTP I get the message "Suite intergration Toolkit" and Fails to install. How can I get round this. Thanks. Hi, I had the same problem here ... This is a known problem as you pointed out ... Copy the VS2005 DVD onto your hard drive and launch install from there ... This ...Show All

• SQL Server How do I force new databases to be created on another drive on same server?

  I successfuly installed SQL Server 2005 Enterprise Edition today (on the first shot!) but can't figure out how to force new databases, etc to be created on another drive on the server. SQL installed on the c: drive (I had no choice!) but it is a very small partition. I need to install Sharepoint Portal 2003 next (on a different server) and want to make sure everything goes on the other drive. Help me, please!! Thanks :-) ...Show All

• Visual Studio Express Editions How to Create Simple Report as HTML ?

  I don't have any report generator and i want to build it myself. My reports are very simple with few constants  fields that i need to fill them after running some task and i wonder maybe to create a HTML document with const and desin tamplate and i will replace the relevant data in this document(text) and i will save it as temporary HTML file and show it with WebBrowser control as a HTML file . This action save me to deal ...Show All

• Smart Device Development accessing the strings of the string table

    hello everyone   could anyone tell me how to get the strings/text in the string table into a control - i mean can i anyways get a string/text from a string table into a control's caption (on a button click or some event) i have a smart device mfc dialog based application. in the application's dialog, i have a static text control and a button. i have included a string table in my application and inserted few strin ...Show All

• Windows Forms How to tell if a treenode exists?

  Hi everyone, I'm creating dynamic trees based on file-system structures.  Here's the code which isn't working:         myNodeCollection = oParentNode.Nodes         n = New TreeNode(bp(0))         If (Not myNodeCollection.Contains ...Show All

• Visual C++ import 3rd-party DLL

  I know that there are many threads about DLLs already, but they all cover the case that you want to import a dll you created yourself first. I'm trying to get the sqlite3.dll working with my programm. This is my code: #define sQliteDLL __declspec( dllimport ) int feedBack; sQliteDLL typedef struct sqlite3 sqlite3; sQliteDLL int sqlite3_open(const char* filename, sqlite3 **ppDb); sqlite3 *db; feedBack = sqlite3_open ("test.db",&db) ...Show All

• SQL Server MDX query returns double values

  I have a Sales Margin cube having Revenue,Cost,Margin as measures and customer,sales invoice,product group,time,area as dimensions.When i run the following MDX query, i get a value for revenue which is double the value i should get.I checked the fact table, value in the fact table for this measure is correct.Any ideas select {[Measures].[Revenue]} on columns, non empty [Sales Invoice].members   on rows from [Sales Margin] Regards ...Show All

• Visual Studio Tools for Office Updating Outlook Add-Ins Using Application Manifests

  I am confused about how to handle updates for outlook add-ins created with VSTO 2005. The functionality we need is that the add-in can also function when disconnected from the network and that new versions are downloaded from a web server when they are available. According to the various pieces of documentation i can find, the VSTO runtime uses the application manifest on the client to locate the deployment manifest (which can be on a web server ...Show All

• SQL Server SQL Server Express License question

  Do I need a license to use the SQL Server Express in a production environment I thought I needed an existing SQL Server license such as SQL 7 Please let me know. :) No, you don’t need to, you can register yourself to get further benefits like those mentioned on the site: http://www.microsoft.com/sql/editions/express/default.mspx HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All