mercredi 7 janvier 2015

android: how to fetch data from sqlite and display in gridview

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