473,387 Members | 1,897 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

OLE DB for ODBC parameter query won't populate dropdownlist

Greetings:

I am attempting to use one dropdownlist to filter the contents of another as
demonstrated within this MSDN article:
http://msdn2.microsoft.com/en-us/library/aa581791.aspx. Oracle 10 is the
backend in this case, and it is my understanding that the OLE DB provider in
Oracle for Visual Studio 2005 supports V8. So, I'm using the OLE DB provider
for ODBC.

However, I'm using ASP .NET as the interface, and my table adapter populates
the first list correctly and I have "postback" enabled. But I don't get any
data showing up in the second list when the page loads or I make a selection
from the first list; I can test the parameter for the dataset just fine in
the designer.

One thing that looks suspicious is that the syntax looks a little different
than expected for the parameter: It leaves out the "?" in my GetData method,
i.e., (LABEL_IDNUM) instead of (?LABEL_IDNUM), but when configuring my
datasource, it recognizes there is a parameter based on the given SQL. (I
had to define it as a filter for it to show as a parameter.)

SELECT SND_PROD1.LABELS.LABEL_IDNUM, SND_PROD1.CATEGORY.CATEGORY_IDNUM,
SND_PROD1.DEVICE_UNDER_TEST.DUT_TRACKNO
FROM SND_PROD1.LABELS, SND_PROD1.DEVICE_FAMILY, SND_PROD1.CATEGORY,
SND_PROD1.DEVICE_CONFIG,
SND_PROD1.DEVICE_UNDER_TEST
WHERE SND_PROD1.LABELS.LABEL_IDNUM = SND_PROD1.DEVICE_FAMILY.LABEL_IDNUM
AND
SND_PROD1.DEVICE_FAMILY.CATEGORY_IDNUM =
SND_PROD1.CATEGORY.CATEGORY_IDNUM AND
SND_PROD1.DEVICE_FAMILY.DEVFAM_IDNUM =
SND_PROD1.DEVICE_CONFIG.DEVFAM_IDNUM AND
SND_PROD1.DEVICE_CONFIG.DEVCFG_IDNUM =
SND_PROD1.DEVICE_UNDER_TEST.DEVCFG_IDNUM AND
(SND_PROD1.CATEGORY.CATEGORY_IDNUM = 21) AND
(SND_PROD1.LABELS.LABEL_IDNUM = ?)

Any suggestions to try to get the second list to display data?
--
Brian J. Matuschak
br***@electronic-atlas.com
Nov 28 '07 #1
0 1239

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
11
by: DJJ | last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time...
2
by: Bibi | last post by:
Hi, i have a SqlWindows Program which made a connection to a MS Access Database about ODBC. I can get all datas with a select about one table. But when i made a select with more than one table,...
1
by: TheKval | last post by:
I'm trying to pull records on a Macola table linked to Access. If enter a value in the criteria field of the query form, the quer executes okay. If I change the criteria to a parameter, ala, , I...
3
by: Rob Venable | last post by:
Hi everyone, Can anyone see a problem with this code. I'm kinda new to asp.net and I'm having a problem populating a drop down list with a database query. The results of my query populate the list...
1
by: | last post by:
Hi, I've defined an ObjectDataSource and a parameterized DataSet. I would like it if I could pass the parameter value that describes the query that creates the DataSet as part of a user control...
0
by: dawg1998 | last post by:
I am able to populate a DropDownList control within multiple rows of a GridView with the following code: `````````````````````````````````````````````````````` <asp:GridView id="gvGridView"...
2
by: Greg Corradini | last post by:
Hello All, A few weeks ago, I wrote two scripts using mx.ODBC on an Access DB. Among other things, both scripts create new tables, perform a query and then populate the tables with data in a...
0
by: Maneesh Agarwal | last post by:
I am trying to pass a parameter to dynamically populate drop down list. I am not able to pass the parameter from my .aspx file. Here is the grid view and related ObjectDataSource. In srcLocation, the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.