Subscribe to Recent Solutions        RSS Feed
- - - - -

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

Icon 2 Comments
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

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

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

Icon Leave Comment
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.

Page 1 of 1

Search My Blog

0 user(s) viewing

0 Guests
0 member(s)
0 anonymous member(s)