locked
Web services RRS feed

  • Question

  • Hi

    I am trying create a web service (web site) system. using vb.net/c#. logic of the system is simple. the user just select an csv/text file and submit it to an sql database. i just want ideas and maybe templates on how to go about it am still a junior.

    Thanks

    Monday, July 28, 2014 8:24 AM

Answers

  • Hi tmpmadula,

    This article can be a good starting point for uploading files in ASP.Net web applications:

    Upload and Download Files with SQL Server in ASP.NET

    It demonstrates how to upload files in Sql Server database.

    I hope this would help you to start with.

    Best Regards


    • Edited by Ashutosh Mahto Monday, July 28, 2014 10:43 AM Updating the link
    • Proposed as answer by Just Karl Thursday, July 31, 2014 4:14 PM
    • Marked as answer by Just Karl Friday, August 8, 2014 4:07 PM
    Monday, July 28, 2014 10:42 AM
  • Thanks for Ramachandran and Ashutosh's help.

    Hi tmpmadula,

    So it is not the VS IDE issue, maybe the ASP.net forum would be better for this issue.

    You could post this issue in this forum:

    http://forums.asp.net/28.aspx

    Best Regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Proposed as answer by Just Karl Thursday, July 31, 2014 4:14 PM
    • Marked as answer by Just Karl Friday, August 8, 2014 4:07 PM
    Tuesday, July 29, 2014 8:43 AM

All replies

  • Hi tmpmadula,

    Are you intending to create a WEB SERVICE or is it an ASP.NET WEB SITE ? 



    Regards, Ram If you find the answer as helpful, Please vote as helpful.

    Monday, July 28, 2014 10:22 AM
  • Hi tmpmadula,

    This article can be a good starting point for uploading files in ASP.Net web applications:

    Upload and Download Files with SQL Server in ASP.NET

    It demonstrates how to upload files in Sql Server database.

    I hope this would help you to start with.

    Best Regards


    • Edited by Ashutosh Mahto Monday, July 28, 2014 10:43 AM Updating the link
    • Proposed as answer by Just Karl Thursday, July 31, 2014 4:14 PM
    • Marked as answer by Just Karl Friday, August 8, 2014 4:07 PM
    Monday, July 28, 2014 10:42 AM
  • Thanks for Ramachandran and Ashutosh's help.

    Hi tmpmadula,

    So it is not the VS IDE issue, maybe the ASP.net forum would be better for this issue.

    You could post this issue in this forum:

    http://forums.asp.net/28.aspx

    Best Regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Proposed as answer by Just Karl Thursday, July 31, 2014 4:14 PM
    • Marked as answer by Just Karl Friday, August 8, 2014 4:07 PM
    Tuesday, July 29, 2014 8:43 AM
  • Ramachandran

    An ASP.net that  reads CSV/txt files and and insert it on an sql table.

    all txt files have the same header so i can easily create the table before i append.

    This asp site i want it to work like the import wizard but it should insert data from txt files at one go. i have clients who can not use sql server thats why i am creating this. 

    Friday, August 1, 2014 7:19 AM
  • Jack /Mahto

    I am not uploading a file actually i am reading the file then send data to sql table/s

    Friday, August 1, 2014 8:46 AM
  • Hi tmpmadula,

    Some useful documents:

    http://www.codeproject.com/Articles/290242/Import-Data-from-a-Text-or-CSV-file-into-SQL-Serve

    http://geekswithblogs.net/dotNETvinz/archive/2011/01/03/uploading-and-importing-csv-file-to-sql-server-in-asp.net.aspx

    http://dotnetawesome.blogspot.com/2013/11/how-to-import-export-database-data-from.html

    Note: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you.

    Microsoft does not control these sites and has not tested any software or information found on these sites;

    Therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there.

    There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Best Regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. <br/> Click <a href="http://support.microsoft.com/common/survey.aspx?showpage=1&scid=sw%3Ben%3B3559&theme=tech"> HERE</a> to participate the survey.

    Friday, August 1, 2014 9:43 AM