dmxadhoc.aspx

< SQL Server2005程序设计>

<%@ Page Language="C#" MasterPageFile="~/MMMaster.master" AutoEventWireup="true" CodeFile="DMXAdHoc.aspx.cs" Inherits="DMXViewer" Title="DMX Viewer" %>

<asp:Content ID="cphMain" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div>
        Server:
        <asp:TextBox ID="txtServer" runat="server">.</asp:TextBox>&nbsp;<asp:Button ID="btnGetCatalogs"
            runat="server" OnClick="btnGetCatalogs_Click" Text="Show Databases" />
        <asp:Label ID="lblCatalogs" runat="server" Text="Databases: " Visible="False"></asp:Label>&nbsp;<asp:DropDownList
            ID="ddlCatalogs" runat="server" Visible="False">
        </asp:DropDownList><br />
        <br />
        <asp:TextBox ID="txtQuery" runat="server" Height="185px" TextMode="MultiLine" Width="466px">SELECT TOP 250 t.FirstName, t.LastName, t.Phone, 
	   PredictProbability([Is Car Owner],'N') AS ProbNotCarOwner
FROM	CarOwner_DT 
PREDICTION JOIN 
	OPENQUERY([Adventure Works DW],
			  'SELECT c.FirstName,c.LastName,tc.* 
			   FROM vCustomerProfitability tc INNER JOIN dimCustomer c 
               ON tc.CustomerKey = c.CustomerKey') 
    AS t
    ON t.Gender = CarOwner_DT.Gender AND
	   t.IncomeGroup = CarOwner_dt.[Income Group] AND
	   t.MaritalStatus = CarOwner_dt.[Marital Status] AND
	   t.Region = CarOwner_dt.Region
ORDER BY PredictProbability([Is Car Owner],'N') DESC</asp:TextBox><br />
        &nbsp;<br />
        <asp:Button ID="btnExecute" runat="server" OnClick="btnExecute_Click" Text="Execute" Enabled="False" />
        <br />
        <br />
        <asp:GridView ID="gvResults" runat="server" BackColor="LightGoldenrodYellow" BorderColor="Tan"
            BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None">
            <PagerSettings Mode="NumericFirstLast" />
            <FooterStyle BackColor="Tan" />
            <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
            <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
            <HeaderStyle BackColor="Tan" Font-Bold="True" />
            <AlternatingRowStyle BackColor="PaleGoldenrod" />
        </asp:GridView>
    </div>
</asp:Content>