bulk insert loads my data, but my code crashes when trying to read or compare a text value

The issue was we would do a regular export from SQL Server of a table with an ID field and a varchar field. The export went fine. Then we did an import using bulk insert... the rowterminator was \n. Everything loaded fine. The issue arose when we ran code that compared values in the text field. The result caused a crash because it couldn't return an exact match.

The end result was we changed the rowterminator to another character. For some reason, we were getting phantom characters in the text field. We couldn't see them in the database or in the code. But, if we went into the database and retyped the value, it worked.

Best

error occurred while validating. HRESULT = '8000000A'

I resolved this issue by doing the following:

1. Checked out the project in Teamsite so it could write the new files
2. Restarted my computer. I had seen that somewhere before
3. Right click on Detected Dependencies and refreshed them.
4. Rebuilt the project.

Until I restarted I couldn't refresh the dependencies, there was always an error.

Incorrect Shp File Format using DevExpress

So, I thought I had everything working. Then I received the message "Incorrect Shp file Format" presented as an error when trying to run in debug mode for Visual Studio 2010. The error occurred in the Designer.cs file.

Part of the issue is that I'm trying to take an existing shp file and split it up into multiple shp files. Note, the original shp file with all of the points does work. But, when I try to pull specific locations out, I receive the error. I'm using Quantum GIS to do this.

Ground zero. Just to test, I decided to select all of the same data points in the original file. Click on save selection as and create a new set of shp files. When I reference this group of files in the project, I receive a "Property value is not valid." and ""Disagree dbf file" error messages. So, logically, I thought I should update the dbf file to match.

Had to shift topics, but have not been able to resolve this issue.

Need help choosing a datacenter?

Data centers needs have become one of the largest growing needs in the country. Think about it, there is more and more data every day. Each time you post an image or message online, thousands of others are doing the same thing. What if you were looking to purchase a datacenter or need data center help? Where would you go? There are realtors all over the world that would say they could help you. But, can they really help?

At DatacenterHelp.com there are knowledgeable professionals ready to help. There isn't any cost to you. They are paid by the data centers themselves to gain business. If you're looking to choose a data center, look no further.

The type name 'DateTime' does not exist in the type 'MyProject.Models.System' - Visual Studio 2010

Ended up replacing instances of System.DateTime with DateTime and System.Guid with Guid

Visual Studio 2010 Save a text file as a bat or cmd file without errors

Repost from...http://stackoverflow.com/questions/854360/visual-studio-inserts-invalid-characters-in-batch-files

Error Message:

C:\>
'' is not recognized as an internal or external command,
operable program or batch file.
Creating tables on server (LOCAL) and database PLEDGES
Done creating tables.

Quick Solution

In VS2008 and VS2010, select your file in the solution explorer and choose File...Save myfile.bat As...
On the down arrow on the Save button, choose Save with Encoding.
When saving in the Advanced Save Options dialog, Choose US-ASCII in the Encoding drop-down list. Set the line endings as required, or leave it as Current Setting.

Windows Services for constant Database Updates

Research on Windows Services.
What is a Windows Service: http://msdn.microsoft.com/en-us/library/d56de412(v=vs.80).aspx

Create a service using: http://msdn.microsoft.com/en-us/library/zt39148a.aspx

The installer service file properties will define the name and description of the service. Whatever you put in here as the name will appear in Windows Services.

Command line arguments to get everything running:

******
How to install this service
******
installutil.exe xyz.exe

******
How to uninstall this service
******
installutil.exe /u xyz.exe

******
How to Start the Service
******
net start "xyz"

******
How to Stop the Service
******
net stop "xyz"

******
To verify service is running
******
1. Go to Command line: cmd.exe
2. Type in: services.msc
3. Look for "xyz"

******
How to see what's happened with the service
******
1. Go to Event Viewer and view messages: eventvwr
2. Windows Logs | System

Post-build Event Command Line Visual Studio

So, I'm working with the post-build event command line in Visual Studio. Specifically, I want to move all of my newly compiled dlls to another directory due to testing a plugin. The end result is that everything worked. But, I had to go back into the DOS world. Enough of the chat... here's my line

copy "C:\TFS\postbuildevent\bin\Debug\*.*" "C:\newdirectory\" /Y

Why the quotes? Visual Studio needs the quotes around the longer directory names and those with spaces. If you don't use the quotes, you will get a file not found error. Also, I wanted to avoid the prompt for copying files, therefore, I used the /Y flag at the end.

If you want to test beforehand, open the command window... cmd.exe.