|
-
Nov 18th, 2003, 10:08 PM
#5
Frenzied Member
I checked your program. You have some confusing problems:
1- The dataset you are using 'DataSetZoeken12' already has a list of typed columns, one named "CDID" that is an autoincrement column, and then you are adding another tblCD.CDID untyped column to it. It binds to the Typed one that is actually "tblCD.CDID" and contaisn values of 0,1,2,3,... So thats why you are facing this problem.
2- Even if you generate dataset with the OleDbDataAdapterzoeken1 still you will face problem, because you are changing the select text of dataadapter and different set of columns are chosen and then still trying to fill the previous dataset with it. In this manner you are trying to bind to an Untyped Dataset, that causes problem when you are for example binding a Text property to an Integer. So you may build an adapter with the command text of strSQLzoeken and generate a dataset with it, and then change the select command based on the selection. Remember in this manner you are not changing the column collection of the dataadapter, just applying some filters.
Last edited by Lunatic3; Nov 18th, 2003 at 10:18 PM.
'Heading for the automatic overload'
Marillion, Brave, The Great Escape, 1994
'How will WE stand the FIRE TOMORROW?'
Eloy, Silent Cries and Mighty Echoes, The Vision - Burning, 1979
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote