Adding Two Tables to a DataView

Colonel Angus · February 9th, 2005, 02:11 PM

I have a function that returns a DataView that is derived from a dataset table. I need to have a second set of data appended to the end of the first table.

What I have now is:

Code:

Function GetCounselorList() As DataView
        Dim dsLookups As DataSet
        Dim thisCase As New clsCase
        Dim Counselors As DataView

        dsLookups = thisCase.GetLookups
        Counselors = dsLookups.Tables("Counselors").DefaultView
        Counselors.AllowNew = True

        Return Counselors
End Function

I am using this to populate a dropdown list. I need to add another table to the bottom of the list with this second table:

Code:

dsLookups.Tables("InactiveCounselors").DefaultView

Thanks in advance for your comments.

- - - - - - - - - - - - - - - - - - - - - - -
In God we trust, everything else we test.

alyeng2000 · February 9th, 2005, 05:26 PM

get them in the same query (one table)

Ahmed Ali
Software Developer

mehdi62b · February 9th, 2005, 06:45 PM

I'm not sure but I think alyeng2000's way is not applicable because DataColumn doesn't implement ICollection and because in your case you want to populate a DropDownList,just you can set the DataSource of your DropDown with one column...so even if you do something like this,you cant get your result,

Code:

ArrayList ar=new ArrayList();
ar.AddRange(dv1);
ar.AddRange(dv2);

in your case for a DropDownList the only way I think you can is iterating through all elements in your DataViews and assigning them to one unique arraylist then set the DataSource of your DropDown to the arraylist,
(I meant from elements ds.Tables["Counselors"].Rows[FixedNumber][j] and ds.Tables["InactiveCounselors"].Rows[Fixed][k]).

_____________________________
Mehdi.
software engineering student.
Looking for a good job for summer 2005.