Android insert data in to database issue -


i have made database want add data database how can store value database through code.anyone me. in advance. try insert fail this

this dbhelper class.

    public class fooddbhelper extends sqliteopenhelper { private static final string database_name = "pkfm.db"; private static final int database_version = 1; private static final string create_query =         "create table "+ food.newdishinfo.table_name+"("                 + food.newdishinfo.dish_name+" text not null,"                 + food.newdishinfo.dish_quantity+" text not null,"                 + food.newdishinfo.dish_calorie+" integer,"                 + food.newdishinfo.dish_fat+" text not null,"                 + food.newdishinfo.dish_protein+" text not null,"                 + food.newdishinfo.dish_sugar+" text not null,"                 + food.newdishinfo.dish_carbohydrates+" text not null);"; public fooddbhelper(context context) {     super(context,database_name,null,database_version);     log.e("database operation","database created / opened..."); } @override public void oncreate(sqlitedatabase db) {     db.execsql(create_query);     log.e("database operation","table created...");   } public void addinformations(string name ,string quantity, integer calorie, string fat ,                             string protein,string sugar,string carbohydrates, sqlitedatabase db){       contentvalues contentvalues = new contentvalues();     contentvalues.put(food.newdishinfo.dish_name,name);     contentvalues.put(food.newdishinfo.dish_quantity,quantity);     contentvalues.put(food.newdishinfo.dish_calorie,calorie);     contentvalues.put(food.newdishinfo.dish_fat,fat);     contentvalues.put(food.newdishinfo.dish_protein,protein);     contentvalues.put(food.newdishinfo.dish_sugar,sugar);     contentvalues.put(food.newdishinfo.dish_carbohydrates,carbohydrates);      db.insert(food.newdishinfo.table_name, null, contentvalues);       log.e("database operation","one row inserted..."); }

i thing not data inserted

fooddbhelper = new fooddbhelper(context); fooddbhelper.addinformations("paratha", "1 piece", 260,"8.99 g","5.16 g","2.18 g","38.94 g",sqlitedatabase);

use this.getwritabledatabase(); function hope you..

//declare variable  private static final string table_friend_master = "friend_master";    private static final string create_table_friend_master = "create table if not exists " + table_friend_master + "(" + key_id + " integer primary key," + key_friend_id + " text," + key_friend_fname + " text," + key_friend_lname + " text," + key_friend_email + " text," + key_friend_mobile + " text," + key_friend_username + " text,"             + key_friend_country_code + " text);";   @override     public void oncreate(sqlitedatabase db) {         db.execsql(create_table_friend_request_master);     }        public int addfriend(string friendid, string friendfname, string friendlname, string friendemail, string friendmobile, string friendusername, string friendcountrycode) {         synchronized (lock) {             sqlitedatabase db = this.getwritabledatabase();             contentvalues values = new contentvalues();             values.put(key_friend_id, "" + friendid);             values.put(key_friend_fname, "" + friendfname);             values.put(key_friend_lname, "" + friendlname);             values.put(key_friend_email, "" + friendemail);             values.put(key_friend_mobile, "" + friendmobile);             values.put(key_friend_username, "" + friendusername);             values.put(key_friend_country_code, "" + friendcountrycode);             // insert row             int comment_row_id = (int) db.insert(table_friend_master, null, values);             return comment_row_id;         }     }

Comments

Post a Comment

Popular posts from this blog

How to connect android app to App engine -

i'm trying connect app in android server i've opened on appengine. my server's name : dddd-daniel-2345 , website server : http://dddd-daniel-2345.appspot.com/ this how connect android app server in app engine: app.yaml: application: dddd-daniel-2345 version: 1 runtime: python27 api_version: 1 threadsafe: yes handlers: - url: .* script: main.app libraries: - name: webapp2 version: "2.5.2" main.py: #!/usr/bin/env python # # copyright 2007 google inc. google.appengine.api import users import webapp2 class userhandler(webapp2.requesthandler): def get(self): user = users.get_current_user() if user: greeting = ('%s,%s,%s' % (user.email(),user.user_id(),user.nickname())) else: greeting = ('not logged in') self.response.out.write(greeting) app = webapp2.wsgiapplication([('/', userhandler),], debug=true) my applications code : add manifast main....
Read more

gcc - MinGW's ld cannot perform PE operations on non PE output file -

i know there other similar questions out there, stackoverflow or not. i've researched lot this, , still didn't find single solution. i'm doing operative system side project. i've been doing in assembly, wanna join c code. test, made assembly code file (called test.asm): [bits 32] global _a section .text _a: jmp $ then made c file (called main.c): extern void a(void); int main(void) { a(); } to link, used file (called make.bat): "c:\mingw\bin\gcc.exe" -ffreestanding -c -o c.o main.c nasm -f coff -o asm.o test.asm "c:\mingw\bin\ld.exe" -ttext 0x100000 --oformat binary -o out.bin c.o asm.o pause i've been researching ages, , i'm still struggling find answer. hope won't flagged duplicate. acknowledge existence of similar questions, have different answers, , none work me. question: what doing wrong? old mingw versions had problem "ld" not able create non-pe files @ all. maybe current versions...
Read more

php - display validation error message next to the textbox in codeigniter -

Image
i'm newbie codeigniter.i want display error message next text box.my view file create.php contains following code. <?php echo validation_errors(); //validation echo form_open('news/create'); //create form ?> <div class="boxes"> <div class="common"> <div class="lables"> <label for="name">name</label> </div> <div class="text_boxes"> <input type="text" name="uname" /><div id="infomessage"><?php echo $message;?></br> </div> </div>` and below controller model: public function create() { $this->load->helper('form'); $this->load->library('form_validation'); $data['title'] = 'insert items'; $this->form_validation->set_rules('uname','required|min_length[6]|m...
Read more