How to Insert Excel Data to SQL Server Database in Asp.net core 2.0 MVC [on hold]












0














Currently i am trying to insert my excel data to SQL Server Database, and i am unsure of how to start. I am doing on ASP.NET Core MVC 2 using Visual Studio 2017. Most of the stuff i found online couldn't work.
I have a button which will send the Post request and am stuck on how to code in the controller to insert the data






c# razor asp.net-mvc-2 asp.net-core-2.0







share|improve this question









New contributor




asdf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as too broad by Crowcoder, snakecharmerb, Nate, Tomasz Mularczyk, arghtype 2 days ago


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.















  • Is any/both of your excel and sql server is in cloud/web server or personal machine?
    – Sonal Borkar
    2 days ago










  • It is all in personal machine.
    – asdf
    2 days ago










  • Got any code you can post? Cheers
    – d219
    2 days ago










  • @using (Html.BeginForm("UploadExcel", "User", FormMethod.Post, new { enctype = "multipart/form-data" })) { <div class="form-group"> <div class="control-label col-md-2">Excel:</div> <div class="col-md-10"> <input type="file" id="FileUpload" name="FileUpload" class="" /> </div> </div> <div class="form-group"> <div class="col-md-offset-2 col-md-10"> <input type="submit" value="Upload" id="btnSubmit" class="btn btn-primary" /> </div> </div> }
    – asdf
    2 days ago










  • all i have is this
    – asdf
    2 days ago
















0














Currently i am trying to insert my excel data to SQL Server Database, and i am unsure of how to start. I am doing on ASP.NET Core MVC 2 using Visual Studio 2017. Most of the stuff i found online couldn't work.
I have a button which will send the Post request and am stuck on how to code in the controller to insert the data






c# razor asp.net-mvc-2 asp.net-core-2.0







share|improve this question









New contributor




asdf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as too broad by Crowcoder, snakecharmerb, Nate, Tomasz Mularczyk, arghtype 2 days ago


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.















  • Is any/both of your excel and sql server is in cloud/web server or personal machine?
    – Sonal Borkar
    2 days ago










  • It is all in personal machine.
    – asdf
    2 days ago










  • Got any code you can post? Cheers
    – d219
    2 days ago










  • @using (Html.BeginForm("UploadExcel", "User", FormMethod.Post, new { enctype = "multipart/form-data" })) { <div class="form-group"> <div class="control-label col-md-2">Excel:</div> <div class="col-md-10"> <input type="file" id="FileUpload" name="FileUpload" class="" /> </div> </div> <div class="form-group"> <div class="col-md-offset-2 col-md-10"> <input type="submit" value="Upload" id="btnSubmit" class="btn btn-primary" /> </div> </div> }
    – asdf
    2 days ago










  • all i have is this
    – asdf
    2 days ago














0












0








0







Currently i am trying to insert my excel data to SQL Server Database, and i am unsure of how to start. I am doing on ASP.NET Core MVC 2 using Visual Studio 2017. Most of the stuff i found online couldn't work.
I have a button which will send the Post request and am stuck on how to code in the controller to insert the data






c# razor asp.net-mvc-2 asp.net-core-2.0







share|improve this question









New contributor




asdf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











Currently i am trying to insert my excel data to SQL Server Database, and i am unsure of how to start. I am doing on ASP.NET Core MVC 2 using Visual Studio 2017. Most of the stuff i found online couldn't work.
I have a button which will send the Post request and am stuck on how to code in the controller to insert the data






c# razor asp.net-mvc-2 asp.net-core-2.0




c# razor asp.net-mvc-2 asp.net-core-2.0






share|improve this question









New contributor




asdf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




asdf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited 2 days ago









Md. Zakir Hossain

693315




693315






New contributor




asdf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 2 days ago









asdf

11




11




New contributor




asdf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





asdf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






asdf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




put on hold as too broad by Crowcoder, snakecharmerb, Nate, Tomasz Mularczyk, arghtype 2 days ago


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.






put on hold as too broad by Crowcoder, snakecharmerb, Nate, Tomasz Mularczyk, arghtype 2 days ago


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.














  • Is any/both of your excel and sql server is in cloud/web server or personal machine?
    – Sonal Borkar
    2 days ago










  • It is all in personal machine.
    – asdf
    2 days ago










  • Got any code you can post? Cheers
    – d219
    2 days ago










  • @using (Html.BeginForm("UploadExcel", "User", FormMethod.Post, new { enctype = "multipart/form-data" })) { <div class="form-group"> <div class="control-label col-md-2">Excel:</div> <div class="col-md-10"> <input type="file" id="FileUpload" name="FileUpload" class="" /> </div> </div> <div class="form-group"> <div class="col-md-offset-2 col-md-10"> <input type="submit" value="Upload" id="btnSubmit" class="btn btn-primary" /> </div> </div> }
    – asdf
    2 days ago










  • all i have is this
    – asdf
    2 days ago


















  • Is any/both of your excel and sql server is in cloud/web server or personal machine?
    – Sonal Borkar
    2 days ago










  • It is all in personal machine.
    – asdf
    2 days ago










  • Got any code you can post? Cheers
    – d219
    2 days ago










  • @using (Html.BeginForm("UploadExcel", "User", FormMethod.Post, new { enctype = "multipart/form-data" })) { <div class="form-group"> <div class="control-label col-md-2">Excel:</div> <div class="col-md-10"> <input type="file" id="FileUpload" name="FileUpload" class="" /> </div> </div> <div class="form-group"> <div class="col-md-offset-2 col-md-10"> <input type="submit" value="Upload" id="btnSubmit" class="btn btn-primary" /> </div> </div> }
    – asdf
    2 days ago










  • all i have is this
    – asdf
    2 days ago
















Is any/both of your excel and sql server is in cloud/web server or personal machine?
– Sonal Borkar
2 days ago




Is any/both of your excel and sql server is in cloud/web server or personal machine?
– Sonal Borkar
2 days ago












It is all in personal machine.
– asdf
2 days ago




It is all in personal machine.
– asdf
2 days ago












Got any code you can post? Cheers
– d219
2 days ago




Got any code you can post? Cheers
– d219
2 days ago












@using (Html.BeginForm("UploadExcel", "User", FormMethod.Post, new { enctype = "multipart/form-data" })) { <div class="form-group"> <div class="control-label col-md-2">Excel:</div> <div class="col-md-10"> <input type="file" id="FileUpload" name="FileUpload" class="" /> </div> </div> <div class="form-group"> <div class="col-md-offset-2 col-md-10"> <input type="submit" value="Upload" id="btnSubmit" class="btn btn-primary" /> </div> </div> }
– asdf
2 days ago




@using (Html.BeginForm("UploadExcel", "User", FormMethod.Post, new { enctype = "multipart/form-data" })) { <div class="form-group"> <div class="control-label col-md-2">Excel:</div> <div class="col-md-10"> <input type="file" id="FileUpload" name="FileUpload" class="" /> </div> </div> <div class="form-group"> <div class="col-md-offset-2 col-md-10"> <input type="submit" value="Upload" id="btnSubmit" class="btn btn-primary" /> </div> </div> }
– asdf
2 days ago












all i have is this
– asdf
2 days ago




all i have is this
– asdf
2 days ago

















active

oldest

votes






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes

-

Popular posts from this blog

Mossoró

Image
  Nota: Para outros significados, veja Mossoró (desambiguação). Município de Mossoró "Capital do Oeste Potiguar" [ 1 ] "Capital nacional do Semiárido" [ 2 ] [ 3 ] "Capital Cultural do Rio Grande do Norte" [ 1 ] "Terra de Santa Luzia" [ 4 ] "Terra do Sol, do Sal e do Petróleo" [ 5 ] "Terra da Liberdade [ 6 ] " Centro de Mossoró, com a Praça Vigário Antônio Joaquim e, ao fundo, a câmara municipal de vereadores (esquerda) e Catedral de Santa Luzia (direita) Bandeira Brasão Hino Fundação 15 de março de 1852 (166 anos) Gentílico mossoroense Padroeiro(a) Santa Luzia Prefeito(a) Rosalba Ciarlini Rosado (PP) (2017 – 2020 ) Localização Localização de Mossoró no Rio Grande do Norte Mossoró Localização de Mossoró no Brasil 05° 11' 16" S 37° 20' 38" O 05° 11' 16" S 37° 20' 38" O Unidade federativa Rio Grande do No...
Read more

Error while reading .h5 file using the rhdf5 package in R

Image
0 I'm importing a .h5 file into R by using the rhdf5 package. But a warning message showed and I found the DATE_TIME column of my data is NA when I view the imported file. Warning message: In H5Dread(h5dataset = h5dataset, h5spaceFile = h5spaceFile, h5spaceMem = h5spaceMem, : h5read for type 'TIME' not yet implemented. Values replaced by NA's. It's all normal when I use Vitables (Python) to open the .h5 file. But the DATE_TIME column is NA with HDFViewer open it. My code is: library(rhdf5) test <- h5read("mytestdata.h5", "/results") View(mydatatest) I want to use R to open .h5 file. Please give me some help! Thanks in advance! r hdf5 rhdf5 ...
Read more

Pushsharp Apns notification error: 'InvalidToken'

Image
1 1 I am currently working on automatic updates for Passbook (wallet) tickets and am experiencing some trouble using the Pushsharp library by Redth. I am using a Push notification certificate from the apple developer portal. I have tried to export my certificate as .p12, .pem and tried to use only the private key as .12 or .pem but nothing works. This is my full certificate (information is blanked out for security reasons): https://cdn.pbrd.co/images/HUJtb7b.png I dont have enough reputation to post images so a link is all i can provide. var succeeded = 0; var failed = 0; var attempted = 0; var config = new ApnsConfiguration(ApnsConfiguration.ApnsServerEnvironment.Sandbox, ConfigManager.CertPath + "PushCertificateV2.p12", ConfigManager.lvppass, fa...
Read more