i have 150 records in sqlite database i want to display 1 row from database in grid view. user will enter a code in edit text and i want to select record on the basis of that code from the database and display in the gridview. I've used the following method to get data from database but i don't know how to insert values in grid view.
method for getting retrieving data from sqlite public String[][] SelectDocData( String drcode) { // TODO Auto-generated method stub try { String arrData[][] = null; SQLiteDatabase db; db = this.getReadableDatabase(); // Read Data String strSQL = "select * from crm_dr_view where dr_code = drcode" ; Cursor cursor = db.rawQuery(strSQL, null); if(cursor != null) {
if (cursor.moveToFirst()) {
arrData = new String[cursor.getCount()][cursor.getColumnCount()];
int i= 0;
do {
arrData[i][0] = cursor.getString(0);
arrData[i][1] = cursor.getString(1);
arrData[i][2] = cursor.getString(2);
i++;
} while (cursor.moveToNext());
}}
cursor.close();
return arrData;
} catch (Exception e) {
return null;
}
}
public class Attendance_setup extends Activity {
String drCode;
Date currDate;
EditText ed_shift, ed_drcode;
String currentTime;
Button btn_SaveAttendance;
Db_sqlite sqlite;
TextView tv;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.attendance);
sqlite = new Db_sqlite(Attendance_setup.this);
ed_shift = (EditText) findViewById (R.id.shift);
ed_drcode = (EditText)findViewById (R.id.drcode);
btn_SaveAttendance =(Button)findViewById(R.id.button1);
btn_SaveAttendance.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
drCode = ed_drcode.getText().toString();
Log.i("dr code", drCode);
String[][] data = sqlite.SelectDocData(drCode);
final GridView gView1 = (GridView)findViewById(R.id.gridView1);
gView1.setAdapter(new DataAdapter(this));
sqlite.close();
}
});
adapter class
public class DataAdapter extends BaseAdapter{
private Context context;
private String[][] list;
public DataAdapter(Context c, String[][] li)
{
// TODO Auto-generated method stub
context = c;
list = li;
}
public DataAdapter(OnClickListener onClickListener) {
// TODO Auto-generated constructor stub
}
@Override
public int getCount() {
// TODO Auto-generated method stub
return list.length;
}
@Override
public Object getItem(int position) {
// TODO Auto-generated method stub
return position;
}
@Override
public long getItemId(int position) {
// TODO Auto-generated method stub
return position;
}
@Override
public View getView(int arg0, View arg1, ViewGroup arg2) {
// TODO Auto-generated method stub
return null;
}
}
Aucun commentaire:
Enregistrer un commentaire