On: 02/04/2014



CSV file contains multiple values which are separated by commas (,). In order to parse CSV file, we need to write some code. TextFieldParser class in the Microsoft.VisualBasic.FileIO namespace is used to parse CSV files. TextFieldParser reads in CSV files. With it, we specify a delimiter string, and then can read in the fields of every line in a loop. While parsing CSV file, it doesn’t fetch header row and data rows separately. We need to write some code to fetch first row as a header and remaining as data rows.
On: 26/09/2013



In this article I’m going to explain how to import records from HTML and store to database. I got one requirement that I’ve to import records from simple HTML table and store those records to the database. It’s not complicated one but we should know about that whether that HTML page is well formatted. Here we need to make sure that how we can get content from simple HTML table. So only possibility is we have to download HTML string and extract Table content. table tag contains tr and td tags but it may have style properties.
On: 14/09/2013



In this article I’m going to explain how to import records from excel sheet to SQL Server with validations in ASP.NET using C#. I have already written an article for imports records from excel sheet to SQL Server. Import records from excel sheet to SQL Server using ASP.NET and C#. Here I’ll show you how to do validations in Excel sheet while importing records.
On: 13/07/2013



In this article I’m going to explain how to import records from excel sheet to SQL Server using ASP.NET and C#. I got a requirement that I should import records from excel sheet to SQL Server. To achieve that I have created demo and you could follow the steps given below.
Subscribe via Email
    
message to display in fancybox