Paul Burg's Q&A profile

• Windows Forms Some files only needed on CD, NOT installed in target dir

  I have several files in my setup project that I want to have available on the CD in the rare case that the user needs them, but I do not want them installed in the target directory. (It's a Marketing thing - they don't want users poking around in these files unless we tell them where to find them.) I do not see a way in Studio 2005 setup projects to include files on the CD but not actually install them. Any suggestions It's an issue of automating the build process so that it will be idiot-proof for the next programmer who follows (whenever that may be). If they have to manually create a directory or two in the build output directory and then drag and drop files from several locations, you can ...Show All

• .NET Development Better way of removing commas

  Here is the situation, using C# and VS2005, one has a string that contains a number. Unfortunatley the originator of the string is ouputing commas within the string such as "1,234,567.89" What is the best way to strip commas from a string Below is a method I have come up with that seems like it is overkill... Can it be replaced with an easier, meaning less code on my side, way of doing it advTHANKSance I am not sure if I am missing something here but won't a Double.Parse( "1,234,567.89") return a double value w/o the commas ...Show All

• SQL Server Dynamic query

  Hello I have a problem with writing a query.Let me give an example: Table: ColA , ColB , ColC , Col1 , Col2 , Col3 , Col4 , Col5 Ok.I must write a SP and it gets a parameter,say @param. if @param=1 then in the select statement I will select Col1,if @param=2 then I will select Col2 and so on. How can I do this Thanks. Joey gives an answer how. You could also do: declare @query varchar(max) set @query = 'select col ' + cast(@param as int) + ' from table' Or if the column names aren't actually numberd, use a CASE expression to pick the columns. The question I have is why do this If all columns are only useful one at a time, this is probably a design issue. If this is to support some use ...Show All

• Visual Studio Breakpoint will not currently be hit. No symbols loaded for this document.

  I have been 'developing' with Visual Studio 2005 for about 3 weeks now - primarily .NET class libraries developed with VB. I am coming from VB6, although I did a lot of development with Visual C++ several years ago, so I am still trying to come to terms with the debugger. I have read many threads posted by people who are having a problem with breakpoints, specifically with the message in the subject line above. There have been many suggestions on how to fix this problem. Sometimes these suggestions work, sometimes they do not. Most of the suggestions involve deleting DLL and PDB files and rebuilding, or restarting Visual Studio. None of them suggest any problem with something the developer has done or any problem with the configuration of ...Show All

• SQL Server R

  Hi Experts, After performing some tests on my setup I recorded very large performance degradation between simple setup and mirrored setup (High Availability – with witness). In some inserts tests (100K in a loop) it took up to 400% longer to complete for mirror setup compared to the simple one (40 seconds compared to 170 seconds). Is this performance hit normal Is there something that can be done to make it perform better The PCs are connected using a 100MB switch and I'm using SQL Server Developer Edition. Thanks, Avi Thank you all for the replys. I use two dual Xeon PCs with 2GB memory. The disks are fast too. The performance without the mirroring is great - over 2000 inserts per ...Show All

• Software Development for Windows Vista Vector window scaling

  I remember I saw the Windows calculator was scaled like a vector image in the Illustrator at a Vista (or Longhorn at that time) beta demonstration movie. What happened to that feature Is it discontinued ...Show All

• Visual C# how to use SMPP

  I am developing an application with C# to allow users to send SMS message.. we have SMS gateway provider here.. the SMS provider told me they can only provide SMPP connectivity and they sent me: IP Address Port Source TON Source NPI Dest TON Dest NPI what can i do next Usually a webservice is provided by such gateway's/companies which you implement in your application. Read the documentation for details from the provider. Everything will be there as .NET itself does not have functionality to send sms's from itself - there are no classes to do this I believe so its all down to the vendor in providing you the resources. Some providers also may use Emails as a way of sendi ...Show All

• SQL Server Create Table from Row Data

  Hello, In SQL Server 2000, is it possible to take a table with one field (column), and pivot the table so that the characters in the row data become the field (column) names of another table ( or in a View) The number of records could vary. If so, how would I do this Sample table; Create Table dbo.MonthlyData ( Categories varchar(30) NOT NULL ) Sample data; Sales Volume 2005-02 TotRefVol 2005-02 Sales Ratio 2005-02 Sales Volume 2005-03 TotRefVol 2005-03 Sales Ratio 2005-03 Sales Volume 2005-04 TotRefVol 2005-04 Sales Ratio 2005-04 Thanks again. I had a couple of questions; -Procedure sp_executesql expects parameter '@statement' of type 'ntext/nchar/nvarchar'; nvarchar has a 'size' limit ...Show All

• SharePoint Products and Technologies Why need Form Server 2007? Thought WSS/MOSS covers that kind of funcationalities

  This is probably not the ideal place to ask this question but I'm just not sure what Form Server 2007 is for. I admit that I have not spent any significant amount of time looking into it. My very limited knowledge about it says it's built on top of WSS 3.0. I'm not sure what that means. I guess I'm trying to find out what "additional" functionalities Form Server provides that the OOB WSS/MOSS don't already provide, and the compelling reasons why it's useful in the business world. Form server is basically a MOSS component (for the enterprise MOSS version) that allows you to publish infopath forms so that users will be able to view them as web forms instead of installing the infopath client. Its ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. download DirectX 7.0 sdk

  Is still possible to download directx 7.0 SDK Where can i download it Yeah I had a wiki bookmarked a long time ago that had nearly every directx SDK archived, but I've rebuilt my system since then and will need to find it again. heh. ...Show All

• SQL Server Reusability & SSIS - issues they do not write in books about

  I have a simple requirement: Each package needs to have Error Handling - which needs to Execute a SQL statement. It's the same Stored Proc - where each package passes in its ID. Ok - I get that part about creating a custom task and so on for reusabilty. But - lets say that after deploying this task in 20 packages - I need to change the name of the Stored Proc. What is going to happen in that case Correct me if I'm wrong - but after deploying the new version of the custom task - do I need to go to each package and update the reference to new version TheViewMaster wrote: Not quite - configuration cannot handle when the processing logic changes. Lets say for instance in addition to ID input of the Stored Proc - the Custom task / ...Show All

• Microsoft ISV Community Center Forums RunTime Error '2001' - FIX!

  Hi, I am getting " runtime error '2001' you cancelled the previous operation " in my VBA code for MS Access. The database is saved on the server and linked to a table of another database which is also on the server and used by many users. But when i put everything locally then i wont get this error. Pls help! Thanks in advance Cheers Rohit Hi HMote In what application are you working What does "ME" represent I get the impression this may be an Access database form Are you certain "Me" has a bookmark property If it does, then you probably need Set Me.Bookmark = rs.Bookmark -- Cindy (Word MVP) ...Show All

• Visual Basic Windows Form KeyDown Issue

  With this code: Private Sub Form1_KeyDown( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me .KeyDown Select Case e.KeyCode Case Keys.F9 Button1.BackColor = Color.Azure Case Keys.F10 Button1.BackColor = Color.Magenta End Select End Sub one would expect pressing F9 to set the background color to Azure and pressing F10 to set the backgroung color to Magenta, which does happen. However, after pressing F10, F9 does not work. Pressing F9, F10, F9, F10, F9, F10 should toggle the background color, but it doesn't. This key combination will toggle the background color: F9, F10, F10, F9, F10, F10, F9, etc. Why does F9 not trigger the KeyDown event afte ...Show All

• SQL Server About the visual of SQL Server Reporting Services

  Hi, I would like to know if it is possible to change the appearance of SQL Server Reporting Services that we see when we are navigating in the reports by the browser. Like change the name "SQL Server Reporting Services" to the name of my company, change the default icon and the size of it, etc... Thanks for the attention, Gus ...Show All

• Visual C# How do I transfer data to an Excel file

  Happy New Year to all our readers! Hi everyone, I have a need to write data to an Excel file. I found a KB file, 306023, which gives a lot of information and an example that works. I now want to add some of this code to a DLL that I am building. However, having added all the recommended References, I still get errors. Typically, public Excel .Application m_objExcel = null ; gives an error: 1 The type name 'Application' does not exist in the type 'AnnsonDll.Excel' . I don't understand why I get the error here, but not in the example code. I have searched the web, but I can find no useful information on any of this. The KB file refers to using Excel = Microsoft.Office.Interop.Excel; but this isn't recog ...Show All