LouArnold's Q&A profile

• SQL Server excel data problem

  I have a foreach loop that loops through each excel file and load data to a staging table. Lets say i have file A.xls and B.xls. When loading data from A.xls to the staging table data looks fine, however, loading data from B.xls one of the column did not convert data as string, instead it converted some of the number as 1.000e+7. In the advance editor, i've set the output as a Unicode string and my excel connection string is appended with IMEX=1. Sill, the data is converted correctly for some number, others it converted as x.xxxe+x. Anyway i can force the data to convert "as is" I've experienced a related problem. I wanted to import a column which is alternating in text and numeric values. Since ...Show All

• Windows Live Developer Forums Updating Live Toolbar Custom Button

  The example given in the updating section of the Windows Live Custom Toolbar button is very basic. I would like to know if I can UPDATE the custom buttons' links and text, or change the shortcut to view a webpage instead of a drop-down menu through the use of a buttonupdate.xml file. Thanks Im having the same prob...... u posted awhile ago so u prob fig it out.. I know they have a cutom toolbar sdk section on MSDN but the link is dead.... I dont even know how to begin editing a .btn file. I think another option is to do it over using ms gallery section.. its easier than trying to use the sdk... ...Show All

• Visual Studio Express Editions Major new discovery: the Platform SDK's MFC source code can be built and used with VC++ Express

  As you all may know, MFC is not included with Visual C++ Express 2005.   You'd have to purchase VC++ Standard edition to get MFC. But the MFC source code (no binaries) happens to be included with the Platform SDK, in the folders: <installed Platform SDK folder>\SRC\MFC and <installed Platform SDK folder>\INCLUDE\MFC There are some make files in there (mfcdll.mak etc), but the main MAKEFILE and export DEF files are missing.  If you have a copy of Visual C++ 6.0 you can get these missing files.  I have sucessfully built this version of MFC (both debug and release) and run a test app using this rebuilt version (I named it MFC42E.DLL) with very minor changes to the source cod ...Show All

• Visual C# new and shiny

  Yep I'm new and shiny to C# - coming from a C and Java background. Been looking for something that lists the base class's apis (preferably HTML - kinda like java's api if at all possible) to get a general idea of what classes are available and what they can do. Have 2 books ordered but would like to get a head start if possible. I have quickly looked at the specification doc provided in the visual studio - not exactly what I am looking for (or maybe just the format of it through me off) as well as a couple quick googles (maybe I am using the wrong search phrases) and a very quick search on these forums (base class api and a few variations). Links, google search phrases, or a spoon/clue would be appreciated. ...Show All

• Visual Studio 2008 (Pre-release) Bitmaps & the Adorner layer

  I have wired up an MFC app to display a WPF panel as a view using the HwndSource mechanism. It all works fine, except nothing on the adorner layer (which I use extensively) is visible. Is this a limitation of the integration technique or is there some way I can see adorners Thanks, Jeremy Okay, after a bit of flailing, I determined that adorners are working just fine in this context. The problem was that certain dependency properties were tied to config file settings which did not exist in the context of this MFC host application, and therefore the adorners had an opacity of zero, causing them to be invisible. Thanks to all who responded. However, I have another question which is tangentially rel ...Show All

• Visual Studio Team System Only one CUBE in Team Foundation Server

  When I open analysis services in BI studio I only see one CUBE for TFS. However per my book I should be seeing multiple CUBEs. I wonder if anyone knows what could be going on here thanks In some beta verions of TFS, there were actually separate cubes. That may be where the confusion started. Here's some info that explains the cube structure. http://msdn2.microsoft.com/en-us/library/ms244710.aspx Allen ...Show All

• .NET Development Search, create or update a record

  Hello, I'm trying to do a search on a dataset and if I find a record matching a value, I want to update the record; If i don't find any record, I want to insert a new. I've the following code: Imports System.Data.OleDb Dim cmd As OleDbCommand Dim dsNR As DataRow Dim cb = New OleDb.OleDbCommandBuilder(da) con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & DbSource & ";" sSQL = "SELECT * FROM [Numeros_Dia] WHERE (Data= '" & DataRelatorio & "')" da = New OleDb.OleDbDataAdapter(sSQL, con) ds.Clear() da.Fill(ds, "Numeros_Dia") If ds.Tables(0).Rows.Count = 0 Then dsNR = ds.Tables(&q ...Show All

• SQL Server Package configurations stored in the database

  If the configurations are stored in the database then does the package pick up the configuration as and when required or it a one time pick when the package is executed. What I plan to do When the package is executed, I want to have a script task at the start of the package that will update the configuration table in the database with the values that the package needs to run with. I mean change the values of the configurations of the tasks which will be executed after the script task. Thanks for your time. $wapnil spattewar wrote: What I plan to do When the package is executed, I want to have a script task at the start of the package that will update the co ...Show All

• Visual Studio Team System Continuous Integration builds not wanted in WorkItems Details

  Hi, I finally managed to setup the contiuous integration build for our new TFS system. As expected I have about 20 builds per day, and the problem is: they all show up in the WorkItems->Details->FoundInBuild and WorkItems->Details->ResolvedInBuild dropdown lists. After two days I have about 40 builds in the lists, not very funny. The continuous builds are not associated with any items, I included a SkipWorkItemCreation tag in the build definition. But as contiuous builds produce lots of entries in this lists I don't want them in the dropdowns. We have release builds that are different from the continuous builds and they should show up here, nothing else. Any properties I have to set or tasks I have to define/overwrite ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Error in SpriteBatch.Draw() call with SpriteSortMode enum

  Hi all. I wrote a simple program using XNA to test the differences of SpriteSortMode.BackToFront and SpriteSortMode.FrontToBack options. I created two Texture2Ds and call SpriteBatch.Draw() method and feed it with SpriteSortMode.BackToFront, the program run well. But every time I call SpriteBatch.Draw() with SpriteSortMode.FrontToBack, the program threw an unhandled exception called NotSupportedException with the message "Specified method is not supported." Is this an error in XNA framework, or had I made some mistake in my code Please help me. Here is my code: #region Using Statements using System; using System.Collections.Generic; using Microsoft.Xna.Framework; using Microsoft.Xna.Framework.Audio; using Microsoft.Xna.Framework. ...Show All

• Visual C++ MFC App. Resizing CEdit boxes

  I have a MDI window. I have A CTreeCtrl box on the top left and a CEdit box to the top right. Along the whole bottom is another CEdit box. When ever you drag the corner of the window to resize nothing expands with it. I've search every where with no solution. So how do i resize everything or just lock the window I've tried to use a splitter but i havent been able to implement it.. When you resize a window, you will get two messages You will WM_SIZING message when you dragging the corner to resize the window and WM_SIZE once you committed the resizing. for immediate effect on dragging you can either do the resize on OnSizing (handler of WM_SIZING) function or WM_SIZE after committing the resizing. Anyway yo ...Show All

• Gadgets Is it possible use xaml in gadget with transparent background ?!

  Is it possible use xaml or xbap in gadget with transparent background ! I used iframe to place xaml app. But if i try to change g:background size during Docking or Undocking it is doesn't work properly. So my gadget is now without background... Is any way to solve this problem P.S.And when I'm closing gadget with xaml, sidebar is hiding. Is it bug of side bar Thank you for your reply. I have been already solved this problem too by using System.Gadget.background instead changing style for g:background.src Now it is work proprely. ...Show All

• Visual Studio Express Editions HOW TO: Listview Control (Listindex)

  I have a simple application that display the current log record of an employee who logs into the system. Everytime the employee tap her/his ID card on to the barcode reader, his/her current log record will appear into the listview control, I am using Visual Basic Express 2005. The problem is I am new to this language, and I really don't know code on the how to focus the last item entered into the listview control like what I did in visual basic 6 below: List1.AddItem "MyName" List1.ListIndex = List1.NewIndex Anybody can show me the simple code on how to do this Thank you very much:) perhaps List11.SetSelected( List1.Items.Add( "MyName") , True ) List1.Items.Add() ...Show All

• Visual Studio 2008 (Pre-release) Frame.Source supports directly XAML, HTML but not XPS

  Is it really by design ...Show All

• Visual Studio Visual Studio SLOW performance problem.

  Hi, I am using Visual Studio 2005, and I recently found it becomes very SLOW to build and publish projects. This problem perhaps happened when I was experimenting publishing WPF project onto a web server via VPN. I post it at http://forums.microsoft.com/MSDN/showpost.aspx postid=1037188&siteid=1 and went ahead to install the service pack 2, but it is still not working. I came across this blog today http://weblogs.asp.net/achang/archive/2004/05/04/125645.aspx , and found out I have similar sympton. Visual Studio builds project without any delay when I disabled the network! I was not able to follow the instruction Alex proposes since I am using Visual Studio 2005. Does Microsoft have a fix for this problem Please help! Re ...Show All