Datas are not shown in Datagrid
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ı");
}
}
