hi,its glad to tell i saved spinner value(courseNumbers) in database with ur
assistance code...but when i click on retreive button now i want to populate
that spinner with courses based on the value(courseNumber) in database based
on sno...
ex data in database:
sno course address
1000 303 uk
1001 404 india
1002 505 usa
here my requiremnt is when i give value in sno edittext and click on
retreive button the data should populate in spinner and edittext....for
example i enter 1000 in sno edittext and click on retreive button the
spinner should populate with Biology and address edittext sholud populate
with uk....the spinner should set with coursename based on courseNumber in
database...
i declared courseCode as global variable and saved in my database....my save
button and retreive button code is as follows:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Android.App;
using Android.Content;
using Android.OS;
using Android.Runtime;
using Android.Views;
using Android.Widget;
using Mono.Data.Sqlite;
using System.IO;
using System.Data;
namespace EtSpSqlite
{
[Activity(Label = "SaveSpinnerWithValue",MainLauncher=true)]
public class SpinnerSaveWithValue : Activity
{
Spinner spinner;
EditText etsnospinner;
EditText etaddspinner;
ArrayAdapter<String> aa;
ArrayAdapter<string> adapter;
string courseCode;
TextView tvmsg;
protected override void OnCreate(Bundle bundle)
{
base.OnCreate(bundle);
SetContentView(Resource.Layout.SpinnerSaveWithValue);
// Create your application here
Button savespinner =
FindViewById<Button>(Resource.Id.saveSpinner);
spinner = FindViewById<Spinner>(Resource.Id.spinnerValue);
List<string> courses = new List<string>();
courses.AddRange(new string[]{"Chemistry", "Physics",
"Biology","Maths", "German"});
List<int> courseNumbers = new List<int>();
courseNumbers.AddRange(new int[] { 101, 202, 303, 404, 505 });
adapter = new
ArrayAdapter<string>(this,Android.Resource.Layout.SimpleSpinnerDropDownItem);
foreach (string s in courses)
adapter.Add(s);
spinner.Adapter = adapter;
spinner.ItemSelected += (object
sender,AdapterView.ItemSelectedEventArgs e) =>
{
courseCode = courseNumbers[e.Position].ToString();
};
savespinner.Click+=new EventHandler(savespinner_Click);
etsnospinner = FindViewById<EditText>(Resource.Id.etsnospinner);
etaddspinner = FindViewById<EditText>(Resource.Id.etaddSpinner);
Button retreivespinner =
FindViewById<Button>(Resource.Id.retrievespinner);
retreivespinner.Click+=new EventHandler(retreivespinner_Click);
tvmsg=FindViewById<TextView>(Resource.Id.tvspinner);
}
void savespinner_Click(object sender, EventArgs e) {
string DatabaseName = "sdata.db3";
string documents =
System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);
string db = Path.Combine(documents, DatabaseName);
bool exists = File.Exists(db);
if (!exists)
{
SqliteConnection.CreateFile(db);
}
var conn = new SqliteConnection("Data Source=" + db);
SqliteCommand sqlitecmd = new SqliteCommand();
sqlitecmd.Connection = conn;
string cmd = "CREATE TABLE IF NOT EXISTS STDNT(SNO INT,SCOURSE
VARCHAR(50),SADD VARCHAR(50))";
sqlitecmd.CommandType = CommandType.Text;
sqlitecmd.CommandText = cmd;
conn.Open();
sqlitecmd.ExecuteNonQuery();
conn.Close();
SqliteCommand sqlc = new SqliteCommand();
sqlc.Connection = conn;
conn.Open();
string strSql = "INSERT INTO STDNT (SNO, SCOURSE, SADD) VALUES
(@SNO, @SCOURSE, @SADD)";
sqlc.CommandText = strSql;
sqlc.CommandType = CommandType.Text;
sqlc.Parameters.Add(new
SqliteParameter("@SNO",etsnospinner.Text));
sqlc.Parameters.Add(new SqliteParameter("@SCOURSE",
courseCode));
sqlc.Parameters.Add(new SqliteParameter("@SADD",
etaddspinner.Text));
sqlc.ExecuteNonQuery();
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
conn.Dispose();
Toast.MakeText(this, "data inserted successfully...!",
ToastLength.Long).Show();
etsnospinner.Text = "";
etaddspinner.Text = "";
}
void retreivespinner_Click(object sender, EventArgs e) {
string DatabaseName = "sdata.db3";
string documents =
System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);
string db = Path.Combine(documents, DatabaseName);
var conn = new SqliteConnection("Data Source=" + db);
var strSql = "select SNO,SCOURSE,SADD from STDNT where
SNO=@SNO";
var cmd = new SqliteCommand(strSql, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqliteParameter("@SNO",
etsnospinner.Text));
try
{
conn.Open();
SqliteDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
string str = Convert.ToString(sdr["SCOURSE"]);
/* here have to write the code for population of
spinner ....here i have taken courseNumber in string variable str...based on
this value spinner should set with course... */
etaddspinner.Text = Convert.ToString(sdr["SADD"]);
}
}
catch (System.Exception sysExc)
{
tvmsg.Text = sysExc.Message;
}
finally
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
conn.Dispose();
}
}
}
}
--
View this message in context:
http://mono-for-android.1047100.n5.nabble.com/Enhancement-code-for-Spinner-tp5712950p5712968.html
Sent from the Mono for Android mailing list archive at Nabble.com.
_______________________________________________
Monodroid mailing list
Monodroid@lists.ximian.com
UNSUBSCRIBE INFORMATION:
http://lists.ximian.com/mailman/listinfo/monodroid
