android - Index 2 requested with size of 2 -
android - Index 2 requested with size of 2 -
i newbie android development , here first project of gridview database. show error "index 2 requested size of 2"
i using sqlite database db file
here code
please help me!!!!!
public class mainactivity extends activity { sqlitedatabase mydb; gridview data; @override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_main); info = (gridview) findviewbyid(r.id.gridview1); list<string> li = new arraylist<string>(); arrayadapter<string> dataadapter = new arrayadapter<string>( getapplicationcontext(), android.r.layout.simple_spinner_dropdown_item, li); dataadapter.setdropdownviewresource(r.layout.activity_main); seek { mydb = openorcreatedatabase(getstring(r.string._sdcard_sales_db), mode_private, null); cursor cr = mydb.rawquery("select * users", null); if (cr != null) { if (cr.movetofirst()) { { string desc = cr.getstring(cr.getcolumnindex("user")); li.add(desc); } while (cr.movetonext()); toast.maketext(getapplicationcontext(), cr.getstring(cr.getcolumnindex("user")), toast.length_long).show(); } else { toast.maketext(getapplicationcontext(), "no data", toast.length_long).show(); } } cr.close(); mydb.close(); } grab (exception e) { toast.maketext(getapplicationcontext(), "error" + e.getmessage(), toast.length_long).show(); } }}
thanks in advance
do { string desc = cr.getstring(cr.getcolumnindex("user")); li.add(desc); } while (cr.movetonext()); toast.maketext(getapplicationcontext(), cr.getstring(cr.getcolumnindex("user")), toast.length_long).show();
after do-while loop, cursor cr
points row after lastly valid row.
remove toast
phone call getstring()
invalid cursor index, or alter toast info want.
android eclipse sqlite indexing size
Comments
Post a Comment