hai everybody, i am new to flex environment and i am presently working on remote object service. in this regard i need a help, i am trying to retrieve values from sql and output them to datagrid, i am unable to see the values outputed to datagrid my sql db contains two columns cname and email, and i am working on flex 1.5 here is my mxml,as,java file to solve the above problem.
LoginchkAB.java import java.sql.*; import java.util.ArrayList; public class LoginchkAB{ Connect q=new Connect(); public void LoginchkAB() { } public ArrayList getList() { ArrayList list = new ArrayList(); try { Connection Conn=q.establish_Connection(); Statement s = Conn.createStatement(); ResultSet rs= s.executeQuery("select cname,email from deepa123456"); System.out.println("ramana"); while (rs.next ()) { list.add(new ViewuserVO (rs.getString(1),rs.getString(2))); System.out.println("ramana"); } s.close(); Conn.close(); } catch(Exception e) { System.out.println("TechRP"+e); } return list; } public static void main(String args[]) { LoginchkAB q=new LoginchkAB(); } } ViewuserVO.as file class ViewuserVO { public var cname : String; public var email : String; static var registered=Object.registerClass("ViewuserVO", ViewuserVO); } UsingRemoteObj1.mxml <?xml version="1.0" encoding="utf-8"?> <mx:Application xmlns:mx="http://www.macromedia.com/2003/mxml" verticalGap="10"> <mx:Button label="Get user List" click="getusers()"/> <mx:DataGrid id="dg" dataProvider="{loginchkA.list}" width="100%" height="100%"> <mx:columns> <mx:Array> <mx:DataGridColumn columnName="cname" headerText="cname" /> <mx:DataGridColumn columnName="email" headerText="email"/> </mx:Array> </mx:columns> </mx:DataGrid> <mx:Script> var list; </mx:Script> <mx:Script> <![CDATA[ function getusers() { loginchkA.getList(); } ]]> </mx:Script> <mx:RemoteObject id="loginchkA" result="list=event.result" source="LoginchkAB" fault="alert(event.fault.faultstring, 'Error')"> <mx:method name="getList"/> </mx:RemoteObject> </mx:Application> i would be thankful for the help regarding this. Thank u all Ramana -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/