Data tier, dataview with combobox

cpopham

Member
Joined
Jun 3, 2004
Messages
20
Programming Experience
1-3
I have a datatier which has all of my connections, dataadpters, etc. One of my dataadpters pulls out a concatenated field like this:
SELECT DISTINCT ROW [tblMaster].Prefix & [tblMaster].Num & [tblMaster].Change AS ReqNum
FROM [tblMaster]

Okay the dataset (dsReqNum) is fine from the dataadapter and I can preview the datajust fine. So I have placed a dataview in this datatier which uses this dataset as the table.

Now in my main form I create the data tier object and the dataview object and call a function from the datatier which is suppose to return the dataview bound to this dataset. The function is coded as follows:
Public Function getReqNum() as DataView

daReqTrak.Fill(DsReqNum1)
Return dvReqNum

End Function

Now at the form load event I have my load event as follows:
Dim objReqTrakInfo As ReqTrakData 'Data tier
Dim dvReqNum1 as Dataview

Try
objReqTrakInfo = New ReqTrakData
dvReqNum1 = objReqTrakInfo.getReqNum()

'bind the dv to the combobox
With cboReqNum
.DataSource = dvReqNum1
.DisplayMemeber = "ReqNum"
.ValueMember = "ReqNum"
.SelectedIndex = -1
End With

Catch err as Exception
Messagebox.Show(err.Message)

End Try
End Sub

Now I compile it and it gets no errors, it runs fine except that my combobox is contains no values!

Can someone help?

Thanks, Chester
 
Back
Top