c# - Populate a Listbox from a database -

i want fill listbox 'lstcategories' content of database , see nothing, here's code :

public void fillcategories() {     samsonentities db = new samsonentities();      var listcats = (from cat in db.categories                     select new categorydisplay()                     {                         categoryid = cat.categoryid,                         categoyname = cat.categoryname                     }).tolist();       //for (var = 0; < db.categories.count();i++ )      //{      //    lstcategories.items.add(....);      //} } 

i don't know place line of 'for', put in comments

have tried setting list listbox datasource?

 lstcategories.datasource = listcats; 

that should enough.

as per comment need set displaymember of list match property show:

lstcategories.displaymember = "categoryname"; 

and want setup valuemember too:

lstcategories.valuemember = "categoryid";