store data in excel to sql server database

See more:

ASP.NET

I am created a project.
I used a label, fileupload, gridview and button in it.

This is the code in button click event :

SqlConnection con = new SqlConnection(/*connection string*/);
       FileUpload1.SaveAs(Server.MapPath("~//App_Data//") + FileUpload1.FileName);
       string path = Server.MapPath("~//App_Data//") + FileUpload1.FileName;
       try
       {
           //for .xls file
           System.Data.OleDb.OleDbConnection MyConnection;
           DataSet DtSet;
           System.Data.OleDb.OleDbDataAdapter MyCommand;
           MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; Data Source='" + path + "';Extended Properties=Excel 8.0;");
           MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection);
           DtSet = new System.Data.DataSet();
           MyCommand.Fill(DtSet, "[Sheet1$]");
           MyConnection.Close();
           GridView1.DataSource = DtSet.Tables[0];
           GridView1.DataBind();

           SqlDataAdapter adpter = new SqlDataAdapter("Select * from StudentList", con);
           adpter.Update(DtSet.Tables[0]);
           Response.Write("successfully Imported values to SQL Server");

       }
       catch (Exception ex)
       {
           Response.Write(ex.Message);
       }

The above code executes successfully. It retrieves data from excel and displays in GridView but DataSet table row does not get saved in table created in Sql Server.

I want to use disconnected mode.

[Edit - Henry]
Changed backslashes to slashes in the MapPath lines so that the code colourizer could cope.
[/Edit]