SQLite database value compare with spinner list item and set that value as first item in spinner










0















Customer name is stored in the SQLite database table. I need to compare that customer name with spinner item list. If that name matches in spinner list, then start the list from that name.
Thanks in advance !!!










share|improve this question




























    0















    Customer name is stored in the SQLite database table. I need to compare that customer name with spinner item list. If that name matches in spinner list, then start the list from that name.
    Thanks in advance !!!










    share|improve this question


























      0












      0








      0








      Customer name is stored in the SQLite database table. I need to compare that customer name with spinner item list. If that name matches in spinner list, then start the list from that name.
      Thanks in advance !!!










      share|improve this question
















      Customer name is stored in the SQLite database table. I need to compare that customer name with spinner item list. If that name matches in spinner list, then start the list from that name.
      Thanks in advance !!!







      android sqlite spinner






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 13 '18 at 13:28









      Yuca

      2,7762525




      2,7762525










      asked Nov 13 '18 at 9:13









      SHAMAL KASWATESHAMAL KASWATE

      83




      83






















          1 Answer
          1






          active

          oldest

          votes


















          0














          try this,
          java



          public class Main2Activity extends AppCompatActivity 
          Spinner spinner;
          ArrayList<String> spinner_arr = new ArrayList<>();
          ArrayAdapter aa;
          @Override
          protected void onCreate(Bundle savedInstanceState)
          super.onCreate(savedInstanceState);
          setContentView(R.layout.activity_main2);
          spinner_arr.add("John");
          spinner_arr.add("Tom");
          spinner_arr.add("Kelly");
          spinner_arr.add("Sandy");

          spinner = findViewById(R.id.spinner);
          aa = new ArrayAdapter(this, android.R.layout.simple_list_item_1, spinner_arr);
          spinner.setAdapter(aa);



          //check customer name is available in sqlite db
          public void compareClick(View view)
          //fetch sqlite data here(like customer name),suppose customer name is 'Tom'
          String db_cust_name = "Tom";
          for (int i = 0; i < spinner_arr.size(); i++)
          if (db_cust_name.equals(spinner_arr.get(i)))
          spinner_arr.subList(0, i).clear();
          aa.notifyDataSetChanged();





          xml



          <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
          xmlns:tools="http://schemas.android.com/tools"
          android:layout_width="match_parent"
          android:layout_height="match_parent"
          android:gravity="center"
          android:orientation="vertical">

          <Spinner
          android:id="@+id/spinner"
          android:layout_width="match_parent"
          android:layout_height="wrap_content"
          android:layout_margin="5dp"/>


          <Button
          android:onClick="compareClick"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:text="Compare" />




          let me know if you need more clarification.






          share|improve this answer






















            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53277490%2fsqlite-database-value-compare-with-spinner-list-item-and-set-that-value-as-first%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            try this,
            java



            public class Main2Activity extends AppCompatActivity 
            Spinner spinner;
            ArrayList<String> spinner_arr = new ArrayList<>();
            ArrayAdapter aa;
            @Override
            protected void onCreate(Bundle savedInstanceState)
            super.onCreate(savedInstanceState);
            setContentView(R.layout.activity_main2);
            spinner_arr.add("John");
            spinner_arr.add("Tom");
            spinner_arr.add("Kelly");
            spinner_arr.add("Sandy");

            spinner = findViewById(R.id.spinner);
            aa = new ArrayAdapter(this, android.R.layout.simple_list_item_1, spinner_arr);
            spinner.setAdapter(aa);



            //check customer name is available in sqlite db
            public void compareClick(View view)
            //fetch sqlite data here(like customer name),suppose customer name is 'Tom'
            String db_cust_name = "Tom";
            for (int i = 0; i < spinner_arr.size(); i++)
            if (db_cust_name.equals(spinner_arr.get(i)))
            spinner_arr.subList(0, i).clear();
            aa.notifyDataSetChanged();





            xml



            <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
            xmlns:tools="http://schemas.android.com/tools"
            android:layout_width="match_parent"
            android:layout_height="match_parent"
            android:gravity="center"
            android:orientation="vertical">

            <Spinner
            android:id="@+id/spinner"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:layout_margin="5dp"/>


            <Button
            android:onClick="compareClick"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="Compare" />




            let me know if you need more clarification.






            share|improve this answer



























              0














              try this,
              java



              public class Main2Activity extends AppCompatActivity 
              Spinner spinner;
              ArrayList<String> spinner_arr = new ArrayList<>();
              ArrayAdapter aa;
              @Override
              protected void onCreate(Bundle savedInstanceState)
              super.onCreate(savedInstanceState);
              setContentView(R.layout.activity_main2);
              spinner_arr.add("John");
              spinner_arr.add("Tom");
              spinner_arr.add("Kelly");
              spinner_arr.add("Sandy");

              spinner = findViewById(R.id.spinner);
              aa = new ArrayAdapter(this, android.R.layout.simple_list_item_1, spinner_arr);
              spinner.setAdapter(aa);



              //check customer name is available in sqlite db
              public void compareClick(View view)
              //fetch sqlite data here(like customer name),suppose customer name is 'Tom'
              String db_cust_name = "Tom";
              for (int i = 0; i < spinner_arr.size(); i++)
              if (db_cust_name.equals(spinner_arr.get(i)))
              spinner_arr.subList(0, i).clear();
              aa.notifyDataSetChanged();





              xml



              <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
              xmlns:tools="http://schemas.android.com/tools"
              android:layout_width="match_parent"
              android:layout_height="match_parent"
              android:gravity="center"
              android:orientation="vertical">

              <Spinner
              android:id="@+id/spinner"
              android:layout_width="match_parent"
              android:layout_height="wrap_content"
              android:layout_margin="5dp"/>


              <Button
              android:onClick="compareClick"
              android:layout_width="wrap_content"
              android:layout_height="wrap_content"
              android:text="Compare" />




              let me know if you need more clarification.






              share|improve this answer

























                0












                0








                0







                try this,
                java



                public class Main2Activity extends AppCompatActivity 
                Spinner spinner;
                ArrayList<String> spinner_arr = new ArrayList<>();
                ArrayAdapter aa;
                @Override
                protected void onCreate(Bundle savedInstanceState)
                super.onCreate(savedInstanceState);
                setContentView(R.layout.activity_main2);
                spinner_arr.add("John");
                spinner_arr.add("Tom");
                spinner_arr.add("Kelly");
                spinner_arr.add("Sandy");

                spinner = findViewById(R.id.spinner);
                aa = new ArrayAdapter(this, android.R.layout.simple_list_item_1, spinner_arr);
                spinner.setAdapter(aa);



                //check customer name is available in sqlite db
                public void compareClick(View view)
                //fetch sqlite data here(like customer name),suppose customer name is 'Tom'
                String db_cust_name = "Tom";
                for (int i = 0; i < spinner_arr.size(); i++)
                if (db_cust_name.equals(spinner_arr.get(i)))
                spinner_arr.subList(0, i).clear();
                aa.notifyDataSetChanged();





                xml



                <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
                xmlns:tools="http://schemas.android.com/tools"
                android:layout_width="match_parent"
                android:layout_height="match_parent"
                android:gravity="center"
                android:orientation="vertical">

                <Spinner
                android:id="@+id/spinner"
                android:layout_width="match_parent"
                android:layout_height="wrap_content"
                android:layout_margin="5dp"/>


                <Button
                android:onClick="compareClick"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:text="Compare" />




                let me know if you need more clarification.






                share|improve this answer













                try this,
                java



                public class Main2Activity extends AppCompatActivity 
                Spinner spinner;
                ArrayList<String> spinner_arr = new ArrayList<>();
                ArrayAdapter aa;
                @Override
                protected void onCreate(Bundle savedInstanceState)
                super.onCreate(savedInstanceState);
                setContentView(R.layout.activity_main2);
                spinner_arr.add("John");
                spinner_arr.add("Tom");
                spinner_arr.add("Kelly");
                spinner_arr.add("Sandy");

                spinner = findViewById(R.id.spinner);
                aa = new ArrayAdapter(this, android.R.layout.simple_list_item_1, spinner_arr);
                spinner.setAdapter(aa);



                //check customer name is available in sqlite db
                public void compareClick(View view)
                //fetch sqlite data here(like customer name),suppose customer name is 'Tom'
                String db_cust_name = "Tom";
                for (int i = 0; i < spinner_arr.size(); i++)
                if (db_cust_name.equals(spinner_arr.get(i)))
                spinner_arr.subList(0, i).clear();
                aa.notifyDataSetChanged();





                xml



                <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
                xmlns:tools="http://schemas.android.com/tools"
                android:layout_width="match_parent"
                android:layout_height="match_parent"
                android:gravity="center"
                android:orientation="vertical">

                <Spinner
                android:id="@+id/spinner"
                android:layout_width="match_parent"
                android:layout_height="wrap_content"
                android:layout_margin="5dp"/>


                <Button
                android:onClick="compareClick"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:text="Compare" />




                let me know if you need more clarification.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 13 '18 at 10:55









                user5607081user5607081

                419




                419



























                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53277490%2fsqlite-database-value-compare-with-spinner-list-item-and-set-that-value-as-first%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    這個網誌中的熱門文章

                    Barbados

                    How to read a connectionString WITH PROVIDER in .NET Core?

                    Node.js Script on GitHub Pages or Amazon S3