Skip to main content
Androiddeveloper
Participant
July 28, 2016
Question

Datas are not shown in Datagrid

  • July 28, 2016
  • 0 replies
  • 188 views

i tried to retrieve data from sqlite database to datagrid component but Datas are not shown in Datagrid.I tried very much.The source code is bottom.Where did I make error?Would you like to help me?

Multitouch.inputMode = MultitouchInputMode.TOUCH_POINT;

tumkayit.addEventListener(TouchEvent.TOUCH_END, fl_TapHandler_5);

function fl_TapHandler_5(Event: TouchEvent): void {

  function openDatabase(): void {

  connection = new SQLConnection();

  connection.addEventListener(SQLEvent.OPEN, onOpen);

  connection.openAsync(null);

  var dbFile: File = File.applicationStorageDirectory.resolvePath("kurs.db");

  connection.openAsync(dbFile, SQLMode.CREATE);

}

function onOpen(SQLEvent): void {

  var stat1: SQLStatement = new SQLStatement();

  stat1.sqlConnection = connection;

  stat1.text = "CREATE TABLE IF NOT EXISTS talebe (id INTEGER PRIMARY KEY AUTOINCREMENT, adsoyad TEXT, tcno TEXT, okul TEXT,istirak TEXT,not1 TEXT)";

  stat1.execute();

}

  function secim(SQLEvent): void {

  var sorgu1: SQLStatement = new SQLStatement();

  sorgu1.sqlConnection = connection;

  sorgu1.text = "SELECT * FROM talebe";

  sorgu1.execute(-1,new Responder(datacek));

  var adsoyadi:DataGridColumn=new DataGridColumn();

  var tcno2:DataGridColumn=new DataGridColumn();

  var okul1:DataGridColumn=new DataGridColumn();

var istirak1:DataGridColumn=new DataGridColumn();

  var ozel:DataGridColumn=new DataGridColumn();

  verigorunum.columns["AdiSoyadi","TCNo","Okulu","İstirak","OzelDurumlar"];

  verigorunum.getColumnAt(0).headerText = "Adı soyadı";

  verigorunum.getColumnAt(1).headerText = "TC NO";

  verigorunum.getColumnAt(2).headerText = "Okulu";

  verigorunum.getColumnAt(3).headerText = "İştirak Durumu";

  verigorunum.getColumnAt(4).headerText = "Özel Durumlar";

  verigorunum.getColumnAt(0).width=50;

  verigorunum.getColumnAt(1).width=90;

  verigorunum.getColumnAt(2).width=50;

  verigorunum.getColumnAt(3).width=90;

  verigorunum.getColumnAt(4).width=200;

  function datacek(event:SQLResult): void {

  var result2:SQLResult = sorgu1.getResult() as SQLResult;

  if (result2.data == null) {

  sonuc.text = "Öğrenci kayıt çizelgesinde kayıt yoktur";

  }

  var numResults: int = event.data.length;

  for (var i:int = 0; i < numResults; i++) {

  verigorunum.dataProvider=new DataProvider(result2.data);

  var row:Object=result2.data;

  verigorunum.addItem({AdiSoyadi:row.adsoyad,TCNo:row.tcno,Okulu:row.okul,İstirak:row.istirak,OzelDurumlar:row.not1,data:row});

  trace("sorgu başarılı");

  }

   }

    This topic has been closed for replies.