درخواست سورس یک لیست ویو که کاستوم ادپتر داشته باشه و اطلاعاتش رو از دیتابیس میگیره.

DatabaseHelper:

 package com.adapter;

import java.util.ArrayList;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import com.myclass.AdsStruct;

public class DatabaseHelper extends SQLiteOpenHelper {

	private static final String LOG = DatabaseHelper.class.getName();
	private static final int DB_VERSION = 1;
	private static final String DB_NAME = "database.db";

	private static final String CREATE_TABLE_ADS = "CREATE TABLE Ads (Ads_id integer NOT NULL PRIMARY KEY,"
			+ "Ads_title  nvarchar(100), Ads_des    nvarchar(150),  Ads_pic    varchar(500),  Ads_picType    varchar(8),  Ads_date   varchar(20),  Ads_show   varchar(3),"
			+ "  Ads_url    nvarchar(255), Ads_imageurl_sdcard varchar(100));";



	public DatabaseHelper(Context context) {
		super(context, DB_NAME, null, DB_VERSION);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		try {
			db.execSQL(CREATE_TABLE_ADS);

		} catch (Exception r) {
			r.printStackTrace();
		}
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		db.execSQL("DROP TABLE IF EXISTS Ads");
		onCreate(db);
	}

	public ArrayList<AdsStruct> getAllAds() {
		ArrayList<AdsStruct> adsStructs = new ArrayList<AdsStruct>();
		String selectQuery = "Select * from Ads";
		// Log.e(LOG, selectQuery);
		SQLiteDatabase db = this.getReadableDatabase();
		Cursor c = db.rawQuery(selectQuery, null);
		c.moveToFirst();
		if (c.moveToFirst()) {
			do {
				AdsStruct ads = new AdsStruct();
				ads.setAds_id(c.getInt(c.getColumnIndex("Ads_id")));
				ads.setAds_title(c.getString(c.getColumnIndex("Ads_title")));
				ads.setAds_des(c.getString(c.getColumnIndex("Ads_des")));
				ads.setAds_pic(c.getString(c.getColumnIndex("Ads_pic")));
				ads.setAds_date(c.getString(c.getColumnIndex("Ads_date")));
				ads.setAds_show(c.getString(c.getColumnIndex("Ads_show")));
				ads.setAds_url(c.getString(c.getColumnIndex("Ads_url")));
				ads.setAds_picType(c.getString(c.getColumnIndex("Ads_picType")));
				ads.setAds_imageurl_sdcard(c.getString(c
						.getColumnIndex("Ads_imageurl_sdcard")));
				adsStructs.add(ads);
			} while (c.moveToNext());
		}
		return adsStructs;
	}

	public int getAdsCount() {
		String countQuery = "SELECT Ads_id FROM Ads";
		SQLiteDatabase db = this.getReadableDatabase();
		Cursor cursor = db.rawQuery(countQuery, null);

		int count = cursor.getCount();
		cursor.close();
		return count;
	}

	public String addAds(

	int Ads_id, String Ads_title, String Ads_des, String Ads_pic,
			String Ads_date, String Ads_show, String Ads_url,
			String Ads_picType, String Ads_imageurl_sdcard) {

		String s = "error";
		try {
			SQLiteDatabase db = this.getReadableDatabase();

			ContentValues cv = new ContentValues();
			cv.put("Ads_id", Ads_id);
			cv.put("Ads_title", Ads_title);
			cv.put("Ads_des", Ads_des);
			cv.put("Ads_pic", Ads_pic);
			cv.put("Ads_date", Ads_date);
			cv.put("Ads_show", Ads_show);
			cv.put("Ads_url", Ads_url);
			cv.put("Ads_picType", Ads_picType);
			cv.put("Ads_imageurl_sdcard", Ads_imageurl_sdcard);

			db.insert("Ads", null, cv);
			s = "insert";
		} catch (Exception e) {
			s = "error";
		}
		return s;
	}

	public void closeDB() {
		SQLiteDatabase db = this.getReadableDatabase();
		if (db != null && db.isOpen())
			db.close();
	}

	public boolean CheckIsDataAlreadyInDBorNot(String TableName,
			String dbfield, String fieldValue) {
		SQLiteDatabase sqldb = this.getReadableDatabase();
		String Query = "Select * from " + TableName + " where " + dbfield
				+ " = '" + fieldValue + "'";
		Cursor cursor = sqldb.rawQuery(Query, null);
		if (cursor.getCount() <= 0) {
			cursor.close();
			return false;
		}
		cursor.close();
		return true;
	}

}

کلاس AdsStruct: 

 package com.myclass;

public class AdsStruct {

	int Ads_id;
	String Ads_title;
	String Ads_des;
	String Ads_pic;
	String Ads_picType;
	String Ads_date;
	String Ads_show;
	String Ads_url;
	String Ads_imageurl_sdcard;

	public AdsStruct() {
	}

	public AdsStruct(int ads_id, String ads_title, String ads_des,
			String ads_pic, String ads_picType, String ads_date,
			String ads_show, String ads_url, String ads_imageurl_sdcard) {
		this.Ads_id = ads_id;
		this.Ads_title = ads_title;
		this.Ads_des = ads_des;
		this.Ads_pic = ads_pic;
		this.Ads_picType = ads_picType;
		this.Ads_date = ads_date;
		this.Ads_show = ads_show;
		this.Ads_url = ads_url;
		this.Ads_imageurl_sdcard = ads_imageurl_sdcard;
	}

	public int getAds_id() {
		return Ads_id;
	}

	public void setAds_id(int ads_id) {
		Ads_id = ads_id;
	}

	public String getAds_title() {
		return Ads_title;
	}

	public void setAds_title(String ads_title) {
		Ads_title = ads_title;
	}

	public String getAds_des() {
		return Ads_des;
	}

	public void setAds_des(String ads_des) {
		Ads_des = ads_des;
	}

	public String getAds_pic() {
		return Ads_pic;
	}

	public void setAds_pic(String ads_pic) {
		Ads_pic = ads_pic;
	}

	public String getAds_picType() {
		return Ads_picType;
	}

	public void setAds_picType(String ads_picType) {
		Ads_picType = ads_picType;
	}

	public String getAds_date() {
		return Ads_date;
	}

	public void setAds_date(String ads_date) {
		Ads_date = ads_date;
	}

	public String getAds_show() {
		return Ads_show;
	}

	public void setAds_show(String ads_show) {
		Ads_show = ads_show;
	}

	public String getAds_url() {
		return Ads_url;
	}

	public void setAds_url(String ads_url) {
		Ads_url = ads_url;
	}

	public String getAds_imageurl_sdcard() {
		return Ads_imageurl_sdcard;
	}

	public void setAds_imageurl_sdcard(String ads_imageurl_sdcard) {
		Ads_imageurl_sdcard = ads_imageurl_sdcard;
	}

}

داخل کلاس G:

 public static ArrayList<AdsStruct> AdsList = new ArrayList<AdsStruct>();
	public static SQLiteDatabase database;
	public static DatabaseHelper dbHelper;

	@Override
	public void onCreate() {
		super.onCreate();
		dbHelper = new DatabaseHelper(context);
		database = dbHelper.getWritableDatabase();
	
} 

هر جا می خوای بخونی بنویس:

 		G.AdsList.clear();
		G.AdsList.addAll(G.dbHelper.getAllAds());

		Ads_Adapter = new AdapterKala(this, G.AdsList);