hi madhu..
Step1: WEBservice..
[WebMethod]
public String loadgroups(string centre)
{
String str = "Provider=OraOLEDB.Oracle.1 Data Source=";
OleDbConnection con = new OleDbConnection(str);
con.Open();
DataSet ds = new DataSet();
string strsql = "SELECT QUERY ";
OleDbCommand cmd = new OleDbCommand(strsql, con);
OleDbDataAdapter adap = new OleDbDataAdapter(cmd);
adap.Fill(ds);
ds.Tables[0].TableName = "group";
ds.DataSetName = "Groups";
con.Close();
return ds.GetXml();
}
step2 : FLEX:
public function GroupComboLoad(selectedName:String):void
{
initService();
webservice.loadWSDL();
webservice.loadgroups.addEventListener("result",
loadGroupCombo);
webservice.loadgroups(selectedName);
}
var combosourcexml:XML=new XML();
public function loadGroupCombo(event:ResultEvent):void
{
combosourcexml=XML(event.result);
GroupCombo_Write.dataProvider=combosourcexml..SHORT_NAME;
} *
*iam directly the xml to comboboc control.*
*
On Fri, Sep 26, 2008 at 5:19 PM, girish kumar <[EMAIL PROTECTED]> wrote:
> hi madhu....
>
> You are getting XML result from webservice and iam binding it to an local
> variable(XML).
> Obtained Xml result would be in treestructure naa, so iam traversing it
> using the dotoperator to the node i wanted...
> then passing it to the particular component as its dataprovider..thats it.
>
> girish...
>
>
> On Fri, Sep 26, 2008 at 5:03 PM, Madhu Kumar <[EMAIL PROTECTED]> wrote:
>
>> Girish...
>> I am unable to understand that what r u explaining abt.. will u b more
>> clear dear.......about combo box and parsing into XML please reply me....
>> Regards
>> Madhu
>>
>>
>> On Fri, Sep 26, 2008 at 2:43 AM, girish kumar <[EMAIL PROTECTED]> wrote:
>>
>>> hi
>>>
>>> are u gettingbthe result inside flex..then no probs, in the webservice
>>> resulthandler method you would be do like this..
>>>
>>> var combosource:XML=new XML();
>>> public function loadCombo(event:ResultEvent):void
>>> {
>>> combosource=XML(event.result);
>>> CentreCombo.dataProvider=combosource..SHORT_NAME;
>>> }
>>>
>>> this is for combo box..
>>>
>>>
>>> On Fri, Sep 26, 2008 at 3:14 PM, HISSAM <[EMAIL PROTECTED]>wrote:
>>>
>>>> Thanks girish for the idea
>>>> but can u also put some light on how to retrieve this info at the flex
>>>> end??
>>>>
>>>> how to assign the values as an array to a dataprovider of a component
>>>>
>>>> here-is my webservice code
>>>>
>>>> [WebMethod]
>>>> public string get2LevelColors(string strCategory)
>>>> {strCategory="blues & greens";
>>>> string strConnectionString =
>>>> "server=192.168.1.100;uid=hissam;pwd=dd;database=img;";//
>>>> ConfigurationManager.AppSettings["DatabaseConnectionString"];//"server=
>>>> 192.168.1.100;uid=hissam;pwd=database;database=adstorage;";
>>>>
>>>> string strQuery = "select distinct Level2filter as colors "
>>>> + " from assets "
>>>> + " where Level2filter!='null' and
>>>> type='texture' and category='" + strCategory + "';";
>>>> string strResultLevelColors = "";
>>>>
>>>> MySqlConnection objCon = null;
>>>> MySqlCommand objCom = null;
>>>> //MySqlDataReader objResult = null;
>>>> DataSet objDataSet = null;
>>>> MySqlDataAdapter objDataAdapter = null;
>>>>
>>>> try
>>>> {
>>>> objCon = new MySqlConnection(strConnectionString);
>>>> objCon.Open();
>>>> objCom = new MySqlCommand(strQuery, objCon);
>>>> objDataAdapter = new MySqlDataAdapter();
>>>> objDataSet = new System.Data.DataSet();
>>>> objDataAdapter.SelectCommand = objCom;
>>>> objDataAdapter.Fill(objDataSet, "ColorTable");
>>>> objDataSet.DataSetName = "ColorsDataSet";
>>>>
>>>>
>>>>
>>>> }
>>>> catch (Exception e)
>>>> {
>>>>
>>>> }
>>>> finally
>>>> {
>>>> try
>>>> {
>>>> if (objCon != null)
>>>> objCon.Close();
>>>> }
>>>> catch
>>>> {
>>>> //System.err.println("Exception: " + e.getMessage());
>>>> // e.printStackTrace();
>>>> }
>>>> }
>>>> string s=objDataSet.GetXml();
>>>> return s;
>>>> }
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>> >>
>>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Flex
India Community" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/flex_india?hl=en
-~----------~----~----~----~------~----~------~--~---
