c# - How to update queries upon change of dropdown selection in Razor? -

c# - How to update queries upon change of dropdown selection in Razor? -

i'm finish beginner , i'm trying figure out razor / asp.net / c# (any useful resources helpful)

i want update query based on dropdown selection:

here's have:

@{ page.title = "home"; var db = database.open("outreachmodule"); var people = db.query("select * people").tolist(); var items = people.select(i => new selectlistitem { text = i.name }); } @functions { void itemselected() { console.write("hello world"); } }

...html...

@html.dropdownlist("select1",items,new {onchange = "itemselected()"})

...more html ...

i know @functions thing isn't way go. dropdown works, itemselected method called says it's not defined. assume because it's looking javascript function. there way alter of selection of dropdown trigger razor code can re-run queries etc on selected person (for example) ?

c# asp.net razor webmatrix asp.net-webpages