You must Sign In to post a response.
  • Category: ASP.NET

    How to upload particular values from xl to sql using asp.net

    hi frnds i need urgent solution.
    i have database table like stname,college,coursename and mark..but i have xl file like stname ,college,coursename only..i need to insert this particular three values only .remaning field "mark" will add time of upload button with corresponding textbox value..if any possible ..give any solution
  • #769869
    Hello,

    You can refer the below article.
    http://www.dotnetspider.com/resources/42933-Import-Data-from-Excel-SQL-Server-using-ASP-Net.aspx

    Hope this will help you to solve your problem.

    Regards,
    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"

  • #769873
    Hi,

    You can refer the below articlar to import Excel to SQL Server Particular values.

    https://www.codeproject.com/Tips/509179/Read-Excel-File-into-DataSet-in-ASP-NET-Using-Csha

    Regards
    Sriram.R


  • Sign In to post your comments