How to get data from database in my android table view as columns -


i have done following coding deriving data's table , displayed in android view table columns , rows.

the database coding is

public list<country> getallcountry() {     list<country> countrylist = new arraylist<country>();      //select query     string selectquery = "select * country_list";      sqlitedatabase db = this.getwritabledatabase();     cursor cursor = db.rawquery(selectquery, null);       (cursor.movetofirst(); !cursor.isafterlast(); cursor.movetonext())     {          country country = new country();             country.setid(cursor.getstring(0));             country.setname(cursor.getstring(1));             country.setnationalty(cursor.getstring(2));             country.setdate(cursor.getstring(3));               // adding person list             countrylist.add(country);     }      return countrylist;  }

the xml is

<tablelayout      android:layout_width="fill_parent"     android:layout_height="fill_parent"     android:id="@+id/tab">   <tablerow       >           </tablerow>     </tablelayout>

the activity coding is

list<country> country = db.getallcountry();      stringbuilder builder = new stringbuilder();     (country c: country)     {                        builder.append(c.getid()).append(";")             .append(c.getname()).append(";")             .append(c.getnationalty()).append(";")             .append(c.getdate()).append("_");     }     //tv.settext(builder.tostring());      builder.tostring();      string st = new string(builder);     log.d("main",st);     string[] rows  = st.split("_");     tablelayout tablelayout = (tablelayout)findviewbyid(r.id.tab);     tablelayout.removeallviews();      for(int i=0;i<rows.length;i++){         log.d("rows",rows[i]);         string row  = rows[i];         tablerow tablerow = new tablerow(getapplicationcontext());         tablerow.setlayoutparams(new tablelayout.layoutparams(layoutparams.match_parent, layoutparams.wrap_content));         final string[] cols = row.split(";");          handler handler = null;          (int j = 0; j < cols.length; j++) {                          final string col = cols[j];                                              textview columsview = new textview(getapplicationcontext());             columsview.setlayoutparams(new tablerow.layoutparams(tablerow.layoutparams.wrap_content, tablerow.layoutparams.wrap_content));             columsview.settextcolor(color.black);             columsview.settext(string.format("%7s", col));                                             log.d("cols", string.format("%7s", col));             tablerow.addview(columsview);          }     }

the above code not printing in android emulator screen.

please have done wrong.

thanks in advance.

regards, dinesh

i guess missing tablelayout.addview(tablerow) on last line of 1st loop after coming out of 2nd loop..else row not added..


Comments

Post a Comment

Popular posts from this blog

android - Inheriting from Theme.AppCompat* -

currently working on migrating actionbar in support libraries. trying migrate old themes inherit theme.appcompat.light.darkactionbar isn't going smoothly. it fine if apply theme in manifest such: <activity android:name="com.fitsby.loginactivity" android:screenorientation="portrait" android:theme="@style/theme.appcompat.light.darkactionbar" > </activity> but runtime error, stating loginactivity(subclass of actionbaractivity) must have theme inherits theme.appcompat, when following: in styles.xml: <style name="apptheme" parent="@style/theme.appcompat.light.darkactionbar"> <item name="android:typeface">sans</item> </style> and in manifest: <activity android:name="com.fitsby.loginactivity" android:screenorientation="portrait" android:theme="@style/apptheme" > </activity> any ideas why happening? not...
Read more

broadcastreceiver - android BOOT_COMPLETED not received if not activity intent-filter -

Image
i set simple app. wan't hide drawer , want add boot receiver launch service. to hide application, read had remove manifest <intent-filter> <action android:name="android.intent.action.main" /> <category android:name="android.intent.category.launcher" /> </intent-filter> but when remove it, boot receiver doesn't work anymore. i added permission under manifest tag <uses-permission android:name="android.permission.receive_boot_completed" /> and receiver under application <receiver android:name="com.example.receiver.bootreceiver" > <intent-filter> <action android:name="android.intent.action.boot_completed" /> </intent-filter> </receiver> and in receiver code, there toast public class bootreceiver extends broadcastreceiver { @override public void onreceive(context context, intent intent) { toast.maketext(context,...
Read more

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more