Skip to Content
0
Former Member
Apr 09, 2010 at 10:36 AM

code for fillinf dropdown from table using webdypro(use node element)

28 Views

hiiiiiiii,

i want to fill dropdown by fetching a data from table, it will fill if i use context element but it gives while i use node element so give me the code for that ,

i put the that i use

String qry="select city_id,city_name from gms.tbl_cities order by city_name";

ResultSet rs=stmt.executeQuery(qry);

IModifiableSimpleValueSet cset=

wdContext

.getNodeInfo()

// .getAttribute(IPrivateAddguesthouse.IContextElement.CITYNAME)

.getAttribute(IPrivateAddguesthouse.IAddguesthouseElement.CITY__NAME)

.getModifiableSimpleType()

.getSVServices()

.getModifiableSimpleValueSet();

cset.clear();

while(rs.next())

{

cset.put(rs.getString(1),rs.getString(2));

cityid=rs.getString("City_id");

}