Cezary Wiak

Cezary Wiak

  • NA
  • 7
  • 0

Razor pages single field SQL Server update

Jul 21 2020 8:04 PM
Can anyone point me in ea tight direction. I am using VS2019. I am developing an inventory tracking website. I have an index page witha list of items in HTML table (int ID, string Tag_No, string Description, string Verify...). The default Razor Pages SQL Server CRUD operations work great. My issue is: on the Index page I also have an <input type="text" name="txtTag".../>tag where upon entry of an item's Tag_No (from hand held scanner), I need to update the "Verify" field of a single item. In other words I want to achieve the following using Razor Pages: UPDATE Inventory SET Verify = 'D' WHERE Tag_No = txtTag (where txtTag is a string from the input tag on the index page).

Answers (1)