Asp.Net and C sharp: File Upload , Display in Gridview, and finally bulk insert into Database

TRICK 1 -->

---------------------------Excel-----------

--------------------------------------------------------------
SQL

-----ASPX--
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication4._Default" %>

<!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>
<title>Read and Display Data From an Excel File (.xsl or .xlsx) in ASP.NET</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<b>Please Select Excel File: </b>
<asp:FileUpload ID="fileuploadExcel" runat="server" />  
<asp:Button ID="btnImport" runat="server" Text="Import Data" OnClick="btnImport_Click" />
<asp:Button ID="btnsql" runat="server" Text="Bulk Insert"
OnClick="btn_import_sql" />
<br />
<asp:Label ID="lblMessage" runat="server" Visible="False" Font-Bold="True" ForeColor="#009933"></asp:Label>
<br />
<asp:Label ID="Label1" runat="server" Visible="true" Font-Bold="True" ForeColor="#009933"></asp:Label>
<asp:GridView ID="grvExcelData" runat="server">
<HeaderStyle BackColor="#df5015" Font-Bold="true" ForeColor="White" />
</asp:GridView>
</div>
</form>
</body>
</html>

------------.CS-----------

using System;

using System.Data;

using System.Data.OleDb;

using System.IO;

using System.Data.SqlClient;

using System.Configuration;

using System.Text;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

namespace WebApplication4

{

public partial class _Default : System.Web.UI.Page

{

string str;

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnImport_Click(object sender, EventArgs e)

{

string connString = "";

string strFileType = Path.GetExtension(fileuploadExcel.FileName).ToLower();

string path = fileuploadExcel.PostedFile.FileName;

//Connection String to Excel Workbook

if (strFileType.Trim() == ".xls")

{

connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";

}

else if (strFileType.Trim() == ".xlsx")

{

connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";

}

string query = "SELECT ltrim(rtrim([userid])),[starttime],[endtime] FROM [Sheet1$]";

OleDbConnection conn = new OleDbConnection(connString);

if (conn.State == ConnectionState.Closed)

conn.Open();

OleDbCommand cmd = new OleDbCommand(query, conn);

OleDbDataAdapter da = new OleDbDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

grvExcelData.DataSource = ds.Tables[0];

grvExcelData.DataBind();

da.Dispose();

conn.Close();

conn.Dispose();

}

protected void btn_import_sql(object sender, EventArgs e)

{

string strcon = ConfigurationManager.ConnectionStrings["ConnectionStringdb"].ConnectionString;

using (SqlConnection con = new SqlConnection(strcon))

{

for (int i = 0; i < grvExcelData.Rows.Count; i++)

{

GridViewRow row = grvExcelData.Rows[i];

con.Open();

str= "insert into temp_adhoc_arihant2(userid,starttime,endtime)values('"+ row.Cells[0].Text +"','"+ row.Cells[1].Text +"','"+ row.Cells[2].Text +"')";

SqlCommand com = new SqlCommand(str, con);

com.ExecuteNonQuery();

con.Close();

}

Label1.Text = "Records successfully inserted";

}