transport data from mulitiple look-up tables through web service into business object for databindin

[msnews.microsoft.com]

Current code

1.. creates SqlDataAdapter
2.. fills dataset with database table extracted from dataadapter
3.. populates tables with database table contents extracted from
dataadapter
4.. binds table to datasource property of Infragistics dropdown combo
control


The code needs to be refactored to obtain the row/data info through a web
service so the database tables will have to be populated after the datalayer
has obtained the database data.



I am looking for the most efficient datatype through which the data
from several lookup tables can be transported through a web service into the
business object. Whatever datatype is used will then bind the data in the
business object to the drop down controls.



Thank you for any ideas. -hazz

 

[Nicholas Paldino [.NET/C# MVP]]

Quite honestly, I would just use the DataSet that you populate and
expose that through the web service. This way, you can just call the
service, get the data set, and then bind to whatever you need to.

It's not the most efficient, granted, but it is the easiest to
implement, and you can see if it suits your needs before looking at other
options.

Hope this helps.

 

[hazz]

Thank you Nicholas. I do like to start off with the simplest approach. -hazz

Quite honestly, I would just use the DataSet that you populate and
expose that through the web service. This way, you can just call the
service, get the data set, and then bind to whatever you need to.

It's not the most efficient, granted, but it is the easiest to
implement, and you can see if it suits your needs before looking at other
options.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Current code

1.. creates SqlDataAdapter
2.. fills dataset with database table extracted from dataadapter
3.. populates tables with database table contents extracted from
dataadapter
4.. binds table to datasource property of Infragistics dropdown combo
control


The code needs to be refactored to obtain the row/data info through a web
service so the database tables will have to be populated after the
datalayer has obtained the database data.



I am looking for the most efficient datatype through which the data
from several lookup tables can be transported through a web service into
the business object. Whatever datatype is used will then bind the data
in the business object to the drop down controls.



Thank you for any ideas. -hazz