I Want To List All Tables in sqlite database table, When i tries to List the table contents It Only Shows the First columns of table. AXML Page:; "http://schemas.android.com/apk/res/android" android:orientation= "vertical" android:layout_width= "match_parent" android:layout_height= "match_parent" > android:layout_width= "fill_parent" android:layout_height= "wrap_content" android:layout_marginTop= "0dp" android:clickable= "true" android:divider= "#b5b5b5" android:dividerHeight= "1dp" android:id= "@+id/listView1" /> ANd CS Page string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "BookmarkSqlite.db3" ); var db = new SQLiteConnection(dpPath); var data = db.Table (); foreach (var listing in data) { var from = new string[]{ listing.SiteName + "----" + listing.SiteUrl }; //var from = fromm.ToList(); ListView listtable = (ListView)FindViewById(Resource.Id.listView1); listtable.Adapter = new ArrayAdapter( this , Android.Resource.Layout.SimpleListItem1, from); } } i tried ToList on from,but it also not works listtable.Adapter = new ArrayAdapter( this , Android.Resource.Layout.SimpleListItem1, from.ToList());

@sathis Good day Understand this article, https://www.c-sharpcorner.com/article/create-android-insert-select-update-and-delete-using-sqlite-database/ Thank you :)

Answer

List sqlite database Table in xamarin.android

sathish v

1.5k

I Want To List All Tables in sqlite database table,

When i tries to List the table contents It Only Shows the First columns of table.

AXML Page:;

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical"
android:layout_width="match_parent"
android:layout_height="match_parent">
<ListView
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:layout_marginTop="0dp"
android:clickable="true"
android:divider="#b5b5b5"
android:dividerHeight="1dp"
android:id="@+id/listView1" />

ANd CS Page

string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "BookmarkSqlite.db3");
var db = new SQLiteConnection(dpPath);
var data = db.Table<BookmarkSqliteTable>();
foreach (var listing in data)
{ var from = new string[]{ listing.SiteName + "----" + listing.SiteUrl };
//var from = fromm.ToList();
ListView listtable = (ListView)FindViewById(Resource.Id.listView1);
listtable.Adapter = new ArrayAdapter(this, Android.Resource.Layout.SimpleListItem1, from);
}
}

i tried ToList on from,but it also not works