I have this code to import excel data to an SQL table by uploading the excel document using the FileUpload control in asp.net.
Here is the code...
CS.aspx
<%@ Page Language="C#" AutoEventWireup="true" Inherits="CS" Codebehind="CS.aspx.cs" %>
<!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">
<asp:FileUpload ID="fle_upld_excel" runat="server" />
<asp:Button Text="Upload" OnClick = "Upload" runat="server" />
</form>
</body>
</html>
CS.aspx.cs
Go to the complete details ...