Grid view or Dropdown with SQL datasource

 <asp:GridView runat="server" ID="grdSalesReportCustomer" AutoGenerateColumns="False" DataSourceID="SalesReportCustomer">

                        <Columns>

                            <asp:BoundField DataField="Name" HeaderText=" Customer Name" SortExpression="Name"></asp:BoundField>

                            <asp:BoundField DataField="TotalAmountSpent" HeaderText="Total Amount Spent" ReadOnly="True" SortExpression="TotalAmountSpent"></asp:BoundField>

                        </Columns>

                    </asp:GridView>

                    <asp:SqlDataSource runat="server" ID="SalesReportCustomer" ConnectionString='<%$ ConnectionStrings:ConStringTrainee %>' SelectCommand="select  cm.Name, sum(pd.Total_Price) as TotalAmountSpent from Purchase_Details pd inner join Customer_Master cm on cm.Customer_ID= pd.Customer_ID group by pd.Customer_ID, cm.Name"></asp:SqlDataSource>

in c# code

on save click

 grdSalesReport.DataSourceID = "BookSalesReport";

            grdSalesReport.DataBind();

Convert boolean to Yes or no in Grid view in asp.net

 <asp:TemplateField HeaderText="Active" SortExpression="Active">

    <ItemTemplate><%# (Boolean.Parse(Eval("Active").ToString())) ? "Yes" : "No" %></ItemTemplate>
</asp:TemplateField>

How to add two select query in single line in ASP.NET - Dataset of two tables

  string conString = ConfigurationManager.ConnectionStrings["tempdbConnectionString"].ConnectionString;

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                using (SqlConnection con = new SqlConnection(conString))

                {

                    con.Open();

                    using (SqlCommand cmd = new SqlCommand("SELECT [Teacher_ID], [Teacher_Name] FROM [Student_Master]; SELECT [Student_ID] ,[Teacher_ID],[Student_Name],[Passed] FROM [dbo].[Student_Details]", con))

                    {

                        using (SqlDataAdapter da = new SqlDataAdapter(cmd))

                        {

                            DataSet ds = new DataSet();

                            da.Fill(ds);

                            ddlTeacher.DataSource = ds.Tables[0];

                            ddlTeacher.DataBind();

                            ddlTeacher.Items.Insert(0, new ListItem("-Select-", "0"));

                            grdStudentDetails.DataSource =  ds.Tables[1];

                            grdStudentDetails.DataBind();

                        }

                    }

                    con.Close();

                }

              

            }

        }

How to convert a asp.net page to HTML Page

 https://www.syncfusion.com/faq/aspnet/custom-controls/how-can-we-convert-an-asp-net-page-to-html

Dependency injection - Tight Coupling and loose coupling

 https://berkay-ergun.medium.com/loose-coupling-and-tight-coupling-53f5bc885667#:~:text=Loose%20Coupling%20supports%20writing%20code,make%20development%20processes%20more%20efficient

https://ronaldkainda.blog/tightly-coupled-code