sqlit dba access my user info in taxt view

Question

hey i want set user data in next screen in perticuler textview when i search record by clicking button.....so how can i creat that code??? i have already creat data table in first activity....now i want set all data step by step in perticuler feild.

Manikandan Murugesan · Answer

I would save username to sharedpreferences because app will have only one user you don't need to save just one entry to your database. But if you insist on getting it from database then add this function to your DatabaseHelper. public String getUsername() throws SQLException { String username =  ; Cursor cursor = this .getReadableDatabase().query( TABLE_NAME new String[] { KEY_NAME } null  null  null  null  null ); if (cursor.moveToFirst()) { do { username = cursor.getString( 0 ); } while (cursor.moveToNext()); } cursor.close(); return username; } and later you can use this code to get username in your drawer activity: textView.setText(helper.getUsername()); P.S. you should really really refactor your code. And use SharedPreferences instead of SQLite for storing single values. SQLite is designed to store massive data containers like cached list data and so on.