ASP.NET

how to auto print label in vb to be in the database

public class EquipmentsController : ODataController
    {
        private readonly SqlServerContext _sqlServerContext;

        public EquipmentsController(SqlServerContext sqlServerContext)
        {
            _sqlServerContext = sqlServerContext;
        }

        [HttpGet]
        [EnableQuery]
        public ActionResult<IQueryable<Equipment>> Get()
        {
            IQueryable<Equipment> eqList = _sqlServerContext.Equipments.AsQueryable()
                .Include(x => x.CostCenter)
                .Include(x => x.EquipmentCategory)
                .Include(x => x.equipmentType);

            return Ok(eqList);
        }
    }

static IEdmModel GetEdmModel()
{
    ODataConventionModelBuilder builder = new();
    builder.EntitySet<Equipment>("Equipments");
    return builder.GetEdmModel();
}

 <ajax:ModalPopupExtender ID="installAddress_MPE" runat="server" TargetControlID="label2" PopupControlID="div5" BackgroundCssClass="modalBackground" />
<div id="div5" runat="server">
 <asp:Table ID="Table1" Style="background-color:White; font-size:12pt; color:Black;" runat="server">
   <asp:TableRow>
     <asp:TableCell ID="TableCell3" Style="background-color:Blue; font-size:14pt; color:White;" runat="server" ColumnSpan="6">
      <asp:Label ID="installAddressHeader" runat="server" Text="New Installation Address Entry" />
     </asp:TableCell>
   </asp:TableRow>
</asp:Table>
<div id="divRebatable" class="popupdiv">
   <asp:TextBox ID="txt_toiletsizes" placeholder="Enter new Toiltet GPF" Width="150px" runat="server"></asp:TextBox>
    <asp:TextBox ID="txt_newAmount" placeholder="Enter amount" Width="100px" runat="server"></asp:TextBox>
    <asp:Button ID="btn_add" runat="server" Text="Add It" onclick="btn_add_Click"
        Width="100px" />
    <asp:Table ID="rebatableTable" Width="100%" runat="server">
        <asp:TableRow CssClass="divHeader"><asp:TableHeaderCell ColumnSpan="4">Add Rebatable Toilets</asp:TableHeaderCell></asp:TableRow>
        <asp:TableRow ID="allToilets" runat="server">
            <asp:TableHeaderCell>How many toilets?</asp:TableHeaderCell>
            <asp:TableCell>
             <asp:DropDownList ID="ddlNumber" runat="server" OnSelectedIndexChanged="ddlNumber_SelectedIndexChanged" AutoPostBack="true">
               <asp:ListItem Text="--Select--" Value=""></asp:ListItem>
               <asp:ListItem Text="1" Value="1"></asp:ListItem>
               <asp:ListItem Text="2" Value="2"></asp:ListItem>
               <asp:ListItem Text="3" Value="3"></asp:ListItem>
             </asp:DropDownList>
            </asp:TableCell>
            </asp:TableRow>
    </asp:Table>
</div>
     <div>
         <asp:Repeater ID="DynamicRepeater" runat="server" onitemdatabound="DynamicRepeater_ItemDataBound">
             <HeaderTemplate>
                 <table border="1">
                     <tr>
                         <td>Toilet Size</td>
                          <td>Model #</td>
                         <td>Date Upgraded</td>
                     </tr>
             </HeaderTemplate>
             <ItemTemplate>
                 <tr>
                     <td>
                   <asp:DropDownList ID="ddlToiletGPF" AutoPostBack="true" runat="server">
                   </asp:DropDownList>
                     </td>
                     <td>
                         <asp:TextBox ID="ModelNumber" runat="server"></asp:TextBox>
                     </td>
                     <td>
                         <asp:TextBox ID="DateUpgraded" runat="server"></asp:TextBox>
                     </td>
                 </tr>
             </ItemTemplate>
             <FooterTemplate>
                 </table>
             </FooterTemplate>
         </asp:Repeater><br />
         <asp:Label ID="lblSuccess" style="font-weight:bold;" runat="server" Text=""></asp:Label>
     </div>
   </div>
   <asp:Label ID="lblMsg" runat="server" Text="" /><br />


    Protected Sub Submit(sender As Object, e As EventArgs)

        Dim address As String = Request.Form(txtSearch.UniqueID)
        Dim speakerId As String = Request.Form(hfAutoId.UniqueID)

        'get the results and fill in the datagrid

        Dim sqlStatement As String = "Select o.PrimaryFirst, o.PrimaryLast, ap.applicant, FORMAT(ap.DateReceived, 'd','us') as DateReceived,o.SecondaryFirst,o.SecondaryLast,ad.InstallAddress,ad.InstallCity, ad.InstallState, ad.InstallZip, ad.WaterAcctNo from Applications ap "
        sqlStatement += "inner Join Addresses ad on ap.WaterAccountNo = ad.WaterAcctNo inner join Owner o on ap.OwnerCode = o.OwnerID Where ad.InstallAddress Like '%" & address.Replace("'", "''").Trim() & "%'"

        Dim sqlCmd2 As SqlCommand = New SqlCommand(sqlStatement, myConnection)
        Dim reader As SqlDataReader = sqlCmd2.ExecuteReader()

        If reader.HasRows Then
            While reader.Read()
                div1.Visible = False
                installationAddress.Text = reader("InstallAddress").ToString() & " " & reader("InstallCity").ToString() & ", " & reader("InstallState").ToString() & " " & reader("InstallZip").ToString()
                waterAccountNumber.Text = reader("WaterAcctNo").ToString()
                ownerInformation.Text = reader("PrimaryFirst").ToString() & " " & reader("PrimaryLast").ToString()
                dateReceived.Text = reader("dateReceived").ToString()
                applicantName.Text = reader("applicant").ToString()
            End While
        Else
            div1.Visible = True
        End If
        reader.Close()
        sqlCmd2.Dispose()
        myConnection.Close()
    End Sub

'🔸🖤 DANCE SQUARE 🖤🔸\n📝 LA TRILOGIE :\n3 dates à ne surtout pas manquer\n.\n🟧◾️ 29 Octobre - LA'

if (!res.IsDBNull(i))
     ss {
            return res.GetString(i);
        }
        else
        {
            return string.Empty;
        }

// check to be sure the date selected is not ouside acceptable boudaries
      DateTime runDate = DateTime.Parse(rsRunDate.Text);

DateTime runDate = DateTime.ParseExact(srRunDate.Text,"dd/MM/yyyy", null);

DateTime _runDate;
string runDate = "";

_runDate = DateTime.Parse(srRunDate.Text);
runDate = _runDate.ToString("dd/MMM/yyyy");

if (runDate.Date > DateTime.Now.Date)...

The name 'runDate' does not exist in the current context

I am migrating the .Net Project to .Net core 3.1 and there are loads of dependencies in the project so I cannot create a new .Net core application. How can I add Program.Cs file in my existing .Net api project?

I need this code in my existing .Net api project

<pre>public class Program
    {
        public static void Main(string[] args)
        {
            CreateHostBuilder(args).Build().Run();
        }

        public static IHostBuilder CreateHostBuilder(string[] args) =>
            Host.CreateDefaultBuilder(args)
                .ConfigureWebHostDefaults(webBuilder =>
                {
                    webBuilder.UseStartup<Startup>();
                })
                .UseSerilog((hostingContext, loggerConfiguration) =>
                {
                    var connectionString = hostingContext.Configuration.GetSection("Serilog:WriteTo:0:Args:connectionString");
                    connectionString.Value = connectionString.Value;
                    loggerConfiguration.ReadFrom.Configuration(hostingContext.Configuration);
                });
    }