Hi,
I have two tables, for which I have made that whenever a user selects a category from One dropdown, the respective sub categories should appear in the next dropdown. I tried but it is not working for me.
Please see the table for your reference.
Create table Categories_For_Merchant
(
Id int identity(1,1) not null primary key,
Category_Name varchar(100),
Parent_Id int null,
Description varchar(225)
)
Create table Merchants(
id int Foreign key references Categories_For_Merchant(Id),
Category_Name varchar(100),
Merchant_Name nvarchar(225),
Store_Name nvarchar(225),
Store_Address nvarchar(max),
City nvarchar(50)
)
But i am not getting the sub categories. please help
Also see my code for your reference:-
protected void Page_Load(object sender, EventArgs e)
{
conn.Open();
SqlCommand cmd = new SqlCommand("select * fr ...
Go to the complete details ...