簡易模式

<asp:DataList runat="server" DataSourceID="SqlDataSource1">
    <ItemTemplate>
        <asp:Label id="resda031" runat="server" Text='<%# Eval("resda031") %>' />
    </ItemTemplate>
</asp:DataList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TGEEF %>" SelectCommand="select resda031 from resda where resda002=@sheetNo">
    <SelectParameters>
        <asp:QueryStringParameter DefaultValue="aba" Name="sheetNo" QueryStringField="sheetNo" />
    </SelectParameters>
</asp:SqlDataSource>

進階模式

<asp:DataList runat="server" OnLoad="DataList_Load" Visible="false">
     <HeaderTemplate>
        Remarks
    </HeaderTemplate>
    <ItemTemplate>
        <asp:Label runat="server" Text='<%# Eval("INFO") %>' />
    </ItemTemplate>
</asp:DataList>
<script runat="server" language="C#">   
    protected void DataList_Load(object sender, EventArgs e)
    {
        string efPid = Request.QueryString["sheetNo"];
        if (efPid == null) return;
        string connectionString = ConfigurationManager.ConnectionStrings["TGEEF"].ConnectionString;

        string sql01 = string.Format("SELECT TTMA006, TTMA007 FROM TIPTOPMA WHERE TTMA003='{0}' ", efPid);
        SqlDataSource sds01 = new SqlDataSource( connectionString , sql01);
        System.Data.DataView dv = (System.Data.DataView)sds01.Select(DataSourceSelectArguments.Empty);
        if (dv.Table.Rows.Count != 1) return;
        string DBname = (string)dv.Table.Rows[0][1];
        string Pid = (string)dv.Table.Rows[0][0];

        //string sql02 = string.Format("Select INFO From OPENQUERY( [TOPPROD],'select OAO06 INFO FROM {0}.oao_file WHERE OAO01=''{1}'' ORDER BY OAO04, OAO06 ')", DBname, Pid);
        //SqlDataSource sds02 = new SqlDataSource( connectionString , sql02);

        string ORATTconnectionString = ConfigurationManager.ConnectionStrings["ORATT"].ConnectionString;
		string sql02 = string.Format("select PMP05 INFO FROM {0}.PMP_file WHERE PMP01='{1}' ORDER BY PMP03, PMP04", DBname, Pid);
		SqlDataSource sds02 = new SqlDataSource( ORATTconnectionString, sql02);
		sds02.ProviderName = "System.Data.Odbc";

        DataList datalist = ((DataList)sender);
        datalist.DataSource = sds02;
        datalist.DataBind();
        if (datalist.Items.Count > 0) datalist.Visible = true;
    }
</script>