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