Hello. I am writing small application with aspx (framework 4.0). I have created typed datasets for holding data from db. Lets say I have table Person and table Address. Person can have 0..(some) addresses.
I have form to search persons, but I wish to show also their addresses. The question is - is there a possibility to simple fill DataSet's Address table base on PersonID from Person table? Currently I am builiding query string, but I find this strange solution? The second question is - I have used DataSet designer. While building my queury string I am construviting SQL with WHERE ... IN ... As far as I know there is no possibility to build query in query-builder which takes an array as a param and merg it into list. But I find file PersonDataSetDesigner.cs which has all methods generated. Is it possible to add my own fill method here which will take an array and transfers it into string and than puts it into param? regards
