Inserting into Database through Edittext Field in Android -

-

i new android. not able insert data database. although accepting text through edittext field not saving in database.

i want insert data database table using xml button's android:onclick attribute.

when click on on save button app crashes immediately

//interviewactivity.java

import java.util.arraylist; import android.app.activity; import android.os.bundle; import android.view.view; import android.view.view.onclicklistener; import android.widget.button; import android.widget.edittext; import android.widget.tablelayout; import android.widget.tablerow; import android.widget.textview; import android.widget.remoteviews.actionexception; import android.widget.toast; import android.content.contentvalues; import android.content.intent; import android.database.sqlite.sqlitedatabase;  public class interviewactivity extends activity {     @override     public void oncreate(bundle savedinstancestate) {          super.oncreate(savedinstancestate);         setcontentview(r.layout.welcomeactivity);      }      public void onquestionclicked(view view) {         edittext q = (edittext)findviewbyid(r.id.questiont);         edittext = (edittext)findviewbyid(r.id.answert);              q.setvisibility(view.visible);         a.setvisibility(view.invisible);          toast.maketext(this, "enter question here", toast.length_long).show();     }     public void onanswerclicked(view view) {         edittext q = (edittext)findviewbyid(r.id.questiont);         edittext = (edittext)findviewbyid(r.id.answert);              a.setvisibility(view.visible);         q.setvisibility(view.invisible);          toast.maketext(this, "enter answer here", toast.length_long).show();     }      public void onsave(view view) {         edittext q = (edittext)findviewbyid(r.id.questiont);         edittext = (edittext)findviewbyid(r.id.answert);              string q = q.gettext().tostring();         string = a.gettext().tostring();          toast.maketext(this,"question :"+" " + q + "\n" +                 "answer :"+" " + a, toast.length_long).show();      }       public void oncancel(view view) {         finish();     } }

//trying.java

package com.ques.ans;  import android.content.contentvalues; import android.content.context; import android.database.sqlite.sqlitedatabase; import android.database.sqlite.sqlitedatabase.cursorfactory; import android.database.sqlite.sqliteopenhelper;  public class trying extends sqliteopenhelper{      public static final string db_name = "save.db";     public static final int db_version=2;     public static final string table="qnadb";     public static final string sno = "sno";     public static final string question = "question";     public static final string answer = "answer";         public trying(context context) {         super(context,db_name, null, db_version);         // todo auto-generated constructor stub     }      @override     public void oncreate(sqlitedatabase db) {         string sql = "create table table (sno integer autoincrement primary key not null, question text , answer text);";         // todo auto-generated method stub         db.execsql(sql);     }      @override     public void onupgrade(sqlitedatabase db, int oldversion, int newversion) {         db.execsql("drop table if exists " + table);         oncreate(db);     }      public void onsaving(string q,string a) {         sqlitedatabase db=this.getwritabledatabase();         contentvalues cv=new contentvalues();         cv.put(sno, 1);         cv.put(question, q);         cv.put(answer, a);         db.insert(table,null, cv);         db.close();     } }

so pk(primary key) using autoicrement can't add database. try repair method snippet of code:

contentvalues cv = new contentvalues();    cv.put(question, q);    cv.put(answer, a);    db.insert(table, null, cv);

also think wrong. defined table name table

string sql = "create table table (sno integer autoincrement primary key not null, question text , answer text);";

and static variable has value gnadb. incorrect, isn't?

public static final string table = "qnadb";

so change table name to

string sql = "create table qnadb (sno integer autoincrement primary key not null, question text , answer text);

or change value of table variable.


so try change suggestions , should works.


Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c# - Copy ObservableCollection to another ObservableCollection -

-
how copy observablecollection item observablecollection without reference of first collection? here observablecollection item value changes affecting both collections. code private observablecollection<ratemodel> _allmetalrate = new observablecollection<ratemodel>(); private observablecollection<ratemodel> _metalrateondate = new observablecollection<ratemodel>(); public observablecollection<ratemodel> allmetalrate { { return this._allmetalrate; } set { this._allmetalrate = value; notifypropertychanged("metalrate"); } } public observablecollection<ratemodel> metalrateondate { { return this._metalrateondate; } set { this._metalrateondate = value; notifypropertychanged("metalrateondate"); } } foreach (var item in metalrateondate) allmetalrate.add(item); what causing , how can solve it? you need clone object referenced item before it's a...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more