public List <Question> getAllQuestions() { List <Question> quesList = new List <Question>(); // Select All Query string selectQuery = "SELECT * FROM " + TABLE_QUEST; dbase = this.ReadableDatabase; Cursor cursor = dbase.RawQuery(selectQuery, null); // looping through all rows and adding to list if (cursor.MoveToFirst()) { do { Question quest = new Question(); quest.setID(cursor.GetInt(0)); quest.setQUESTION(cursor.GetString(1)); quest.setANSWER(cursor.GetString(2)); quest.setOPTA(cursor.GetString(3)); quest.setOPTB(cursor.GetString(4)); quest.setOPTC(cursor.GetString(5)); quesList.Add(quest); } while (cursor.MoveToNext()); } // return quest list return(quesList); }
public static string GetRealPathFromURI(Android.Net.Uri contentUri) { var mediaStoreImagesMediaData = "_data"; string[] projection = { mediaStoreImagesMediaData }; Android.Database.ICursor cursor = Application.Context.ContentResolver.Query(contentUri, projection, null, null, null); int columnIndex = cursor.GetColumnIndexOrThrow(mediaStoreImagesMediaData); cursor.MoveToFirst(); return(cursor.GetString(columnIndex)); //ContentResolver cr = Application.Context.ContentResolver; //Android.Net.Uri uri = MediaStore.Files.GetContentUri("external"); //// every column, although that is huge waste, you probably need //// BaseColumns.DATA (the path) only. //String[] projection = null; //// exclude media files, they would be here also. //String selection = MediaStore.Files.FileColumns.MediaType + "=" // + Android.po; //String[] selectionArgs = null; // there is no ? in selection so null here //String sortOrder = null; // unordered //Cursor allNonMediaFiles = cr.query(uri, projection, selection, selectionArgs, sortOrder); }
public override View NewView(Context context, Android.Database.ICursor cursor, ViewGroup parent) { LayoutInflater inflater = LayoutInflater.From(context); TextView view = (TextView)inflater.Inflate( Android.Resource.Layout.SimpleDropDownItem1Line, parent, false); view.Text = cursor.GetString(COLUMN_DISPLAY_NAME); return(view); }
public List <EntCallLog> getCallLog(string queryFilter, string querySorter) { //string queryFilter = System.String.Format("{0}={1}", log.Calls.Date, dt.Ticks); // string querySorter = System.String.Format("{0} desc limit 100 ", log.Calls.Date); Android.Database.ICursor queryData = Application.Context.ContentResolver.Query(log.Calls.ContentUri, null, queryFilter, null, querySorter); List <EntCallLog> lstRecentCalls = new List <EntCallLog>(); while (queryData.MoveToNext()) { EntCallLog ent = new EntCallLog(); ent.numero = queryData.GetString(queryData.GetColumnIndex(log.Calls.Number)); ent.tipo = (Android.Provider.CallType)queryData.GetInt(queryData.GetColumnIndex(log.Calls.Type)); ent.nombre = queryData.GetString(queryData.GetColumnIndex(log.Calls.CachedName)); ent.duracion = queryData.GetInt(queryData.GetColumnIndex(log.Calls.Duration)); ent.fecha = DateTime.Parse(new Java.Sql.Date(queryData.GetLong(queryData.GetColumnIndex(log.Calls.Date))).ToString()); ent.imageUri = queryData.GetString(queryData.GetColumnIndex(log.Calls.CachedPhotoUri)); lstRecentCalls.Add(ent); } return(lstRecentCalls); }
public String getRealPathFromURI(Android.Net.Uri contentUri) { var mediaStoreImagesMediaData = "_data"; string[] projection = { mediaStoreImagesMediaData }; Android.Database.ICursor cursor = this.ContentResolver.Query(contentUri, projection, null, null, null); int columnIndex = cursor.GetColumnIndexOrThrow(mediaStoreImagesMediaData); cursor.MoveToFirst(); return(cursor.GetString(columnIndex)); }
public override void BindView(View view, Context context, Android.Database.ICursor cursor) { ((TextView)view).Text = cursor.GetString(COLUMN_DISPLAY_NAME); }