Hi I am a beginner in ASP.NET i have started designing a application where in my Create Users Page
once user type is changed the projects drop down should populate with all the projects related to that user there is a relation between these two tables in the Data base\[code\] Dim da As New SqlDataAdapter("select [Project] from [DB_ECleanse].[dbo].[Tbl_Project] ") Dim dt As New DataTable() da.Fill(dt) DdlProject.DataSource = dt DdlProject.DataTextField = "col1" DdlProject.DataValueField = "col1" DdlProject.DataBind() DdlProject.Items.Insert(0, "Select")\[/code\]this is the code i have tried but unable to populate the second