ScottM124's Q&A profile

• SQL Server Sql server Express 2005 Advanced

  Have been trying to use an 'iif' statement as a simple expression within a computed column. I cannot get the server to accept the statement. Every variation of commas quotes, spaces within the iif statement produces the same result. The statement is very simple : iif(Mileage>0, Mileage*.40, 0). The column is of data type 'money' and mileage is a numeric field (within the same table of course) I'm in the process of adding data tables into a new database, using Management studio express. Could someone please give me a valid example. I have worked with Access Databases for a number of years and am rapidly losing what is left of my ...Show All

• Windows Forms Databinding combo box

  I am working on an MDI application. I have a list box and combo box in one child form. The irony is that the selectindex does not work even when I set the selectindex property to -1. The same application works fine when it's not a child form. Have any one of you came across this situation before Any thoughts Thanks- Sathish Wel ...Show All

• Visual Studio Can't debug ASP in VS2005

  VS2005 doesn't seem to support debugging ASP pages. Is this really so That's a serious problem if it is. Thanks Jeremy No, she meant IE. Can you clarify what you mean by 'refuse to debug them'. Do you see your ASP documents in the Script Explorer window As for the many requests to bring back auto-attach support for ASP debugging, what are people looking for: Debug classic ASP code locally Debug ASP code + .NET code (either a .NET COM object or ASP.NET code in the same process) Debug class ASP code on a remote computer Case #2 and #3 are pretty hard to solve. On the other hand, Monica's ...Show All

• Visual Studio MSBuild and BizTalk Projects: (VS2003 & BTS 2004)

  Has anyone used MSBuild successfully to build BizTalk 2004 projects which are written in VS2003 A project that I'm just starting at work will be using Scott Colestock's BizTalk Deployment Framework and having MSBuild invoke NAnt for the process. Just an idea. ...Show All

• Visual Studio .Net Framework CANNOT uninstall or reinstall

  Hi All, My .Net Framework 1.1 does not give me the option to repair. I tried to reinstall, but it did not work because it gives me a message saying that I already have the current version installed. I'm trying to uninstall previous version of .Net Framework before doing a clean install of SQL Server 2005. When I tried to uninstall in Add/Remove, the following file it asked for, and I don't think it is on my harddrive - tmp1DD.tmp - any help that I could manually remove .Net Framework, I would appreciate it!!! or a tool that I can manually run to uninstall all files associated with .Net Framework, I would really apprecate that! Sincere ...Show All

• .NET Development How to use System.Net.Mail.SmtpClient via SSL and Authentication?

    Below is my code, and is just blocked there. There is no any error message. '=============================================>         Dim msg As String = "---"         Try             Dim strAddress As String = " xxx@xxxx.com "             Dim sm As New SmtpClient(Host, Port)             With sm               &nbs ...Show All

• Visual Studio Express Editions Hello from a returning learner...

  Hello from England! :) I learnt VB a while back but I've lost my skills since then and now I've decided to learn how to program in VB 2005 Express Edition and I was wondering if I can copy the code that I have from the programs that I previously created into the new version... Also, where can I get software that allows me to create customised splash screens from, especially transparent ones and also are there any good tutorials that teach you how to program calculators and notepad software... On another note, would I be able to get advice here on any code that I post here... Hi there, As far as ...Show All

• .NET Development Operation must use an updateable Query

  Hi, I am using VS 2003 and C# with OleDb connection to read and write from Excel spreadsheets. I have no problem reading Excel data but when writing to Excel I got this error on this line: oleCmdInsert = new OleDbCommand(@"INSERT INTO [Sheet1$A1:A1] VALUES ('ABC')", _oleConn); oleCmdInsert.ExecuteNonQuery(); Here is the error: System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPAR MS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCo ...Show All

• .NET Development SqlCommand and Multiple Select INTO Statements

  Hi, can i put multiple select into statements (to create temp tables on my SQL Server) in one SqlCommand and execute it. For Example: Select * into ##tmpTable1; SELECT i.Email ,Min(s.ssID) as FirstSkin ,Min(v.SessionStarted) as FirstVisit ,Max(s.ssID) as LastSkin ,Max(v.SessionStarted) as LastLastVisit ,Count(DISTINCT s.ssID) as Skins ,Count(DISTINCT p.ProfileID) as Profiles_Created INTO ##email_addresses FROM Skins s LEFT OUTER JOIN Sessions v ON v.SkinID = s.SkinID LEFT OUTER JOIN Entries e ON e.SessionID = v.SessionID LEFT OUTER JOIN Profiles p ON p.ProfileID = e.ProfileID LEFT OUTER JOIN PersonalInfo i ON i.ProfileID = p.P ...Show All

• Software Development for Windows Vista Creating a Window from an activity

  I was trying to make a WPF window display in a custom activity's Execute method (that won't return until after the user dismisses the window). The thread that my activity executes on is a MTA thread which doesn't work for WPF windows. Is there another way I should go about running my window Thanks,   Tony You should be doing this in the host. Use the MethodInvoke and EventSink activities to communicate with the host and have the host code communicate with your UI. ...Show All

• Visual Studio Tools for Office Let me know

  What is the difference between between vba2003 and visual studio tools for office plz let me know VBA allows you to write macros and unmanged code within a given application, such as Excel or Visio. You write the code using a basic IDE. Visual Studio Tools for Office allows you to create managed code solutions using VB or C# for Word, Excel, InfoPath and Outlook. You write the code within Visual Studio, thus giving you all the benefits and advantages of this professional developer environment. I hope this helps! Mike Hernandez Community Program Manager VSTO Team ...Show All

• Visual Studio 2008 (Pre-release) How to develop avalon applications on Windows XP?

  Hi all, I am new to avalon. Can anybody tell me how do i go about developing avalon applications in Windows XP. I have visual studio 2005 installed. What else do i need to do Cheers, Natasha Thanks Peter! That was really precise and it worked. Cheers, Natasha ...Show All

• Windows Forms Force XP Themes usage (even user turns it off in WinXP settings )

  Hi all, As everybody knows we can use XP Themes to change visualistion to more futuristic (like Win XP does). I use <b>Application.EnableVisualStyles</b> and it works fine. But my question is: Is this possible to force using themes even user turns it off in Windows settings  I optimised my forms to use themes, and I like new look very much. If user turns ...Show All

• Windows Forms Problem with combobox in datagridview

  When using combobox columns in a datagridview, I've encountered the following problems: 1. I'm working with a datagridview which contains a databound combobox. The edit mode of the cells = EditOnEnter. When I select a comboboxcell for which no value has been selected yet, and I try to sort the grid on another column (in my case a text column), then I get the following error:    Value of '16' is not a valid for 'rowIndex' Where 16 is the index of the row I've selected. The above problem doesn't occur when edit mode = EditOnKeyStrokeOrF2. 2. If the selection mode of the grid = FullRowSelect (and edit mode = EditOnKeyS ...Show All

• Visual C++ OpenGL library integration problem

  Hello there! I have the Visual C++ 2005 Express Edition. At school, we use VS 6.0, therefore, my projects should work on that platform as well (btw: are there compatibility issues between the two ) Now to my problem: I have downloaded the glut library from on of my teacher's site, the same that we use in school. The copied the glut.dll in the Debug folder, under my project, and the glut.h and glut.lib and glut.def under the same folder as the rest of the .cpp files. Now, when I do this at school, it all works out nicely, but here, I get an error message like this: <path>"/glut.h(137) : fatal error C1083: Cannot open include file: 'GL ...Show All