Passing HTML page parameters to ASP.NET

Question

I have an Asp.net page that I need to get parameters from template HTML. I am trying the way below but I am not getting the values. Follow my code:

HTML - Template

<form method="post" action="http://localhost:61712/Default.aspx">

<TABLE>
<TBODY>
  <TR>
      <tdTEXT-ALIGN: center">
          <p><font size="3"><b>Solicitacao Nr. %NUMSC% </b></font> 
        <input type="hidden" name="NumeroSC" value="%NUMSC%" /> 

      </td>
   </tr>
</tbody>
</table>
</form>

My page ASP.NET Default.aspx

<%@ import Namespace="System.Data.SqlClient" %> 

<script runat="server">
        protected void Page_Load(Object Src, EventArgs E)
        {
            string host = "******";
            string usuario = "******";
            string senha = "******";
            string banco = "******"; 

            var Compra = Request.Form["NumeroSC"];

            string strSQL = "SELECT codigo as Numero, arquivo from MeuDatabase where codigo like '%Compra%'"; // é dessa forma que pego o parametro na string? Já tentei também + Compra +             

            SqlConnection conexao = new SqlConnection("Data Source=" + host + ";DATABASE=" + banco + ";UID=" + usuario + "; PWD=" + senha + ";");

            conexao.Open();  

      ...      

When running my ASP.NET page, the page does not return any value for the query. I have tried it in HTML at value pass an existing fixed value but also in my query does not return value.

What am I doing wrong? How can I get this parameter right %NUMSC%?

EDIT

This form is not a Ubmit, it is a template. Every new request is mounted and filed an html, one for each request. My wish is that every html I open I call the Asp.net page with the information of that specific file number. Here’s how it works: an approving user receives an email with the link pointing to html (invoice). I wanted that when the user opened the link he would see the data that he already sees currently another "framezinho" embedded in this html that is a href pointing to the attachment(document) referring to that invoice. The point is, I can’t edit the code of the program that generates the invoice to already bring that information. So I saw the need to create an Asp.net page.

Answer 1

If I understand correctly, what you do is: after completion of the request, an HTML is generated from this template, only with the completed request number.

What you want to do is: after sending this HTML by email and when accessed, search more data from this number that is in HTML and fill the same.

Am I right? If I am, I imagine three options:

1. Create HTML with all data already filled (I see no reason not to do so, unless the data is not ready);
2. E-mail a link pointing to an ASPX page with the request number as parameter (example: geranotafiscal.aspx?solicitacao=12345) and when accessing you generate this HTML with all the information, sending it to the user;
3. The way you want it, having only the number of the request in an HTML and when the user opens, fill in the other data, I imagine it is possible only with javascript, in the load event to make by ajax a request to your page, passing the parameter and returning the desired data.

The last solution will take a lot of work and will have the same result as the first. If you can’t do the first one for the reason I mentioned or something, do the second.

The solutions presented above consider the need for the file to be HTML, available for download. If it’s just for presentation, create an ASPX in the format of the invoice, with the Abels and everything, do as in Solution 2, pass a link of type notafiscal.aspx? request=12345 and on Pageload, take the request number, search the data and fill in the Abels.