Insert Data From Excel To SQL Server On Button Click

Also here you can find a code sample that shows how to iterate through all cells in all rows and retrieve their values.

below link you can get


 http://sqlneed.blogspot.com/2013/06/Import-Data-from-Excel-to-SQL-C-sharp.html

I got an error saying -

The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.

Hi...

I implemented your method.

But, only first row got inserted.

Please provide the sample code if you have...

Thanks a lot in advance...

Please provide it as soon as possible, it is urgent..

Hi Abhishek,

Thanks a lot...

Please provide the sample code if possible.

Thanks a ton in advance.

Riddhi,

Below is steps you need to follow.

On button click after Login

Validation for xls, xlsx, or csv using below client site code

<script type ="text/javascript">

    var validFilesTypes=["xlsx", "csv", "xls"];

    function ValidateUpload()

 {

     var file = document.getElementById("<%=FileUpload1.ClientID%>");

      var label = document.getElementById("<%=Label1.ClientID%>");

      var path = file.value;

      var ext=path.substring(path.lastIndexOf(".")+1,path.length).toLowerCase();

      var isValidFile = false;

      for (var i=0; i

      {

        if (ext==validFilesTypes[i])

        {

            isValidFile=true;

            break;

        }

      }

      if (!isValidFile)

      {

        label.style.color="red";

        label.innerHTML="Invalid File. Please upload a File with" +

         " extension:\n\n"+validFilesTypes.join(", ");

      }

      return isValidFile;

     }

script>

Read the data from fiel to data set

use below link

http://www.codeproject.com/Tips/300639/Import-Data-from-excel-to-SQL-server-using-Csharp

Then Write a code to check the SerialNumber from database

Then 

do

Update 

else 

Insert

Hope these steps will help.

Let me know if you want sample application or code for this.


Abhishek