Populating a table inside a bootstrap modal from ASP.net
<p>I'm looking to achieve the functionality in the attached pictures. I want to populate a table from a MSSQL database. Not all of the columns present in the database table are displayed in the bootstrap modal and an additional button is added for the user to select a particular site. Once a site is selected, the site id is used to pull the data and populate the input fields in the page. What would be the most efficient way of doing this? Its my first time working with ASP so i wanted to know the best practices. Would javascript be an option for programming the select button or would ASP be better?</p>

<p>Any help is appreciated.</p>

<p><a href="https://i.stack.imgur.com/Tdzf4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Tdzf4.png" alt="modal"></a></p>

<p><a href="https://i.stack.imgur.com/N8nHJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N8nHJ.png" alt="input fields"></a></p>