In this article i am going
to explain how to import records from excel sheet to DataTable Using C# dot net.
Design code:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default1.aspx.cs"
Inherits="CSV" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:FileUpload ID="lImport" runat="server" />
<asp:Button ID="btnImport" runat="server" Text="Import" OnClick="btnImport_Click"/>
</div> </form></body></html>
We have to use the following
namespaces.
using System;
using
System.Data;
using
System.Data.OleDb;
C# Code
protected void btnIpload_Click(object
sender, EventArgs e)
{
ImportExcelToDatatable();
}
void ImportExcelToDatatable()
{
try
{
if
(lImport.HasFile)
{
string
FileName = lImport.FileName;
string
path = string.Concat(Server.MapPath("~/Document/" + lImport.FileName));
OleDbConnection
OleDbcon = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=" + path + ";Extended
Properties=Excel 12.0;");
OleDbCommand
command = new OleDbCommand("SELECT * FROM [Employee$]", OleDbcon);
OleDbDataAdapter
objAdapter1 = new OleDbDataAdapter(command);
OleDbcon.Open();
OleDbDataAdapter
da = new OleDbDataAdapter(command);
DataSet
ds = new DataSet();
da.Fill(ds);
DataTable
dt = ds.Tables[0];
}
}
catch (Exception ex)
{
}
}
No comments:
Post a Comment