SQLite database value compare with spinner list item and set that value as first item in spinner
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
add a comment |
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
add a comment |
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
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
android sqlite spinner
edited Nov 13 '18 at 13:28
Yuca
2,7762525
2,7762525
asked Nov 13 '18 at 9:13
SHAMAL KASWATESHAMAL KASWATE
83
83
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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.
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
add a comment |
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.
add a comment |
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.
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.
answered Nov 13 '18 at 10:55
user5607081user5607081
419
419
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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