.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Parsing flat files or tab delimited files.csv with Visual Studio and or Biz Talk Server.

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
Hello msdn community, I need help with finding the proper Microsoft application that will allow me to parse a .csv  flat file / tab delimited file for its text, The data will be queried client side dynamically populated to my web page form with Visual Studio 2008.  I have read that a MS Biztalk Server will perform a similar function, I am still checking on this. Has anyone in the community had experience with flat file parsing with Microsoft software and or hardware? Any and all help will be appreciated in helping me resolve this issue because I am not well versed with the Microsoft products. Spidaweb Web Designer /Webmaster Virtual Web Dev, LLC.

View Complete Post

More Related Resource Links

Toolbox: Easy File Backup, Exploring Files And Folders Inside Visual Studio, Multiple Monitor Softwa


If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.

Scott Mitchell

MSDN Magazine May 2009

C#: XML Comments Let You Build Documentation Directly From Your Visual Studio .NET Source Files


C# allows developers to embed XML comments into their source files-a useful facility, especially when more than one programmer is working on the same code. The C# parser can expand these XML tags to provide additional information and export them to an external document for further processing. This article shows how to use XML comments and explains the relevant tags. The author demonstrates how to set up your project to export your XML comments into convenient documentation for the benefit of other developers. He also shows how to use comments to generate help files.

J. Andrew Schafer

MSDN Magazine June 2002

Visual Studio 2010 Creates Two Solution Files


When I create a new file system based web application in Visual Studio 2010, for example, named as "MyWebSite", two folders were created by the studio: MyWebSite and MyWebSite(2). The second folder only contains a solution file while the first folder has the solution file as well. Is this a new feature? Where is the setting that can avoid the second folder? Thanks,

SQL Server Management Studio cannot save new files to SharePoint folders

If the file already exists I can save changes to the file. But I cannot save new scipt files to a SharePoint 2007 drive.

SQL Server Management Studio cannot save new files to SharePoint folders

If the file already exists I can save changes to the file. But I cannot save new scipt files to a SharePoint 2007 drive.

set up database with .bak files in SAL server management studio



I need to connect to 3 remote databases from my local machine and  restore 3 .bak files, one for each database.

I am new to asp and sql server and am finding SQL Server Management studio quite confusing.  I cannot find any options to connect remotely or restore a database from .bak.

Many thanks

Visual Studio 2005 can't find my files in subfolders, why?!


I am having a heck of a time with this.  Visual Studio 2005 SP1 can not find my files and javascript files whenever I put it in the subfolders.  In the solution explorer, I've created subolfders such as /js and /css.  This is inside my main folder:  AJAXEnabledWebApplication1\css  and AJAXEnabledWebApplication1\js

In HTML code, when I put this: <script type="text/javascript" src="js/jquery-1.4.2.js"></script>
    <script type="text/javascript" src="ui/jquery.ui.core.js"></script>
    <script type="text/javascript" src="ui/jquery.ui.widget.js"></script>
    <script type="text/javascript" src="ui/jquery.ui.mouse.js"></script>
    <script type="text/javascript" src="ui/jquery.ui.selectable.js"></script>

every single one of them is highlighted that it can not find the specified file.  But wait, if I add those files manually to the root folder and to the solution explorer, it is no problem!!?? why?!?

why is this happening?

inside the reference paths for the program, I've also pointed to the root folder location:

c:\document adn settings\myname\my Docum

The reading of visual fox pro files (.dbf) does not work if the server has more that 1 GB of RAM

I am reading .dbf files using openrowset instructions, but it does not work if the files are bigger that 250MB. I been looking a lot for information and doing tests. At the end I tested with all my development enviroment mounted in a virtual machine and I discovered something really rare. If the RAM assigned to de virtual machine is 1 GB, the openrowset query works fine, no matter how big is the .dbf file(I tested with 1.5 GB files and it works fine). So my question is if somebody knows if is necesary some special configurations in SQL Server 2005 for to work in a server with 4 processors and 4 GB of RAM. The error message that appears when the server memory exceeds 1 GB is the next:

Msg 7399, Level 16, State 1, Line 1
El proveedor OLE DB "MSDASQL" para el servidor vinculado "(null)" informó de un error. El proveedor no proporcionó información acerca del error.
Msg 7320, Level 16, State 2, Line 1
No se puede ejecutar la consulta "SELECT d2,d3,d4,d5,d6,d7,d8,d9,d10,d10_2,d11,d12,d17,d18,d18_2,d18_3,d23,d13 FROM tadat_gigante.dbf" en el proveedor OLE DB "MSDASQL" para el servidor vinculado "(null)".

the query is the next:

    'Driver=Microsoft Visual FoxPro Driver; SourceDB=c:\; So

Visual Studio 2010 crashes when opening XAML files


I'm having a problem opening XAML files in Visual Studio 2010.  When I open a XAML file, Visual Studio become very slow and the XAML file never produces an outline or a rendered version of the XAML.  When I click in the text of the XAML, it can take several minutes for the cursor to appear where I clicked.  The XAML file is rather small - just a grid with some basic controls on it (a grid, stack panel, radio buttons, date pickers, etc).  The problem occurs if I open any XAML file in the project, though.

When I watch devenv.exe in the task manager, as soon as I open a XAML file, the process is consuming 100% of one of the CPUs and begins eating chunks of memory at the rate of about 5MB/second and creating a new thread about every two seconds.    The memory use grows until it's about 700MB and the number of threads climbs to between 450-470 before it levels off.  Even after it stops producing new threads and consuming more memory, the XAML file is still unresponsive and it's still using 100% of one of the CPUs.  Even after a half hour, the CPU is still at 100% with 452 threads.

I have completely uninstalled and reinstalled Visual Studio but I'm still having the same problem.

I'm running XP sp3 32-bit with VS 2010 Ultimate on a dual core machine with 4GB RAM.  At this point I simply can't edit XAML

dynamically adding sql server columns based on number of files in fileuploader


I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.


I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!


Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")


connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.


I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

HttpHandler works with Visual Studio Development Server debugging, but not otherwise


Hi all,

I'm new to HttpHandlers.  I am writing an HttpHandler that reads uploaded files directly from the request stream to provide progress that can be queried using an AJAX request.  For large files, this seems to be faster than having ASP.NET load the file contents into Request.Files and then streaming the file from there to wherever it goes (Linq to SQL into a VARBINARY column in an SQL Server database.)

My HttpHandler works perfectly when I'm debugging using the Visual Studio Development Server, but doesn't work otherwise.  The application pool for this application in IIS 7 is set to run in Classic Mode, and the Handler Mappings screen in IIS says that I must manage managed handlers in system.web/httpHandlers. 

I set up in my applications Web.config file.

<add verb="GET,POST" path="*.upload" type="Namespace.For.UploadHandler, AssemblyForUploadHandler"/>

It works great, so long as I don't debug with the "Use Local IIS Web server" option.

What else do I need to do to get this to work?


Use The Source, Luke: Source Server Helps You Kill Bugs Dead In Visual Studio 2005


The latest releases of WinDBG and Visual Studio know exactly how to use source server, so its benefits are available to both .NET and native C++ developers. See why this is so important in tracking down bugs.

John Robbins

MSDN Magazine August 2006

ATL Server and Visual Studio .NET: Developing High-Performance Web Applications Gets Easier


When developing high-performance applications for the Web, developers often must choose between performance and ease of development. With ATL Server, new with Visual Studio .NET, developers get the best of both worlds. ATL Server uses a tag replacement engine written in C++, provides a simple programming model, and promotes enhanced performance and easy debugging. This article presents an overview of the ATL Server architecture, then creates a basic ATL Server project. It then goes on to explain processing SRF files, HTTP streams, forms, cookies, and header files. Managing session state is also discussed, along with file uploads and performance monitoring.

Shaun McAravey and Ben Hickman

MSDN Magazine October 2000

Copying files to a folder on web server



I have few files in FolderA on the web server.

I want the users to select a fews files from FolderA and copy them to FolderB on the same web server.

I want to list all the files in FolderA and allow the user to select a few files and copy.

I want to copy the files programatically when the user selects a few files and click on Copy button.

How to copy the files quickly from folderA to FolderB?




how to upload files (5MB-50MB) into sql server 2008 by using filestream

Hi!i have some files, and i need to upload these files into sql server 2008 by using filestream.lets take table name as custfiles,              columns are fileid,filename,filepath,filesize.1.how to create table using filestream?2.how to insert file (record) into table from .net environment?3.how to retrive that file from .net environment?please provide related code....THANS FOR ANY HELP
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend