ASP.NET

1. Read the question carefully
   
2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar
   
3. If a question is poorly phrased then either ask for clarification, ignore it, or mark it down. Insults are not welcome
   
4. If the question is inappropriate then click the 'vote to remove message' button
   

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="First2023WebUserControl.ascx.cs" Inherits="First2023Control.UserControls.First2023WebUserControl" %>
<asp:Label ID="Label1" runat="server" Text="Hello Year 2023"></asp:Label>
<p>
     </p>
Category:<asp:DropDownList ID="ddlCategory" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlCategory_SelectedIndexChanged">
</asp:DropDownList>
<p>
    Subcategory:
    <asp:DropDownList ID="ddlSubcategory" runat="server" AutoPostBack="True">
    </asp:DropDownList>
</p>
<p>
    <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
</p>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
<asp:Label ID="Label3" runat="server" Text="Label"></asp:Label>

protected void Page_Load(object sender, EventArgs e)
{

        Label3.Text = "In Page Load selected index is " + ddlCategory.SelectedIndex.ToString();
        XXXDbSupport objDBSupport = new XXXDbSupport();
        DbCommand objDBCommand = objDBSupport.CreateDbCommand();
        objDBCommand.CommandType = CommandType.Text;
        string sSQL = "select distinct isnull(Category,'(blank)') as ProdCat from xxx_product order by isnull(Category,'(blank)')";
        objDBCommand.CommandText = sSQL;
        DataTable objDBTable = objDBSupport.FillDataTable(objDBCommand);
        if (objDBTable.Rows.Count > 0)
        {
            ddlCategory.DataTextField = "ProdCat";
            ddlCategory.DataValueField = "ProdCat";
            ddlCategory.DataSource = objDBTable;
            ddlCategory.DataBind();
        }
        else
        {
            ddlCategory.Text = "n/a";
        }

}

protected void ddlCategory_SelectedIndexChanged(object sender, EventArgs e)
{
    Label2.Text = "The selected index changed to " + ddlCategory.SelectedIndex.ToString();
    XXXDbSupport objDBSupport = new XXXDbSupport();
    DbCommand objDBCommand = objDBSupport.CreateDbCommand();
    objDBCommand.CommandType = CommandType.Text;
    string sSQL = "select distinct isnull(SubCategory,'(blank)') as SubCat from xxx_product ";
    if (ddlCategory.Text == "(blank)")
    {
        sSQL = sSQL + "where isnull(Category,'(blank)') = '(blank)' order by isnull(SubCategory,'(blank)')";
    }
    else
    {
        sSQL = sSQL + "where Category = '" + ddlCategory.Text + "' order by isnull(SubCategory,'(blank)')";
    }
    objDBCommand.CommandText = sSQL;
    DataTable objDBTable = objDBSupport.FillDataTable(objDBCommand);
    if (objDBTable.Rows.Count > 0)
    {
        ddlSubcategory.DataTextField = "SubCat";
        ddlSubcategory.DataValueField = "SubCat";
        ddlSubcategory.DataSource = objDBTable;
        ddlSubcategory.DataBind();
    }
    else
    {
        ddlSubcategory.Text = "n/a";
    }

}

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="First2023WebUserControl.ascx.cs" Inherits="First2023Control.UserControls.First2023WebUserControl" %>
<asp:Label ID="Label1" runat="server" Text="Hello Year 2023"></asp:Label>
<p>
     </p>
Category:<asp:DropDownList ID="ddlCategory" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlCategory_SelectedIndexChanged">
</asp:DropDownList>
<p>
    Subcategory:
    <asp:DropDownList ID="ddlSubcategory" runat="server" AutoPostBack="True">
    </asp:DropDownList>
</p>
<p>
    <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
</p>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
<asp:Label ID="Label3" runat="server" Text="Label"></asp:Label>

dotnet.exe publish C:\..\Produce.csproj --configuration Release -r win-x64 --self-contained true --output C:\..\Produce5

MSBuild version 17.7.1+971bf70db for .NET
...
C:\Program Files\dotnet\sdk\7.0.400\Sdks\Microsoft.NET.Sdk.BlazorWebAssembly\targets\Microsoft.NET.Sdk.BlazorWebAssembly.6_0.targets(325,5)
error MSB4018: 
The "GenerateBlazorWebAssemblyBootJson" task failed unexpectedly. [C:\...\Parts.Production.Blazor.csproj]
System.IO.IOException: The process cannot access the file 'C:\..\Parts.Production.Blazor\obj\Release\net7.0\blazor.boot.json' because it is being used by another process. [C:\..\Parts.Production.Blazor.csproj]