TableLayout with SQLite
I need to display data in tabletLayout from SQLite. The SQLite response is correct, the data is correct, I add them correct but it does not list them. It shows me only one :
TableLAyout.xml :
<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:app="http://schemas.android.com/apk/res-auto"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".Views.MarcadoXLoteActivity">
<Spinner
android:id="@+id/spinner3"
android:layout_width="105dp"
android:background="@drawable/green_border"
android:layout_height="36dp"
android:layout_marginTop="8dp"
app:layout_constraintStart_toStartOf="@+id/textView73"
app:layout_constraintTop_toBottomOf="@+id/textView73" />
<ImageView
android:id="@+id/imageView26x"
android:layout_width="33dp"
android:layout_height="46dp"
android:layout_marginStart="-34dp"
app:layout_constraintBottom_toBottomOf="@+id/spinner3"
app:layout_constraintStart_toEndOf="@+id/spinner3"
app:layout_constraintTop_toTopOf="@+id/spinner3"
app:srcCompat="@drawable/baseline_arrow_drop_down_24" />
<androidx.appcompat.widget.Toolbar
android:id="@+id/toolbarM"
android:layout_width="0dp"
android:layout_height="wrap_content"
android:background="@color/white"
android:minHeight="?attr/actionBarSize"
android:theme="?attr/actionBarTheme"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent"
app:subtitleTextColor="@color/white"
app:title=" Marcado de Avances Por Lote"
app:titleTextAppearance="@style/TextAppearance.AppCompat.Display1"
app:titleTextColor="@color/black">
</androidx.appcompat.widget.Toolbar>
<androidx.cardview.widget.CardView
android:id="@+id/cardView2"
android:layout_width="798dp"
android:layout_height="wrap_content"
android:layout_marginStart="1dp"
android:layout_marginTop="32dp"
android:layout_marginEnd="1dp"
app:cardBackgroundColor="#DEF1DE"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toBottomOf="@+id/toolbarM">
<TextView
android:id="@+id/tvNomMarcado"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:text=" CIMENTACION"
android:textColor="#11B818"
android:textSize="24sp"
android:textStyle="bold|italic" />
</androidx.cardview.widget.CardView>
<TextView
android:id="@+id/textView72"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginStart="80dp"
android:layout_marginTop="24dp"
android:text="Manzana"
android:textColor="#000000"
android:textSize="16sp"
app:layout_constraintStart_toStartOf="@+id/cardView2"
app:layout_constraintTop_toBottomOf="@+id/cardView2" />
<TextView
android:id="@+id/textView73"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginTop="24dp"
android:layout_marginEnd="220dp"
android:text="Rango de Lotes"
android:textColor="#000000"
android:textSize="16sp"
app:layout_constraintEnd_toEndOf="@+id/cardView2"
app:layout_constraintTop_toBottomOf="@+id/cardView2" />
<Spinner
android:id="@+id/spinnerMan"
android:layout_width="206dp"
android:layout_height="36dp"
android:layout_marginTop="8dp"
android:background="@drawable/green_border"
app:layout_constraintStart_toStartOf="@+id/textView72"
app:layout_constraintTop_toBottomOf="@+id/textView72" />
<ImageView
android:id="@+id/imageView26"
android:layout_width="33dp"
android:layout_height="46dp"
android:layout_marginStart="-34dp"
app:layout_constraintBottom_toBottomOf="@+id/spinnerMan"
app:layout_constraintStart_toEndOf="@+id/spinnerMan"
app:layout_constraintTop_toTopOf="@+id/spinnerMan"
app:srcCompat="@drawable/baseline_arrow_drop_down_24" />
<TableLayout
android:id="@+id/tlMarcado"
android:layout_width="700dp"
android:layout_height="789dp"
android:layout_marginStart="16dp"
android:layout_marginTop="8dp"
android:layout_marginEnd="16dp"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toBottomOf="@+id/spinner3">
<TableRow
android:background="#51B435"
android:padding="10dp">
<TextView
android:layout_width="120dp"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:gravity="center"
android:text="DESCRIPCIÓN"
android:textColor="@color/white" />
<TextView
android:layout_width="78dp"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:singleLine="false"
android:text="PRECIO
CONTRATISTA"
android:textColor="@color/white" />
<TextView
android:id="@+id/tvTarjetaML"
android:layout_width="wrap_content"
android:layout_height="36dp"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:text="015004001"
android:textColor="@color/white" />
<TextView
android:layout_width="wrap_content"
android:layout_height="36dp"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:text="015004001"
android:textColor="@color/white" />
<TextView
android:layout_width="wrap_content"
android:layout_height="36dp"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:text="015004001"
android:textColor="@color/white" />
<TextView
android:layout_width="wrap_content"
android:layout_height="36dp"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:text="015004001"
android:textColor="@color/white" />
<TextView
android:layout_width="wrap_content"
android:layout_height="36dp"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:text="015004001"
android:textColor="@color/white" />
</TableRow>
<TableRow
android:background="#F0F7F7"
android:padding="5dp">
<TextView
android:id="@+id/tvDescML"
android:layout_width="120dp"
android:layout_height="55dp"
android:layout_gravity="center"
android:background="@drawable/tableborder"
android:gravity="center"
android:text="FAB. DE REGISTRO PLUBIAL" />
<TextView
android:id="@+id/tvPrecioML"
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_gravity="center"
android:layout_weight="1"
android:background="@drawable/tableborder"
android:gravity="center"
android:text=" $129.00" />
<TextView
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_weight="1"
android:background="@color/blueM"
android:padding="6dp" />
<TextView
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_weight="1"
android:background="@color/blueM"
android:padding="6dp" />
<TextView
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_weight="1"
android:background="@color/blueM"
android:padding="6dp" />
<TextView
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_weight="1"
android:background="@color/blueM"
android:padding="6dp" />
<TextView
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_weight="1"
android:background="#2A42C6"
android:padding="6dp" />
</TableRow>
<TableRow
android:background="#F0F7F7"
android:padding="5dp"/>
<TableRow
android:background="#F0F7F7"
android:padding="6dp"/>
<TableRow
android:layout_width="match_parent"
android:layout_height="match_parent" />
<TableRow
android:layout_width="match_parent"
android:layout_height="match_parent" />
<TableRow
android:layout_width="match_parent"
android:layout_height="match_parent" />
<TableRow
android:layout_width="match_parent"
android:layout_height="match_parent" />
</TableLayout>
<Button
android:id="@+id/btnguardarmercado"
android:layout_width="562dp"
android:layout_height="72dp"
android:layout_marginStart="352dp"
android:layout_marginTop="30dp"
android:layout_marginEnd="352dp"
android:background="@drawable/btn_gray"
android:text="GUARDAR AVANCE"
android:textSize="30sp"
app:backgroundTint="@null"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toBottomOf="@+id/tlMarcado" />
<Spinner
android:id="@+id/spinner4"
android:layout_width="105dp"
android:layout_height="36dp"
android:layout_marginStart="16dp"
android:background="@drawable/green_border"
app:layout_constraintStart_toEndOf="@+id/textView71"
app:layout_constraintTop_toTopOf="@+id/spinner3" />
<ImageView
android:id="@+id/imageView88"
android:layout_width="33dp"
android:layout_height="46dp"
android:layout_marginStart="-34dp"
app:layout_constraintBottom_toBottomOf="@+id/spinner4"
app:layout_constraintStart_toEndOf="@+id/spinner4"
app:layout_constraintTop_toTopOf="@+id/spinner4"
app:srcCompat="@drawable/baseline_arrow_drop_down_24" />
<TextView
android:id="@+id/textView71"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginStart="7dp"
android:text="Al"
android:textColor="#040404"
android:textSize="20sp"
app:layout_constraintBottom_toBottomOf="@+id/spinner3"
app:layout_constraintStart_toEndOf="@+id/spinner3"
app:layout_constraintTop_toBottomOf="@+id/textView73" />
</androidx.constraintlayout.widget.ConstraintLayout>
Kotlin code:
private fun llenartabla() {
val tableLayout = findViewById<TableLayout>(R.id.tlMarcado)
val obraS = SharedApp.prefs.obra
val obraSt = obraS.toString()
val dbHelper = DBHandler(this)
val db = dbHelper.readableDatabase
val cursor: Cursor = db.rawQuery("select distinct dstarjeta, insumo, cantidad, precio_insumo, lote, manzana, id_detalle_kontrol from ActividadesM where obra = '" + obraSt + "'", null)
cursor.moveToFirst()
do{
val a = TableRow(this)
a.layoutParams = TableRow.LayoutParams(TableRow.LayoutParams.WRAP_CONTENT, TableRow.LayoutParams.WRAP_CONTENT)
val tvCodigo = tableLayout.findViewById<View>(R.id.tvDescML) as TextView
tvCodigo.text = cursor.getString(0)
if (tvCodigo.getParent() != null) {
(tvCodigo.getParent() as ViewGroup).removeView(tvCodigo) // <- fix
}
a.addView(tvCodigo)
val tvDescripcion = tableLayout.findViewById<View>(R.id.tvTarjetaML) as TextView
tvDescripcion.text = cursor.getString(6)
if (tvDescripcion.getParent() != null) {
(tvDescripcion.getParent() as ViewGroup).removeView(tvDescripcion) // <- fix
}
a.addView(tvDescripcion)
val tvPrecio = tableLayout.findViewById<View>(R.id.tvPrecioML) as TextView
tvPrecio.text = cursor.getString(2)
if (tvPrecio.getParent() != null) {
(tvPrecio.getParent() as ViewGroup).removeView(tvPrecio) // <- fix
}
a.addView(tvPrecio)
tableLayout.addView(a)
}while (cursor.moveToNext()) }
I can't get it to work:
Solution
I would also recommend to use "RecyclerView". But in case if you need to use the tablelayout, please consider following
I created a sample app based on your issue.
a) Update the table TableLayout as follows
<?xml version="1.0" encoding="utf-8"?>
<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical"
tools:context=".sobounty.SoBountctivity">
<TableLayout
android:id="@+id/test_table"
android:layout_width="match_parent"
android:layout_height="wrap_content">
<TableRow
android:background="#51B435"
android:padding="10dp">
<TextView
android:layout_width="120dp"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:gravity="center"
android:text="DESCRIPCIÓN"
android:textColor="@color/white" />
<TextView
android:layout_width="78dp"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:singleLine="false"
android:text="PRECIO
CONTRATISTA"
android:textColor="@color/white" />
<TextView
android:id="@+id/tvTarjetaML"
android:layout_width="wrap_content"
android:layout_height="36dp"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:text="015004001"
android:textColor="@color/white" />
<TextView
android:layout_width="wrap_content"
android:layout_height="36dp"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:text="015004001"
android:textColor="@color/white" />
<TextView
android:layout_width="wrap_content"
android:layout_height="36dp"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:text="015004001"
android:textColor="@color/white" />
<TextView
android:layout_width="wrap_content"
android:layout_height="36dp"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:text="015004001"
android:textColor="@color/white" />
<TextView
android:layout_width="wrap_content"
android:layout_height="36dp"
android:layout_gravity="center"
android:layout_weight="0.5"
android:gravity="center"
android:text="015004001"
android:textColor="@color/white" />
</TableRow>
</TableLayout>
I am using it as layout so, I used ScrollView as root container.
b) Create a second layout file (table_row_layout)as follows (add your styles etc in it, I have removed few of them to make things simple). This contains the row views.
<?xml version="1.0" encoding="utf-8"?>
<TableRow xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent">
<TextView
android:id="@+id/tvDescML"
android:layout_width="120dp"
android:layout_height="55dp"
android:layout_gravity="center"
android:gravity="center"
android:text="FAB. DE REGISTRO PLUBIAL" />
<TextView
android:id="@+id/tvPrecioML"
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_gravity="center"
android:layout_weight="1"
android:gravity="center"
android:text=" $129.00" />
<TextView
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_weight="1"
android:padding="6dp" />
<TextView
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_weight="1"
android:padding="6dp" />
<TextView
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_weight="1"
android:padding="6dp" />
<TextView
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_weight="1"
android:padding="6dp" />
<TextView
android:layout_width="wrap_content"
android:layout_height="60dp"
android:layout_weight="1"
android:background="#2A42C6"
android:padding="6dp" />
</TableRow>
c) Activity code (Adjust the logic as per your need) Here, we will inflate the table_row_layout and then add it to the viewgroup
class SoBountctivity : AppCompatActivity() {
override fun onCreate(savedInstanceState: Bundle?) {
super.onCreate(savedInstanceState)
setContentView(R.layout.activity_so_bountctivity)
// tableLayout i which we want to insert view
val tableLayout = findViewById<TableLayout>(R.id.test_table)
// Fake data
val fruitList = returnFruitList()
// layoutInflater
val layoutInflater = layoutInflater
// Your cursor can replace the forEach. Looping over the data
fruitList.forEach {
// Get the new row_layout
val view = layoutInflater.inflate(R.layout.table_row_layout, tableLayout, false)
// Get the views in which you want to add the data
val textView = view.findViewById<TextView>(R.id.tvDescML)
// Set the data
textView.text = it
// Add the row view in tableLayout
tableLayout.addView(view)
}
for (rowIndex in 0 until tableLayout.childCount) {
val rowView: TableRow = tableLayout.getChildAt(rowIndex) as TableRow
for (colIndex in 0 until rowView.childCount) {
val view = rowView.getChildAt(colIndex)
view.setOnClickListener {
// For listeners.
onTableCellClicked(rowIndex, colIndex)
}
}
}
}
private fun returnFruitList() = listOf("Apple", "Banana", "Pineapple", "Guava", "Berries", "JackFruit", "Tomato", "Papaya")
private fun onTableCellClicked(rowIndex: Int, colIndex: Int) {
Toast.makeText(this, "I AM CLICKED row $rowIndex col $colIndex", Toast.LENGTH_SHORT).show()
}
}
However I too would take note of the comment left by @marcpetitvecino on the question. Using RecyclerView is a better approach, as it is very flexible, memory efficient, has smooth scrolling as it recycles / reuses views and is very modular / customisable.
Result :
- Finding Android SDK on Mac and adding to PATH
- Prompt Android App User to Update App if current version <> market version
- How to integrate Stripe Payment in Android Java?
- Type 'TypeVariable(T)' has no method 'getValue(Nothing?, KProperty<*>)' and thus it cannot serve as a delegate
- In version catalog libs I get false errors you can only call the 'from' method a single time
- Android: When app was opened with click on notification, clicking on further notifications only opens the app, not changing activity
- Applying Flutters app_plugin_loader Gradle plugin imperatively using the apply script method which is deprecated, will be removed in a future release
- ContentResolver.takePersistableUriPermission: SecurityException No persistable permission grants found for UID 10434 and Uri content:/
- App crashes when changing activities
- Android Studio emulator does not have internet
- A failure occurred while executing com.android.build.gradle.internal.tasks.FinalizeBundleTask$BundleToolRunnable
- Android Material Text Input Layout End Icon Not Showing
- Is there a way to keep fragment alive when using BottomNavigationView with new NavController?
- Testing a Composable with assertTextEquals() fails with IllegalStateException
- W/ManagedChannelImpl: [{0}] Failed to resolve name. status={1}
- java.lang.IllegalAccessError: class org.jetbrains.kotlin.kapt3.base.KaptContext Android
- build.gradle error: Could not create tastk ':generateLockfiles'. in Flutter project but App is running normal
- Exception during working with external system: java.lang.AssertionError in Android Studio Dolphin | 2021.3.1
- BaseFragment with viewbinding
- How to extract labels.txt file from tflite file?
- Validation allow only number and characters in edit text in android
- X and Y offset, blur, opacity and colour of shadow in Jetpack Compose?
- Can you pass NavHostController to a child Composable in order to allow access to the navController.navigate("Route")?
- Error building Android library: Direct local .aar file dependencies are not supported
- Layout (Cardview) overlapping below Status bar
- adb shell Logcat with Package Name
- How to get rid of the bottom border of the React Native Paper TextInput when focused
- Issues with android minify after Flutter update 3.22
- Flutter build Appbundle Error:* What went wrong: A problem occurred evaluating project ':app'
- Room - Schema export directory is not provided to the annotation processor so we cannot export the schema