Scribd
Upload
4 views2 pages

Save Excel Data To SQL Server

The document outlines a C# code snippet for uploading an Excel file to a SQL Server database. It includes a button click event that reads data from the Excel file and saves it into a 'studentdetail' table using a user-defined function. The code utilizes namespaces for data handling and database connectivity, specifically with OleDb and SqlClient.

Uploaded by

dp987032
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4 views2 pages

Save Excel Data To SQL Server

The document outlines a C# code snippet for uploading an Excel file to a SQL Server database. It includes a button click event that reads data from the Excel file and saves it into a 'studentdetail' table using a user-defined function. The code utilizes namespaces for data handling and database connectivity, specifically with OleDb and SqlClient.

Uploaded by

dp987032
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

Important NameSpaces Used

--------------------------

using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Data.OleDb;

---------------------------

Upload / Save To SQL Server Button Click Event Coding


-------------------------------------------------------

int rollno;
String sname;
String fname;
String mname;
string path = Path.GetFileName(FileUpload1.FileName);
path = path.Replace(" ", "");
FileUpload1.SaveAs(Server.MapPath("~/ExcelFile/") + path);
String ExcelPath = Server.MapPath("~/ExcelFile/") + path;
OleDbConnection mycon = new OleDbConnection("Provider =
Microsoft.ACE.OLEDB.12.0; Data Source = " + ExcelPath + "; Extended
Properties=Excel 8.0; Persist Security Info = False");
mycon.Open();
OleDbCommand cmd = new OleDbCommand("select * from [Sheet1$]", mycon);
OleDbDataReader dr = cmd.ExecuteReader();
while(dr.Read())
{
// Response.Write("<br/>"+dr[0].ToString());
rollno = Convert.ToInt32(dr[0].ToString());
sname = dr[1].ToString();
fname = dr[2].ToString();
mname = dr[3].ToString();
savedata(rollno, sname, fname, mname);

}
Label3.Text = "Data Has Been Saved Successfully";

---------------------------------------------------------

UserDefined Function Coding ( SaveData )


-----------------------------------------

private void savedata(int rollno1,String sname1,String fname1,String mname1)


{
String query = "insert into
studentdetail(rollno,sname,fathername,mothername) values(" + rollno1 + ",'" +
sname1 + "','" + fname1 + "','" + mname1 + "')";
String mycon = "Data Source=HP-PC\\SQLEXPRESS; Initial
Catalog=ExcelDatabase; Integrated Security=true";
SqlConnection con = new SqlConnection(mycon);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = con;
cmd.ExecuteNonQuery();
}

You might also like