Updating server db from client?

Discussion in 'ASP.NET / ASP.NET Core' started by Paul73, Jul 13, 2011.

  1. Hi guys,

    I'm about to create my first ASP.net project and was hoping for a little guidance.

    What we want to do is create a job status app. We will have a client winform program (written in C#) that updates a SQL database on the website when a barcode is scanned. Then people will log into the website and view the updated db through a gridview.

    Can I update the server db by sending an SQL update commands from the client using a connection something like this:

    Also, can I do this with a basic hosting account or will I need to add an SQL Server add on?

    Sorry if these are newbie questions! I appreciate any feedback.
     
  2. If you mean a SQL Express DB on your DASP site, no.
    There are ways to do this and adding a SQL Server to your site will be the best.
     
  3. Thanks for the feedback, wisemx. Sounds like SQL Server is the way to go then.
     
  4. Kool .;-)
    If you need help with it let us know.
     

Share This Page