jeudi 24 décembre 2015

takes each column value from gridview and insert intoi my sqllite database table

ok I'm new to android I want to take a selected row values from my gridview table and insert that data to my database table. When i select a gridview roe, it stays selected,and then after pressing some "ADD" button,its colums data will be inserted to my database table.. Need help guys.. My Layout file

<?xml version="1.0" encoding="utf-8"?>  
   <RelativeLayout xmlns:android="http://ift.tt/nIICcg"  
   android:layout_width="match_parent"  
   android:layout_height="match_parent" >  

   <TextView  
      android:id="@+id/choiceHeader1"  
      android:layout_width="wrap_content"  
      android:layout_height="wrap_content"  
      android:layout_alignParentLeft="true"  
      android:layout_alignParentTop="true"  
      android:text="Select From"  
      android:textAppearance="?android:attr/textAppearanceLarge" />

   <TextView  
      android:id="@+id/columnHeader1"  
      android:layout_width="wrap_content"  
      android:layout_height="wrap_content"  
      android:layout_alignParentLeft="true"  
      android:layout_below="@id/choiceHeader1"
      android:text="Collage"  
      android:textAppearance="?android:attr/textAppearanceLarge" />

   <TextView  
      android:id="@+id/columnHeader2"  
      android:layout_width="wrap_content"  
      android:layout_height="wrap_content"  
      android:layout_toRightOf="@id/columnHeader1" 
      android:layout_marginLeft="100dp"  
      android:layout_below="@id/choiceHeader1" 
      android:text="Branch"  
      android:textAppearance="?android:attr/textAppearanceLarge" />  

   <GridView  
      android:id="@+id/unchoicedGrid"  
      android:layout_width="match_parent"  
      android:layout_height="wrap_content"  
      android:layout_alignParentLeft="true"  
      android:layout_below="@+id/columnHeader1"  
      android:fastScrollAlwaysVisible="false"  
      android:fastScrollEnabled="true"
      android:clickable="true"  
      android:numColumns="2"
      android:longClickable="true" > 
   </GridView> 
</RelativeLayout>

My java file

package com.example.test2;

import java.util.ArrayList;

import android.support.v7.app.ActionBarActivity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.TextView;
import android.widget.GridView;
import android.widget.Toast;

public class Create_ChoiceList extends ActionBarActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_create__choice_list);

        final SQLiteDatabase mydatabase = openOrCreateDatabase("Test1",MODE_PRIVATE,null);      

        mydatabase.execSQL("CREATE TABLE IF NOT EXISTS Remained_Choice(ClgName VARCHAR,Branch VARCHAR)");
        Cursor rs = mydatabase.rawQuery("SELECT COUNT(*) FROM Remained_Choice", null);
        if (rs != null) {
            rs.moveToFirst();
            if (rs.getInt (0) == 0) { 
                mydatabase.execSQL("INSERT INTO Remained_Choice VALUES('MSU','Mech');");
                mydatabase.execSQL("INSERT INTO Remained_Choice VALUES('MSU','Comp');");
                mydatabase.execSQL("INSERT INTO Remained_Choice VALUES('Changa','Mech');");
                mydatabase.execSQL("INSERT INTO Remained_Choice VALUES('Changa','Comp');");
                mydatabase.execSQL("INSERT INTO Remained_Choice VALUES('Parul','Mech');");
                mydatabase.execSQL("INSERT INTO Remained_Choice VALUES('Parul','Comp');");
                mydatabase.execSQL("INSERT INTO Remained_Choice VALUES('Nirma','Mech');");
                mydatabase.execSQL("INSERT INTO Remained_Choice VALUES('Nirma','Comp');");
            }
        } 

        GridView gv1=(GridView) findViewById(R.id.unchoicedGrid); 
        ArrayList<String> list=new ArrayList<String>();
        ArrayAdapter<String> adapter=new ArrayAdapter<String>(getApplicationContext(),android.R.layout.simple_spinner_item,list);
        String clg_name, clg_branch;  
        clg_name="";  
        clg_branch="";    

           try  
           { 
              Cursor c=mydatabase.rawQuery("SELECT * FROM Remained_Choice ",null); 
              if(c.moveToFirst())  
              {  
                 do  
                 {  
                    clg_name=c.getString(c.getColumnIndex("ClgName"));  
                    clg_branch=c.getString(c.getColumnIndex("Branch")); 
                    list.add(clg_name);  
                    list.add(clg_branch);   
                    gv1.setAdapter(adapter);  
                 }while(c.moveToNext());  
              }  
              else  
              {  
                 Toast.makeText(getApplicationContext(), "No data found", Toast.LENGTH_LONG).show();  
              }  
           }
           catch(Exception e)  
           {  
               Toast.makeText(getApplicationContext(), "No data found"+e.getMessage(), Toast.LENGTH_LONG).show();  
           }
        }

Aucun commentaire:

Enregistrer un commentaire