Insert records into excel using textboxes

Satyapriyanayak
Posted by Satyapriyanayak under ASP.NET category on | Points: 40 | Views : 1018
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 = "";

}



}

}

Comments or Responses

Posted by: Karthikreddy on: 3/8/2013 Level:Starter | Status: [Member] | Points: 10
please post the code for ms sql db !!

Login to post response