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 C#.net

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

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.

...
- - - - -

Create page break or readmore with PHP

Icon 0 Comments
Create page break or readmore tag with php

Hi guys,
Sometimes you need to show a few lines in your index page from one or more than one pages like About Us, Vision & Mission...
- - - - -

PHP: Highlight and search words in page

Icon 0 Comments
Highlight and search words in page...
  • (4 Pages)
  • +
  • 1
  • 2
  • 3
  • Last »

Search My Blog

0 user(s) viewing

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