java - how to get details in list view from sqlite database in android -

-

i want display details in listview sqlite database. how set custom adapter in mainactivity? code follows:

public class mainactivity extends activity {      edittext eid,ename;     button add;     public databaseclass mdb=null;     public cursor c=null;     public sqlitedatabase db=null;     public static final string database_name="sample.db";     public static final int database_version=1;     @override     protected void oncreate(bundle savedinstancestate) {         super.oncreate(savedinstancestate);         setcontentview(r.layout.activity_main);         eid=(edittext)findviewbyid(r.id.rid);         ename=(edittext)findviewbyid(r.id.rname);         add=(button)findviewbyid(r.id.radd);                 mdb=new databaseclass(getapplicationcontext(), database_name, null, database_version);          add.setonclicklistener(new view.onclicklistener() {                      @override             public void onclick(view arg0) {                 // todo auto-generated method stub                 db = mdb.getwritabledatabase();                 contentvalues cv=new contentvalues();                 int id=integer.parseint(eid.gettext().tostring());                 string name=ename.gettext().tostring();                  cv.put("id",id );                 cv.put("name",name );                 db.insert("demo", null, cv);              }         });       } }  database class  public class databaseclass extends sqliteopenhelper{      public databaseclass(context context, string name, cursorfactory factory,             int version) {         super(context, name, factory, version);         // todo auto-generated constructor stub     }      @override     public void oncreate(sqlitedatabase db) {         // todo auto-generated method stub         db.execsql("create table demo(id integer,name varchar);");      }      @override     public void onupgrade(sqlitedatabase db, int oldversion, int newversion) {         // todo auto-generated method stub      }  }

you should check out tutorial: android | simple sqlite database tutorial

it helped me lot! follow whole tutorial!

use class create/update/find/delete items database. don't in activity.

first things see:

  1. one semicolon in create string.

Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

jquery - ReferenceError: CKEDITOR is not defined -

-
may repeated question, solutions provided on net including stackoverflow q-a not resolved issue. ckeditor (4.5.3) integrated in mvc application. ckeditor using on textarea in partial view. same partial view used in create , edit post form. both form having same .chtml page. partial view : <textarea id="description" name="description" class="form-control" >@html.raw(model.description)</textarea> having script: <script type="text/javascript"> ckeditor.replace('description', { filebrowserimageuploadurl: '@url.action("uploadeditorimage", "administrator")', htmlencodeoutput: true }); </script> in .chtml page added : <script src="~/ckeditor/ckeditor.js"></script> generating proper js examined in response. config.js : ckeditor.editorconfig = function( config ) { config.image_previewtext = ckeditor.tools.repeat(' ...
Read more

android - Go back to previous fragment -

-
btw second fragment. appear once press button in first fragment. in fragment, if press button on phone, go previous fragment. need guys. in advance. public class listalldoctorfragment extends fragment { button close; @nullable @override public view oncreateview(layoutinflater inflater, viewgroup container, bundle savedinstancestate) { view view = inflater.inflate(r.layout.listalldoctor, container,false); close = (button) view.findviewbyid(r.id.button); close.setonclicklistener(new view.onclicklistener() { @override public void onclick(view view) { android.app.fragmentmanager fm = getfragmentmanager(); fragmenttransaction ft = fm.begintransaction(); shit f2 = new shit(); ft.add(r.id.content_frame, f2); ft.addtobackstack(null); ft.commit(); } }); return view; } } assuming want g...
Read more