I have defined the function showMeTable() for getting data from sqlite database in DbHelper.java class. Then i call it from WeekDbShow.java class. After getting the table in the form of string , i am setting it to a textView .Here is the part of my DbHelper.java class .
public String showMeTable() { String mStr=""; mStr=mStr.concat("<body >"); mStr=mStr.concat("<tr><td align='center'><b>period</b></td><td align='center'><b>Monday</b></td>" + "<td align='center'><b>Tuesday</b></td><td align='center'><b>Wednesday</b></td><td align='center'><b>Thrusday</b></td>" + "<td align='center'><b>Friday</b></td></tr>"); String[] columns=new String[]{KEY_ROWID,KEY_PERIOD,KEY_MON,KEY_TUES,KEY_WED,KEY_THRUS,KEY_FRI};//KEY_MON may be instead of weekDay Cursor cursor=OurDb.query(DATABASE_TABLE,columns,null,null,null,null,null); cursor.moveToFirst(); while(!cursor.isAfterLast()) { mStr=mStr.concat("<tr><td>"+(cursor.getString(cursor.getColumnIndex(KEY_PERIOD)))+"</td>" + "<td>"+(cursor.getString(cursor.getColumnIndex(KEY_MON)))+"</td><td>"+ (cursor.getString(cursor.getColumnIndex(KEY_TUES)))+"</td><td>"+(cursor.getString(cursor.getColumnIndex(KEY_WED)))+"</td>" + "<td>"+(cursor.getString(cursor.getColumnIndex(KEY_THRUS)))+"</td><td>"+(cursor.getString(cursor.getColumnIndex(KEY_FRI)))+"</td></tr>"); cursor.moveToNext(); } mStr.concat("</table></body>"); return mStr; } And this is the part of my WeekDbShow.java class from where i am calling the showMeTable.
String data=myDbHelper.showMeTable(); //showMe.setText("<b>data</b>"); showMe.setText(Html.fromHtml(data)); myDbHelper.close(); here is my xml file.
<?xml version="1.0" encoding="utf-8"?> <LinearLayout android:id="@+id/LinearLayout01" android:layout_width="fill_parent" android:layout_height="fill_parent" android:orientation="vertical" xmlns:android="http://schemas.android.com/apk/res/android"> <TextView android:id="@+id/tvTT" android:layout_width="match_parent" android:layout_height="wrap_content" android:text="Medium Text" android:maxLines = "200" android:scrollbars = "vertical" /> please give me some good solution ,i have all ready tried scrollView in xml.