func Init()
	// adds using namespace
	sys.add_use('System.Data')

	// initialize instance
	sys.add_object(this.codename, 'DataTable')

	// initialize properties
	if(isdef("SQLite"))
		warning(this.name + ' - SQLite manager does not defined')
	else
		this.sqlite = sys.get_undef_manager("SQLite")
	end
	if(isdef("DataGrid"))
		warning(this.name + ' - DataGrid manager does not defined')
	else
		this.grid = sys.get_undef_manager("DataGrid")
	end
end

func make_read()
	return(this.grid + '.DataSource = ' + this.codename + ';')
end

func doQuery(data)
	if(len(this.sqlite) and len(this.grid))
		blk.println(this.codename, ' = ', this.sqlite, '.read(', d("SQLquery"), ');')
		if(linked("onError"))
			blk.println('if (', this.codename, ' == null) {').inc()
				event("onError", this.sqlite + '.lasterror')
				blk.dec().println('} else {').inc()
				.println(make_read())
			.dec().println('}')
		else
			blk.println(make_read())
		end
	end
end

func make_update(data)
	return(this.sqlite + '.update()')
end

func doUpdate(data)
	if(len(this.sqlite) and len(this.grid))
		if(linked("onError"))
			blk.println('if (!', make_update(data), ') {').inc()
				event("onError", this.sqlite + '.lasterror')
			blk.dec().println('}')
		else
			blk.println(make_update(data), ';')
		end
	end
end