How to bind data items in dropdown list on the basis of previously selected item from drop down list.

See more:

ASP.NET

HTML

database

I dont know this is possible or not in asp.net c#.
Here is my html code that contains 2 fields drop down list.
if i select any item from 1st drop down and on that basis 2nd field does have the items to select. Is this possible in pure C# code as we do in asp controls.
Thanks.

<div class="form-group">
                                       <select class="custom-select custom-select-width100 productbrand" name="product1brand">
                                           <option value="">Brand</option>
                                           <option value="Brand 1">Brand 1</option>
                                           <option value="Brand 2">Brand 2</option>
                                       </select>
                                       <label id="product1brand-error" class="error" for="product1brand"></label>
                                   </div>
                                   <div class="form-group">
                                       <select class="custom-select custom-select-width100 productproduct" name="product1product">
                                           <option value="">Product</option>
                                           <option value="Product 1">Product 1</option>
                                           <option value="Product 2">Product 2</option>
                                       </select>
                                       <label id="product1product-error" class="error" for="product1product"></label>
                                   </div>
                               </div>

What I have tried:

this is code to bind data to drop down list in 1st field.
and i have 2 database table in which 1st have primary key and 2nd table has its reference.

protected void Page_Load(object sender, EventArgs e)
       {
           if (!IsPostBack)
           {
               SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBcon"].ConnectionString);
               con.Open();
               string QueryString = "select * from Brand";

               SqlDataAdapter myCommand = new SqlDataAdapter(QueryString, con);
               DataSet ds = new DataSet();
               myCommand.Fill(ds);

               product1brand.DataSource = ds;
               product1brand.DataTextField = "Brand_Name";
               product1brand.DataValueField = "Brand_Id";
               product1brand.DataBind();
           }