Good! I have a database created from EditText, and that data I want to take to text views that are contained in TableRow, if you can help me complete it, it would help me a lot, thank you!
Database:
private String sql = "create table eventos(" +
"idHorario int identity,"+
"uno1 varchar(40)," +
"uno2 varchar(40)," +
"uno3 varchar(40)," +
"uno4 varchar(40)," +
"uno5 varchar(40)," +
"dos1 varchar(40)," +
"dos2 varchar(40)," +
"dos3 varchar(40)," +
"dos4 varchar(40)," +
"dos5 varchar(40)," +
"tres1 varchar(40)," +
"tres2 varchar(40)," +
"tres3 varchar(40)," +
"tres4 varchar(40)," +
"tres5 varchar(40)," +
"cuatro1 varchar(40)," +
"cuatro2 varchar(40)," +
"cuatro3 varchar(40)," +
"cuatro4 varchar(40)," +
"cuatro5 varchar(40)," +
"cinco1 varchar(40)," +
"cinco2 varchar(40)," +
"cinco3 varchar(40)," +
"cinco4 varchar(40)," +
"cinco5 varchar(40)," +
"seis1 varchar(40)," +
"seis2 varchar(40)," +
"seis3 varchar(40)," +
"seis4 varchar(40)," +
"seis5 varchar(40)," +
"siete1 varchar(40)," +
"siete2 varchar(40)," +
"siete3 varchar(40)," +
"siete4 varchar(40)," + "siete5 varchar(40))";
public BDSQLite(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
Class schedules:
public class HORARIOActivity extends AppCompatActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_horario);
Button boton =(Button)findViewById(R.id.boton1);
boton.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
Intent i = new Intent(HORARIOActivity.this, Editar.class);
startActivity(i);
}
});
}
Layout table (which has textviews):
<TextView
Android:id=@+id/TXT1
android:layout_width="7dp"
android:layout_height="match_parent"
android:layout_column="1"
android:layout_margin="1dp"
android:background="#FFFFFF"
android:gravity="center"
android:text=""
android:textAppearance="?android:attr/textAppearanceLarge" />
So what I'm looking for is that the data saved in one1, one2, etc (user inputs, in another class, and then stored in the database) can then be seen in TXT1 (see id text view) , in short, display info from the database to the textview, thanks!