Subscribe to Recent Solutions        RSS Feed
- - - - -

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

13 July 2011
Icon 2 Comments
Tags: C#, .Net, Exce, CSV
Posted by noorahmad  Icon
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.
...

Categories: Uncategorized

Read Full Entry →

- - - - -

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

09 July 2011
Icon Leave Comment
Tags: DataGridView, .Net, C#
Posted by noorahmad  Icon
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
...

Categories: Uncategorized

Read Full Entry →

- - - - -

Load Excel File to Data Table using C Sharp.Net

05 July 2011
Icon Leave Comment
Tags: C#, .Net, Excel
Posted by noorahmad  Icon
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.

...

Categories: Uncategorized

Read Full Entry →

Back to blog home →
Page 1 of 1

Search My Blog

0 user(s) viewing

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