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

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

php - render data via PDO::FETCH_FUNC vs loop -

The canvas has been tainted by cross-origin data in chrome only -