namso's Q&A profile

• SQL Server Importing a comma delimited file

  Hello... I have a problem... When I insert data from a comma delimited file using this mehod a flat file connection sorting, merge join and inserting into the database I get "" around all the data!! The quotes end up around the column names and everything! I had to go in and manually remove the quotes in the text file to get some of my data conversions to work. I know there is a better way. How do I get SSIS to load the data without the quotes This is an example of the data in the file: "1007","1","A","","Congratulations - No Health Violations Found","11/02/200 ...Show All

• .NET Development Whooops! Another unhandled exception!

  I've got both SQL 2000 and SQL Excess, er, Express on my PC doing C# Pro development. If I try to Add Connection to get a data source, I can select an Express database MDF file, and operate on the data OK, but cannot select the Express server - it does NOT appear in the server list. I added the server SQLSERVER.EXE to the Windows firewall 'Exceptions' list, along with Vis Studio - no change. I CAN select the SQL 2000 server OK. I can get into and use the Express Management tool OK. Properties for the Express server are Network connection (versus Local Service and Local System, both of which don't work), network connections a ...Show All

• Visual Studio 2008 (Pre-release) IDE Support Installer CLR error: 80004005

  Trying to run the Linq IDE support installer I am receiving the following error: CLR error: 80004005.  The program will now terminate. I have previously installed:   VS2005 TS for Developers (RTM) installed with SQLServer 2005 Express.   Visual Studio 2003 The installer is not set to run in Windows 95 compat. mode. Thanks for any help. I ran it from the included batch file.  I was able to get it running by using the repair option on the visual studio 2005 disc and then attempting the installation again. ...Show All

• Windows Forms File association

  Hi, I programmed an Editor and need a file association... I want that when I click a .txt or .rtf my Editor opens up... ...if there's any sample or you know how to...please post :-) MSDN information on creating file associations: http://msdn.microsoft.com/library/default.asp url=/library/en-us/shellcc/platform/shell/programmersguide/shell_basics/shell_basics_extending/fileassociations/fa_sample_scenarios.asp I hope this also&nb ...Show All

• SQL Server Are dynamic stored procedures possible?

  Please excuse my ignorance but I'm new to T-SQL and am having a problem.  I have a proc that I want to send three parameters too, but only have it search on the paramters if they are valid (above 0).  In the following example I am filtering on County, Town and Type.  But only want to filter if the value of the parameter is included.  So if they only pass in county, then thats all I want to filter on. Any ideas CREATE PROCEDURE FeatureBusinessByTown @County int, @Town int, @Type int AS Select Top 5 BusinessID FROM SELECT TOP 5 fbisBusinessLookup.BusinessID FROM fbisBusinessLookup INNER JOIN DIRECTORY ON fbisBusinessLookup ...Show All

• Windows Forms DataSet Merge to automatically do AcceptChanges

  Hi Guys, I am trying to use the DataSet.Merge method. Here is what I want. I want to merge two datasets. Basically one dataset would be a result from my webservice and it will contain the same rows with ids generated from the server.  I have local dataset (ds) in my client and the one i want to merge is dsw then i do this ds.Merge(dsw) I ...Show All

• .NET Development return scalar value from table adapter

  I have the following code that gets a scalar value from a data table: DataSetTableAdapters. myudfTableAdapter myScalarTableAdapter; myScalarTableAdapter= new DataSetTableAdapters. myudfTableAdapter (); decimal amount_needed = ( decimal )myScalarTableAdapter.amountNeededScalarQuery(requestID); return amount_needed; When I run this I get an invalid cast exception. When I hold my cursor over the amountNeededScalarQuery value in code view, I see the following in the tool tip: (int ) myudfTableAdapter. amountNeededScalarQuery I am using similar code elsewhere without a problem. When I check the tooltip for th ...Show All

• Windows Forms MenuStrip error with RenderMode=System in Windows 2000

  Hi, I've got a problem with the MenuStrip control, using .NET 2.0, it is set to use the RenderMode=System, as this produces a result similar to other legacy parts of our application. The problem however is that when the RenderMode property is set to System and the application is run on Windows 2000 (with SP4) the menu shows up as all black and the various menus can't be seen. (Instead of the normal gray with black menu titles.) If I change RenderMode to use one of the other settings, it works without any problems. (All modes works on Windows XP.) I have repeated this with a small dummy application that only contains a MenuStrip w ...Show All

• Windows Forms User Control (text box), Null values, Formatting

  I am trying to create a textbox control which will handle null values (see 1 below) and  retain the ability to be formatted using Binding.Format (see 2 and 3 below). My User Control is in Number 1 below. When I use the 'Shadows Property Text' function, I loose formatting on the control.   The call to format is just ignored. I tried  ...Show All

• .NET Development Forum Engine Availability

  Hi, May I add my congratulations to the forums engine.  It's superb. We used an older version of the forums engine on one of our websites at: http://www.learn247.net/community/default.aspx Is the new forum engine going to be generally available to us and other community sites too Best wishes. Graham. From memory this forum is a heavily moderfied version of Community Server 1.1 bordering on 1.2, you might want to check it out at http://communityserver.org . ...Show All

• Visual Studio Express Editions Numeric Problem

  Hello, I am currently writing a gemetric multigrid solver as an exercise at univeristy. Until now i have developed the solver with gcc. But I want to port this project to Visual C++ 2005 Express. My Problem is that exacty the same code compiled with gcc give me the right results. But if i compile it with Visual C++ the program runs but do not give me the right results. The solving process is iterative so the defect is getting smaler with every iteration. Here is a comparision between VC and gcc: Visual Studio 2005 Express:                     gcc: Iteration  &nbs ...Show All

• Visual C++ Problem with TreeView Imagelist

  Hello, I've been working on an application recently which uses a treeview control with an imagelist. My problem is I want to set the imageindexes alone and make them not change to the index 0 when they are selected. Is this possible I'll give a more specific example: I have three images: 1. Apple - Index 0                                2. Pair - Index 1                                3. Orange - Index 2 I made it so when the nodes a ...Show All

• Visual FoxPro How to change Default FONTS in Forms, Menus, status bar, title bar and so on...??

  Hi, Could somebody tell me, how to change default fonts of Menus, Status bar, titke bar and so on... Right now I can see everything in Arial but I need to use different font. Thanks If changing the Windows settings isn't an option, you have to spend a lot of time on replacing these parts. There basically two paths that I can see. 1) On the API route you can either create Windows yourself, or use BINDEVENTS() to hook into an existing VFP form. In both cases you need to implement all the messages that deal with drawing the borders. Use GDI+ for displaying the text. 2) Create them as VFP controls. Make your form borderless without a tit ...Show All

• Windows Forms Copy and Past Excel spreadsheet

  I want to create a Windows Forms application that can be used to copy a spreadsheet from MS Excel and paste the contents into the winform.  I also then need to be able to add and remove rows and columsn. I am relatively new to .Net and Windows Forms programming so please forgive if the question is pretty basic! Regards, Wallace You need to develop and Excel Interop. and connect to the Excel spreadsheet in code.  Excel.Worksheet.Range( A1,AX) should give you the value of the rows covered.  You can then take that object and dump it in a grid or whatever.   ...Show All

• Windows Search Technologies WDS and Outlook 2000 crashing on exit issue - open for discussion?

  I read through the previous thread and really didn't get the sense that this issue is being addressed or acknowledged. So, here's my own experience on it: It seems even with the new build of WDS (03/08/06), I too still have the Outlook 2000 crashing on exit problem. I'm running Win2K SP4, Office 2000 SP3 and all updates from Microsoft Update for both the OS and Office. The Pc is a 1.5Ghz P4, 1GB RAM, 80GB HD, etc. The hardware is more than sufficient. I recent formatted my hard drive and reinstalled clean the OS, Office, all updates, and WDS. I have not restored my backup of my PST for Outlook; I have left it as a new install. Therefor ...Show All