Skip to main content

Code Snippet

From any Java class  cal DataBase by using the following code :


context = this;
dbutil = new DbUtil(context);
dbutil.open();


To set Database value into the Spinner through ArrayList:

Spinner spnCatname;

ArrayList<String> array = dbutil.getcategoryname();
ArrayAdapter<String> spinnerArray = new ArrayAdapter<String>(context,R.layout.spinner_text,                                                                                                                                         array);
spnCatname.setAdapter(spinnerArray);



How to call database value using Cursor?   // Nested Cursor

Cursor cur = dbutil.getProductName(data);  // Using Parameter
if (cur != null && cur.moveToFirst()) {
    cur.moveToFirst();
    String Catid = cur.getString(cur.getColumnIndex(DbHelper.CATEGORY_CODE_FIELD));
    dbutil.open();
  Cursor spincur = dbutil.getCatgoryname(Catid);
    if (spincur.moveToFirst() && spincur != null) {
        spincur.moveToFirst();
        String CatSpinId = spincur.getString(spincur.getColumnIndex(DbHelper.CATEGORY_NAME));
int id = array.indexOf(CatSpinId);  // Getting item Id of spinner selected data
        spnCatname.setSelection(id);  //Set it into Spinner
    }
}


How to insert & update values into DataBase?


dbutil.addproduct(pid, pname, categoryid, img);  // Insert
dbutil.updateCode(DbHelper.PRODUCT_ID_FIELD,pid); // Update


Need to get Phone Number:

 TelephonyManager tMgr = (TelephonyManager) context.getSystemService(Context.TELEPHONY_SERVICE);
 String mPhoneNumber = tMgr.getLine1Number();













Comments

Post a Comment

Popular posts from this blog

SearchView using CursorAdapter

Here  MYFRAGMENT is nothing but name of  a Fragment @Override public void onCreateOptionsMenu (Menu menu, MenuInflater inflater) {     inflater.inflate(R.menu.popup, menu);     final SearchManager searchManager = (SearchManager) getActivity().getSystemService(Context.SEARCH_SERVICE);     final SearchView searchView = (SearchView) menu.findItem(R.id.action_search).getActionView();     searchView.setSearchableInfo(searchManager.getSearchableInfo(getActivity().getComponentName()));     searchView.setSubmitButtonEnabled(false);     searchView.setIconifiedByDefault(true);     //       searchView.setOnCloseListener(this);     SearchView. OnQueryTextListener textChangeListener = new SearchView. OnQueryTextListener () {         @Override         public boolean onQueryTextSubmit(String query) {             cartAdapt...
1 comment
Read more

Fragment

To enable/disable menu items in Different fragments in same Activity: @Override public void onCreate(@Nullable Bundle savedInstanceState)  {     super.onCreate(savedInstanceState);     setHasOptionsMenu(true);  } @Override public void onPrepareOptionsMenu(Menu menu) {     //Disable the SearchView which is enabled in Product Chart     menu.findItem(R.id.action_search).setVisible(false);   // true to enable } ====================================================
Post a Comment
Read more

To make a ListView to be scrolled inside of ScrollView

To make a ListView to be scrolled inside of ScrollView: lv . setOnTouchListener ( new ListView . OnTouchListener () { @Override public boolean onTouch ( View v , MotionEvent event ) { int action = event . getAction (); switch ( action ) { case MotionEvent . ACTION_DOWN : // Disallow ScrollView to intercept touch events. v . getParent (). requestDisallowInterceptTouchEvent ( true ); break ; case MotionEvent . ACTION_UP : // Allow ScrollView to intercept touch events. v . getParent (). requestDisallowInterceptTouchEvent ( false ); break ; } // Handle ListView touch events. v . onTouchEvent ( event ); return true ; } }); Refer: http://stackoverflow.com/questions/6210895/listview-inside-scrollview-is-not-scrolling-on-android
Post a Comment
Read more