Recent Solutions

Export DataTable to Excel .CSV using C#.Net {How easy is this}

Wed, 13 Jul 2011 12:00:00 +0000

Export DataTable to Excel/CSV using C#

I was working on a project and my client asked me to export data to excel or .csv file. do you know how easy is this, Just by using StreamWriter I exported a DataTable to excel .csv file.

and here is the code

for this article I used Northwind database and Employees table from MS SQL server.

...

Insert, Update and Delete records in table with datagridview using C#.net

Sat, 09 Jul 2011 11:29:00 +0000

Insert, Update & Delete Table from DataGridView in C#.Net

Details:
Topic: Insert, Update & Delete Table from DataGridView
Language: C#.Net 2.0
Level: Intermediate

Today I will show you how to Insert, Update & Delete table with DataGridView in C#.Net.

Create a database EmployeesDB and create a table Employees

...

Load Excel File to Data Table using C Sharp.Net

Tue, 05 Jul 2011 09:33:00 +0000

I saw in forums everyone is asking how to load data from excel file to database.

I made a simple function to load excel data into DataTable, once you loaded data to DataTable you can move it to any database you want.

this function required excel file path to load data and you can modify excel sheet name if it is not matching with the code.

...