c# - Query SQL Server CE to Listbox (Windows phone) -
i have code:
public void mostrar(listbox medicinas_visual) { var query = medicamento in usuario_data.current.medicamento orderby medicamento.id_med select new {medicamento.id_med, medicamento.nombre}; medicinas_visual.itemssource = query.tostring(); }
and when execute code returns: {id_med = 1 nombre= prepilon}
string query, when want returns values
code xaml of listbox
listbox x:name="medicinas_visual" margin="0,56,0,4" fontfamily="/li_health;component/fonts/fonts.zip#helvetica s" fontsize="24" horizontalalignment="left" width="166"/
implement this. should work: display id_med , nombre listbox
xaml:
<listbox x:name="medicinas_visual" margin="0,56,0,4" fontfamily="/li_health;component/fonts/fonts.zip#helvetica s" fontsize="24" horizontalalignment="left" width="166"> <listbox.itemtemplate> <datatemplate> <stackpanel orientation="horizontal"> <textblock text="{binding id}"></textblock> <textblock text="{binding data}"></textblock> </stackpanel> </datatemplate> </listbox.itemtemplate> </listbox>
cs:
public void mostrar(listbox medicinas_visual) { list<data> objlist = new list<data>(); var query = medicamento in usuario_data.current.medicamento orderby medicamento.id_med select medicamento; foreach (var item in query) { objlist.add(new data(item.id_med, item.nombre)); } medicinas_visual.itemssource = objlist; } public class data { public int id { get; set; } public string data { get; set; } public data(){ } public data(int id, string data) { this.id = id; this.data = data; } }
Comments
Post a Comment