This is my code so far, but all it returns in the combo box is "System.Data.DataRowView". If I try and catch it I get the error message "Cannot bind to the new display member. Parameter name: newDisplayMember". If the SQL statement is:Code:Public Sub fillModelName() 'links to database link_to_database() Dim cmd As SqlCommand = New SqlCommand("SELECT MDUser_ID FROM MDModels WHERE MDUser_ID='" & DatabaseModule.UserID & "'", DatabaseModule.con) DatabaseModule.con.Open() Dim myDA As SqlDataAdapter = New SqlDataAdapter(cmd) Dim myDataSet As DataSet = New DataSet() myDA.Fill(myDataSet, "MDModels") ddbCurrentModel_EditModel.DataSource = myDataSet.Tables("MDModels").DefaultView ddbCurrentModel_EditModel.ValueMember = "MDModel_Name" ddbCurrentModel_EditModel.DisplayMember = "MDUser_ID" DatabaseModule.con.Close()
as expected it populates the combo box, however it is populated with every item (MDModel_Name) in MDModels instead of just the ones that are owned by the user (which is decided where the UserID = MDUser_ID)Code:Dim cmd As SqlCommand = New SqlCommand("SELECT MDUser_ID FROM MDModels, DatabaseModule.con)




Reply With Quote
