In this blog we will know how to Insert records into excel through text boxes.
In this blog we will know how to Insert records into excel through text boxes.
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
namespace Insert_data_into_excel_asp
{
public partial class _Default : System.Web.UI.Page
{
OleDbConnection con;
OleDbCommand com;
string str;
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
com = new OleDbCommand();
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='c:\\file\\test.xlsx';Extended Properties=Excel 8.0;");
con.Open();
com.Connection = con;
str = "Insert into [Sheet1$] (EID,EName,Designation) values('" + txt_id.Text + "','" + txt_name.Text + "','" + txt_designation.Text + "')";
com.CommandText = str;
com.ExecuteNonQuery();
con.Close();
Response.Write("Records inserted successfully");
clear();
}
catch (Exception ex)
{
ex.ToString();
}
}
private void clear()
{
txt_id.Text = "";
txt_name.Text = "";
txt_designation.Text = "";
}
}
}