我有一个从产品表中拉出的下拉列表。现在我需要显示一个包含产品名称及其图像列的表格,但仅限于从下拉选项中单击特定产品类型时。现在我的代码在页面加载时显示所有产品。该表应显示下拉列表中Where product = selected product的值。目前不进行筛选。它显示了所有的产品,我意识到我需要ajax。由于我对Ajax非常陌生,我尽了最大努力与它合作,但它不起作用。谁能帮帮我吗?这里是我工作的代码:如何使用经典的asp,jquery和ajax从第一个下拉列表中选择一个值,然后显示选定项目的表格?
$("#ProdID").change(function(){
var productId = $(this).find('option:selected').val();
if (productId != '') {
.ajax({
async: false,
type : 'POST',
url : 'ajax/imageflip.asp',
data : { productId: productId},
success : function(responseData) {
try {
if (responseData == 1) { //Successful input
alert("Images shown!");
$("#wcurdata").html(responseData);
} else {
alert("ERROR! No Images!");
}
} catch(e) {
}
}
});
} else {
alert("Please Check the deconstructed Images!");
}
});
Dim rsbrnd
SQL = "SELECT DISTINCT(brand) as brand FROM product"
SET rsbrnd = objConn.Execute(SQL)
IF NOT (rsbrnd.EOF) THEN
%>
Product:
---- SELECT ----
WHILE NOT rsbrnd.EOF
Response.Write "
Response.Write ">" & rsbrnd("brand") &"
"rsbrnd.MoveNext
WEND
%>
END IF
rsbrnd.close
Set rsbrnd = Nothing
%>
StrC= "SELECT TOP (200) np.Id, np.imgName, np.brand"&_
"FROM NewProduct"&_
"WHERE (np.brand = '"& rsbrnd("brand") &"')
set RsC = Objconn.execute(StrC)
IF NOT RsC.EOF THEN
Response.write "
Response.write "
"Response.write "
"Response.write "#"
Response.write "
"Response.write "
"Response.write "Name"
Response.write "
"Response.write "
"Response.write "Image"
Response.write "
"Response.write "
"countc = 1
While NOT RsC.EOF
Response.Write "
"Response.Write "
"Response.Write ""& countc &"."
countc = countc + 1
Response.Write "
"Response.Write "
"Response.Write RsC("imgname")
Response.Write "
"Response.Write "
Response.Write "
"Response.Write "
"RsC.Movenext
Wend
Response.Write "
"END IF
RsC.Close
Set RsC = Nothing
%>
2015-12-02
Vuiee
+0
看起来你已经从你的数据库获得的产品图片,包含产品ID一起当你建立你在ASP中的表 - 为什么你要通过Ajax调用一个新的图像? –
+0
嗨乔希,那只是我需要的警报信息,而wcurdata是整个桌子的div。我确实认为它可能有效。即一旦选择了下拉选项,该表格将被显示。而雅图像确实显示出工作正常,除了在页面加载时显示(仅当从下拉列表中选择选项时才加载表格) –
+0
那么如果您不介意在页面加载时加载所有表格数据的页面权重,您可以使用CSS来隐藏您的表格和行,直到选中某个选项,然后取消隐藏匹配所选品牌的表格和那些产品行。不需要ajax。 –