[导入]使用数据源的asp.net参数！

揭秘上的例题！
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="showcontrolparameter.aspx.cs" Inherits="showcontrolparameter" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
       <asp:DropDownList ID="DropDownList1" DataSourceID ="sqldatasource1"  DataValueField ="productid" DataTextField ="productname" runat="server">
        </asp:DropDownList>

        <asp:Button ID="Button1" runat="server" Text="Select" ToolTip ="select movie" /><br />

        <asp:GridView ID="GridView1" DataSourceID ="sqldatasource2" runat="server">
        </asp:GridView>
    </div>

        <asp:SqlDataSource ID="SqlDataSource1" ConnectionString ="<%$ ConnectionStrings:northwind %> " SelectCommand = "select top 10 productid,productname from products" runat="server"></asp:SqlDataSource>
        <br />
        <asp:SqlDataSource ID="SqlDataSource2" ConnectionString ="<%$ConnectionStrings:northwind %>" SelectCommand ="select top 10 unitsinstock,unitprice from products where productid=@productid " runat="server">
        <SelectParameters >
            <asp:ControlParameter Name ="productid" Type ="int32" ControlID ="DropDownList1" />
        </SelectParameters>
        </asp:SqlDataSource>
    </form>
</body>
</html>

文章来源:http://zhangkai0309.blog.163.com/blog/static/288848582008293234211
posted @ 2008-03-09 15:23  ChouKei  阅读(178)  评论(0)    收藏  举报