数据列表查找控件 [英] datalist find control

查看:67
本文介绍了数据列表查找控件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我在DataList1中有一个数据列表控件调用DataList1和另一个数据列表控件调用DataList3.现在我在datalist3中有一张图像,必须在运行时为其设置可见性.
我在PageLoad上编写了以下代码:

 // 在DataList3中搜索记录
       如果((((DataList)(DataList1.Items [ 0 ].FindControl(  DataList3")))).Items.Count  0 )
       {
           // ,如果没有找到记录,则显示Image20而不是DataList3 
           (((DataList)(DataList1.Items [ 0 ].FindControl(" )))).可见=  false ;
           (((System.Web.UI.WebControls.Image)(DataList1.Items [ 0 ].FindControl("  Image40"))))).Visible = 其他
       {
           // 如果找到的记录比显示DtaList3而不是Image20 
           (((DataList)(DataList1.Items [ 0 ].FindControl(" )))).可见=  true ;
           (((System.Web.UI.WebControls.Image)(DataList1.Items [ 0 ].FindControl("  Image40"))))).可见= =  使用系统;
使用 System.Data;
使用 System.Configuration;
使用 System.Collections;
使用 System.Web;
使用 System.Web.Security;
使用 System.Web.UI;
使用使用System.Web.UI.WebControls;
使用 System.Web.UI.WebControls.WebParts;
使用 System.Web.UI.HtmlControls;
使用 System.Data.SqlClient;
使用 System.Data.Sql;
使用 System.IO;

公共 部分  free_user_ReceivedInterestPending:System.Web .UI.页面
{
    受保护的 无效 Page_Load(对象发​​件人,EventArgs e)
    {
        

        // 在DataList3中搜索记录
        如果((((DataList)(DataList1.Items [ 0 ].FindControl(  DataList3")))).Items.Count  0 )
        {
            // ,如果没有找到记录,则显示Image20而不是DataList3 
            (((DataList)(DataList1.Items [ 0 ].FindControl(" )))).可见=  false ;
            (((System.Web.UI.WebControls.Image)(DataList1.Items [ 0 ].FindControl("  Image40"))))).Visible = 其他
        {
            // 如果找到的记录比显示DtaList3而不是Image20 
            (((DataList)(DataList1.Items [ 0 ].FindControl(" )))).可见=  true ;
            (((System.Web.UI.WebControls.Image)(DataList1.Items [ 0 ].FindControl("  Image40"))))).可见= = < asp:DataList ID = "  runat = "  DataKeyField = "  sr"
                    DataSourceID = "  Width = "  100%" onload =   DataList1_Load" > 
                    < itemtemplate>
                        < table  = "  > 
                            样式:" 
                            width = "  > 
                            < tr>
                                < td bgcolor = "   = "  colspan = "  4" style =   vertical-align:top" > 
                                    < span  class  = "  > 
                                    < table  = "  > 
                                        < tr>
                                            < td  = "  > 
                                                </  td  > 
                                            < td  class  = "  > 
                                                < asp:标签ID = "  runat =  "  style = " ' <%#Eval("UserFrom")%>'/>
                                            </  td  > 
                                            < td  = "  > 
                                                < asp:FormView ID = "  runat =  "  DataKeyNames = " 
                                                    DataSourceID = "  > 
                                                    < edititemtemplate>
                                                        SR:
                                                        < asp:标签ID = "  runat =  "  Text = ' < %#Eval("sr")%>'/>
                                                        < br/>
                                                        < asp:LinkBut​​ton ID = "  runat =  "  CausesValidation = " 
                                                            CommandName = " 文本= " 更新"/>
                                                        < asp:LinkBut​​ton ID = "  runat =  " 
                                                            CausesValidation = "  CommandName = " 取消" Text =  取消"/>
                                                    </  edititemtemplate  > 
                                                    < insertitemtemplate>
                                                        < asp:LinkBut​​ton ID = "  runat =  "  CausesValidation = " 
                                                            CommandName = "  Text = " 插入"/>
                                                        < asp:LinkBut​​ton ID = "  runat =  " 
                                                            CausesValidation = "  CommandName = " 取消" Text =  取消"/>
                                                    </  insertitemtemplate  > 
                                                    < itemtemplate>
                                                        < span  class  = "  > UserId:</  span  > 
                                                        < asp:标签ID = "  runat =  "  CssClass = " 
                                                            Text = ' <%#Eval("sr")%>'/>
                                                        < br/>
                                                    </  itemtemplate  > 
                                                
                                            </  td  > 
                                            < td  class  = "  > 
                                                </  td  > 
                                            < td  = "  > 
                                                < asp:CheckBox ID = "  runat =  "  CssClass = " 
                                                    Text = " />
                                            </  td  > 
                                            < td  class  = "  > 
                                                < asp:CheckBox ID = "  runat =  "  CssClass = " 
                                                    Text = " />
                                            </  td  > 
                                            < td  class  = "  > 
                                                < asp:CheckBox ID = "  runat =  "  CssClass = " 
                                                    Text = " />
                                            </  td  > 
                                        </  tr  > 
                                    </  > 
                                    </  span  > 
                                </  td  > 
                            </  tr  > 
                            < tr>
                                < td  class  = "  style = "  >> 
                                </  td  > 
                                < td  = "  style = "  >> 
                                    < asp:TextBox ID = "  runat =  "  > 
                                </  td  > 
                                < td  class  = "  style = "  >> 
                                </  td  > 
                                < td  class  = "  style = "  >> 
                                    </  td  > 
                            </  tr  > 
                            < tr>
                                < td  = "  style = "  >> 
                                </  td  > 
                                < td  class  = "  style = "  >> 
                                    < asp:图片ID = "  runat =  "  Height = " 
                                        ImageUrl = "  Width = " />
                                    < asp:DataList ID = "  runat =  "  DataKeyField = " 
                                        DataSourceID = "  Width = "  150px" "  runat =  "  Height = " 
                                                ImageUrl = ' <%#"ImageHandler.ashx?ImID =" + Eval("sr")%>" Width = " />
                                            < br/>
                                        </  itemtemplate  > 
                                    
                                    < asp:SqlDataSource ID = "  runat =  " 
                                        ConnectionString = " 
                                        SelectCommand = "  > 
                                        < SelectParameters>
                                            < asp:ControlParameter ControlID = "  Name =  " 
                                                PropertyName = "  Type = " 字符串"/>
                                        </  SelectParameters  > 
                                    
                                    < asp:SqlDataSource ID = "  runat =  " 
                                        ConnectionString = " 
                                        SelectCommand = "  > 
                                        < SelectParameters>
                                            < asp:ControlParameter ControlID = "  Name =  " 
                                                PropertyName = "  Type = " 字符串"/>
                                        </  SelectParameters  > 
                                    
                                </  td  > 
                                < td  class  = "  style = "  >> 
                                </  td  > 
                                < td  = "  style = "  >> 
                                    < asp:DataList ID = "  runat =  "  DataKeyField = " 
                                        DataSourceID = "  Width = "  100%"  = "  > 
                                                style = "  > 
                                                < tr>
                                                    < td  class  = "  colspan = "  > 
                                                        </  td  > 
                                                </  tr  > 
                                                < tr>
                                                    < td  class  = "  > 
                                                        名称</  td  > 
                                                    < td  = "  > 
                                                        :</  td  > 
                                                    < td  class  = "  > 
                                                        < asp:标签ID = "  runat =  "  CssClass = " 
                                                            Text = ' <%#Eval("Name")%>'/>
                                                        < asp:标签ID = "  runat =  "  CssClass = " 
                                                            Text = ' <%#Eval("MiddleName")%>'/>
                                                        < asp:标签ID = "  runat =  "  CssClass = " 
                                                            Text = ' <%#Eval("LastName")%>'/>
                                                    </  td  > 
                                                </  tr  > 
                                                < tr>
                                                    < td  class  = "  > 
                                                        年龄</  td  > 
                                                    < td  = "  > 
                                                        :</  td  > 
                                                    < td  class  = "  > 
                                                        < asp:标签ID = "  runat =  "  CssClass = " 
                                                            style = "  Text = '  <%#Eval("Age")%>'/>
                                                    </  td  > 
                                                </  tr  > 
                                                < tr>
                                                    < td  class  = "  > 
                                                        宗教</  td  > 
                                                    < td  = "  > 
                                                        :</  td  > 
                                                    < td  class  = "  > 
                                                        < asp:标签ID = "  runat =  "  CssClass = " 
                                                            style = "  Text = '  <%#Eval(宗教")%>'/>
                                                    </  td  > 
                                                </  tr  > 
                                                < tr>
                                                    < td  class  = "  > 
                                                        种姓
                                                    </  td  > 
                                                    < td  = "  > 
                                                        :</  td  > 
                                                    < td  class  = "  > 
                                                        < asp:标签ID = "  runat =  "  CssClass = " 
                                                            style = "  Text = '  <%#Eval("Caste")%>'/>
                                                    </  td  > 
                                                </  tr  > 
                                                < tr>
                                                    < td  class  = "  > 
                                                        权重</  td  > 
                                                    < td  = "  > 
                                                        :</  td  > 
                                                    < td  class  = "  > 
                                                        < asp:标签ID = "  runat =  "  CssClass = " 
                                                            style = "  Text = '  <%#Eval("Weight")%>'/>
                                                    </  td  > 
                                                </  tr  > 
                                                < tr>
                                                    < td  class  = "  > 
                                                        身高</  td  > 
                                                    < td  = "  > 
                                                        :</  td  > 
                                                    < td  class  = "  > 
                                                        < asp:标签ID = "  runat =  "  CssClass = " 
                                                            style = "  Text = '  <%#Eval("Height")%>'/>
                                                    </  td  > 
                                                </  tr  > 
                                                < tr>
                                                    < td  class  = "  > 
                                                        教育</  td  > 
                                                    < td  = "  > 
                                                        :</  td  > 
                                                    < td  class  = "  > 
                                                        < asp:标签ID = "  runat =  "  CssClass = " 
                                                            style = "  Text = '  <%#Eval("Education")%>'/>
                                                    </  td  > 
                                                </  tr  > 
                                                < tr>
                                                    < td  class  = "  > 
                                                        职业</  td  > 
                                                    < td  = "  > 
                                                        :</  td  > 
                                                    < td  class  = "  > 
                                                        < asp:标签ID = "  runat =  "  CssClass = " 
                                                            style = "  Text = '  <%#Eval(职业")%>'/>
                                                    </  td  > 
                                                </  tr  > 
                                                < tr>
                                                    < td  class  = "  > 
                                                        位置</  td  > 
                                                    < td  = "  > 
                                                        :</  td  > 
                                                    < td  class  = "  > 
                                                        
                                                        < asp:标签ID = "  runat =  "  Text = ' < %#Eval(国家/地区")%>'/>
                                                        ,< asp:标签ID = "  runat = "  Text = ' < ;%#Eval("state")%>'/>
                                                        ,< asp:标签ID = "  runat = "  Text = ' < ;%#Eval("city")%>'/>
                                                        
                                                    </  td  > 
                                                </  tr  > 
                                                < tr>
                                                    < td  = "  colspan = "  > 
                                                        < table  = "  > 
                                                            style = "  > 
                                                            < tr>
                                                                < td  = "  style = "  >> 
                                                                    < asp:HyperLink ID = "  runat =  "  Font-Underline = " 
                                                                        NavigateUrl = ' <%#Eval("UserName",〜/付费用户/viewFullProfile.aspx?UserName= { 0})%>'
                                                                        style = " >查看完整的配置文件
                                                                </  td  > 
                                                                < td  class  = "  style = "  >> 
                                                                    < asp:HyperLink ID = "  runat =  "  Font-Strikeout = " 
                                                                        NavigateUrl = ' <%#Eval("UserName",〜/付费用户/sendMessage.aspx?UserName= { 0})%>'
                                                                        style = " >个人消息
                                                                </  td  > 
                                                                < td  class  = "  style = "  >> 
                                                                    </  td  > 
                                                            </  tr  > 
                                                        </  > 
                                                    </  td  > 
                                                </  tr  > 
                                            </  > 
                                        </  itemtemplate  > 
                                    
                                    < br/>
                                    < asp:TextBox ID = "  runat =  "  > 
                                </  td  > 
                            </  tr  > 
                            < tr>
                                < td  = "  style = "  >> 
                                    </  td  > 
                                < td  = "  colspan = "  > 
                                    style = "   = "  >  消息:</ > 
                                    < asp:标签ID = "  runat =  "  Text = ' < %#Eval(消息")%>'
                                        style = " />
                                </  td  > 
                            </  tr  > 
                            < tr>
                                < td  class  = "  style = "  >> 
                                </  td  > 
                                < td  = "  colspan="3">
                                </  td  > 
                            </  tr  > 
                        </  > 
                        <asp:SqlDataSource ID="SqlDataSource10" runat="server" 
                            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                            SelectCommand="SELECT * FROM [tbl_FreeUserProfile] WHERE ([UserName] = @UserName)">
                            < SelectParameters>
                                <asp:ControlParameter ControlID="UserFromLabel" Name="UserName" 
                                    PropertyName="Text" Type="String"/>
                            </SelectParameters>
                        
                    </itemtemplate>

解决方案

ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [tbl_Image1] WHERE ([UserName] = @UserName)"> < SelectParameters> <asp:ControlParameter ControlID="UserFromLabel" Name="UserName" PropertyName="Text" Type="String"/> </SelectParameters> <asp:SqlDataSource ID="SqlDataSource15" runat="server" ConnectionString="<%


ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [sr] FROM [tbl_FreeUserProfile] WHERE ([UserName] = @UserName)"> < SelectParameters> <asp:ControlParameter ControlID="UserFromLabel" Name="UserName" PropertyName="Text" Type="String"/> </SelectParameters> </ td > <td class="style714" style="vertical-align: top"> </ td > <td class="style716" style="vertical-align: top"> <asp:DataList ID="DataList4" runat="server" DataKeyField="sr" DataSourceID="SqlDataSource10" Width="100%"> < itemtemplate> <table class="style472"> style="font-family: 'Trebuchet MS'; font-size: 10pt; height: 44px;"> < tr> <td class="style719" colspan="3"> </ td > </ tr > < tr> <td class="style805"> Name</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="NameLabel" runat="server" CssClass="style750" Text='<%# Eval("Name") %>'/>  <asp:Label ID="MiddleNameLabel0" runat="server" CssClass="style750" Text='<%# Eval("MiddleName") %>'/>  <asp:Label ID="LastNameLabel1" runat="server" CssClass="style750" Text='<%# Eval("LastName") %>'/> </ td > </ tr > < tr> <td class="style805"> Age</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="AgeLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Age") %>'/> </ td > </ tr > < tr> <td class="style805"> Religion</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="ReligionLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Religion") %>'/> </ td > </ tr > < tr> <td class="style805"> Caste </ td > <td class="style694"> :</td> <td class="style720"> <asp:Label ID="CasteLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Caste") %>'/> </ td > </ tr > < tr> <td class="style805"> Weight</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="WeightLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Weight") %>'/> </ td > </ tr > < tr> <td class="style805"> Height</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="HeightLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Height") %>'/> </ td > </ tr > < tr> <td class="style805"> Education</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="EducationLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Education") %>'/> </ td > </ tr > < tr> <td class="style805"> Occupation</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="OccupationLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Occupation") %>'/> </ td > </ tr > < tr> <td class="style805"> Location</td> <td class="style694"> :</td> <td class="style721"> <asp:Label ID="CountryLabel" runat="server" Text='<%# Eval("Country") %>'/> , <asp:Label ID="stateLabel" runat="server" Text='<%# Eval("state") %>'/> , <asp:Label ID="cityLabel" runat="server" Text='<%# Eval("city") %>'/> </ td > </ tr > < tr> <td class="style705" colspan="3"> <table class="style472"> style="font-family: 'Trebuchet MS'; font-size: 10pt; height: 6px;"> < tr> <td class="style810" style="text-align: left"> <asp:HyperLink ID="HyperLink34" runat="server" Font-Underline="False" NavigateUrl='<%# Eval("UserName","~/paid user/viewFullProfile.aspx?UserName={0}") %>' style="color: #003399">View Full Profile </ td > <td class="style700" style="text-align: left"> <asp:HyperLink ID="HyperLink33" runat="server" Font-Strikeout="False" NavigateUrl='<%# Eval("UserName","~/paid user/sendMessage.aspx?UserName={0}") %>' style="color: #CC6600">Personal Message </ td > <td class="style704" style="text-align: left"> </ td > </ tr > </ > </ td > </ tr > </ > </ itemtemplate > < br/> <asp:TextBox ID="TextBox21" runat="server"> </ td > </ tr > < tr> <td class="style713" style="vertical-align: top"> </ td > <td class="style712" colspan="3"> style="vertical-align: top; border-top-style: dashed; border-top-width: thin; border-top-color: #808080;"> <span class="style813">Message:</span> <asp:Label ID="MessageLabel" runat="server" Text='<%# Eval("Message") %>' style="font-family: 'Trebuchet MS'"/> </ td > </ tr > < tr> <td class="style807" style="vertical-align: top"> </ td > <td class="style808" colspan="3"> </ td > </ tr > </ > <asp:SqlDataSource ID="SqlDataSource10" runat="server" ConnectionString="<%


ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [tbl_FreeUserProfile] WHERE ([UserName] = @UserName)"> < SelectParameters> <asp:ControlParameter ControlID="UserFromLabel" Name="UserName" PropertyName="Text" Type="String"/> </SelectParameters> </itemtemplate>


i have one datalist control call DataList1 and another datalist control call DataList3 inside DataList1. Now i have one image inside datalist3 for which i have to set visibility at runtime.
i have written the following code on PageLoad:

//search for records in DataList3
       if (((DataList)(DataList1.Items[0].FindControl("DataList3"))).Items.Count <= 0)
       {
           //if no records found than display Image20 instead of DataList3
           ((DataList)(DataList1.Items[0].FindControl("DataList3"))).Visible = false;
           ((System.Web.UI.WebControls.Image)(DataList1.Items[0].FindControl("Image40"))).Visible = true;
       }
       else
       {
           //if records found than display DtaList3 instead of Image20
           ((DataList)(DataList1.Items[0].FindControl("DataList3"))).Visible = true;
           ((System.Web.UI.WebControls.Image)(DataList1.Items[0].FindControl("Image40"))).Visible = false;
       }



but i don''t find any required results. both image and datalist are displaying in both case.
any guidance will be helpful.


my whole pageload

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.Sql;
using System.IO;

public partial class free_user_ReceivedInterestPending : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        

        //search for records in DataList3
        if (((DataList)(DataList1.Items[0].FindControl("DataList3"))).Items.Count <= 0)
        {
            //if no records found than display Image20 instead of DataList3
            ((DataList)(DataList1.Items[0].FindControl("DataList3"))).Visible = false;
            ((System.Web.UI.WebControls.Image)(DataList1.Items[0].FindControl("Image40"))).Visible = true;
        }
        else
        {
            //if records found than display DtaList3 instead of Image20
            ((DataList)(DataList1.Items[0].FindControl("DataList3"))).Visible = true;
            ((System.Web.UI.WebControls.Image)(DataList1.Items[0].FindControl("Image40"))).Visible = false;
        }
        
        
        
    }
    
}




datalist1 binding

<asp:DataList ID="DataList1" runat="server" DataKeyField="sr" 
                    DataSourceID="SqlDataSource9" Width="100%" onload="DataList1_Load">
                    <itemtemplate>
                        <table class="style472">
                            style="border: medium solid #669999; font-family: Verdana; font-size: 10pt; height: 281px;" 
                            width="100%">
                            <tr>
                                <td bgcolor="#669999" class="style697" colspan="4" style="vertical-align: top">
                                    <span class="style696">
                                    <table class="style472">
                                        <tr>
                                            <td class="style793">
                                                 </td>
                                            <td class="style790">
                                                <asp:Label ID="UserFromLabel" runat="server" style="font-weight: 700" 
                                                    Text='<%# Eval("UserFrom") %>' />
                                            </td>
                                            <td class="style797">
                                                <asp:FormView ID="FormView1" runat="server" DataKeyNames="sr" 
                                                    DataSourceID="SqlDataSource15">
                                                    <edititemtemplate>
                                                        sr:
                                                        <asp:Label ID="srLabel1" runat="server" Text='<%# Eval("sr") %>' />
                                                        <br />
                                                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 
                                                            CommandName="Update" Text="Update" />
                                                         <asp:LinkButton ID="UpdateCancelButton" runat="server" 
                                                            CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                                                    </edititemtemplate>
                                                    <insertitemtemplate>
                                                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 
                                                            CommandName="Insert" Text="Insert" />
                                                         <asp:LinkButton ID="InsertCancelButton" runat="server" 
                                                            CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                                                    </insertitemtemplate>
                                                    <itemtemplate>
                                                        <span class="style696">UserId: </span>
                                                        <asp:Label ID="srLabel2" runat="server" CssClass="style696" 
                                                            Text='<%# Eval("sr") %>' />
                                                        <br />
                                                    </itemtemplate>
                                                
                                            </td>
                                            <td class="style794">
                                                 </td>
                                            <td class="style792">
                                                <asp:CheckBox ID="CheckBox5" runat="server" CssClass="style791" 
                                                    Text="Bookmark" />
                                            </td>
                                            <td class="style698">
                                                <asp:CheckBox ID="CheckBox6" runat="server" CssClass="style791" 
                                                    Text="Send Profile to Friend" />
                                            </td>
                                            <td class="style678">
                                                <asp:CheckBox ID="CheckBox7" runat="server" CssClass="style791" 
                                                    Text="Block Profile" />
                                            </td>
                                        </tr>
                                    </table>
                                    </span>
                                </td>
                            </tr>
                            <tr>
                                <td class="style718" style="vertical-align: top">
                                </td>
                                <td class="style801" style="vertical-align: top">
                                    <asp:TextBox ID="TextBox22" runat="server">
                                </td>
                                <td class="style718" style="vertical-align: top">
                                </td>
                                <td class="style718" style="vertical-align: top">
                                     </td>
                            </tr>
                            <tr>
                                <td class="style713" style="vertical-align: top">
                                </td>
                                <td class="style802" style="vertical-align: top">
                                    <asp:Image ID="Image40" runat="server" Height="144px" 
                                        ImageUrl="~/images/contactus1.png" Width="148px" />
                                    <asp:DataList ID="DataList3" runat="server" DataKeyField="sr" 
                                        DataSourceID="SqlDataSource14" Width="150px">
                                        <itemtemplate>
                                            <asp:Image ID="Image39" runat="server" Height="144px" 
                                                ImageUrl='<%# "ImageHandler.ashx?ImID="+ Eval("sr")  %>' Width="148px" />
                                            <br />
                                        </itemtemplate>
                                    
                                    <asp:SqlDataSource ID="SqlDataSource14" runat="server" 
                                        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                                        SelectCommand="SELECT * FROM [tbl_Image1] WHERE ([UserName] = @UserName)">
                                        <SelectParameters>
                                            <asp:ControlParameter ControlID="UserFromLabel" Name="UserName" 
                                                PropertyName="Text" Type="String" />
                                        </SelectParameters>
                                    
                                    <asp:SqlDataSource ID="SqlDataSource15" runat="server" 
                                        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                                        SelectCommand="SELECT [sr] FROM [tbl_FreeUserProfile] WHERE ([UserName] = @UserName)">
                                        <SelectParameters>
                                            <asp:ControlParameter ControlID="UserFromLabel" Name="UserName" 
                                                PropertyName="Text" Type="String" />
                                        </SelectParameters>
                                    
                                </td>
                                <td class="style714" style="vertical-align: top">
                                </td>
                                <td class="style716" style="vertical-align: top">
                                    <asp:DataList ID="DataList4" runat="server" DataKeyField="sr" 
                                        DataSourceID="SqlDataSource10" Width="100%">
                                        <itemtemplate>
                                            <table class="style472">
                                                style="font-family: 'Trebuchet MS'; font-size: 10pt; height: 44px;">
                                                <tr>
                                                    <td class="style719" colspan="3">
                                                         </td>
                                                </tr>
                                                <tr>
                                                    <td class="style805">
                                                        Name</td>
                                                    <td class="style694">
                                                        :</td>
                                                    <td class="style720">
                                                        <asp:Label ID="NameLabel" runat="server" CssClass="style750" 
                                                            Text='<%# Eval("Name") %>' />
                                                         <asp:Label ID="MiddleNameLabel0" runat="server" CssClass="style750" 
                                                            Text='<%# Eval("MiddleName") %>' />
                                                         <asp:Label ID="LastNameLabel1" runat="server" CssClass="style750" 
                                                            Text='<%# Eval("LastName") %>' />
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td class="style805">
                                                        Age</td>
                                                    <td class="style694">
                                                        :</td>
                                                    <td class="style720">
                                                        <asp:Label ID="AgeLabel" runat="server" CssClass="style710" 
                                                            style="font-size: 9pt" Text='<%# Eval("Age") %>' />
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td class="style805">
                                                        Religion</td>
                                                    <td class="style694">
                                                        :</td>
                                                    <td class="style720">
                                                        <asp:Label ID="ReligionLabel" runat="server" CssClass="style710" 
                                                            style="font-size: 9pt" Text='<%# Eval("Religion") %>' />
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td class="style805">
                                                        Caste
                                                    </td>
                                                    <td class="style694">
                                                        :</td>
                                                    <td class="style720">
                                                        <asp:Label ID="CasteLabel" runat="server" CssClass="style710" 
                                                            style="font-size: 9pt" Text='<%# Eval("Caste") %>' />
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td class="style805">
                                                        Weight</td>
                                                    <td class="style694">
                                                        :</td>
                                                    <td class="style720">
                                                        <asp:Label ID="WeightLabel" runat="server" CssClass="style710" 
                                                            style="font-size: 9pt" Text='<%# Eval("Weight") %>' />
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td class="style805">
                                                        Height</td>
                                                    <td class="style694">
                                                        :</td>
                                                    <td class="style720">
                                                        <asp:Label ID="HeightLabel" runat="server" CssClass="style710" 
                                                            style="font-size: 9pt" Text='<%# Eval("Height") %>' />
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td class="style805">
                                                        Education</td>
                                                    <td class="style694">
                                                        :</td>
                                                    <td class="style720">
                                                        <asp:Label ID="EducationLabel" runat="server" CssClass="style710" 
                                                            style="font-size: 9pt" Text='<%# Eval("Education") %>' />
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td class="style805">
                                                        Occupation</td>
                                                    <td class="style694">
                                                        :</td>
                                                    <td class="style720">
                                                        <asp:Label ID="OccupationLabel" runat="server" CssClass="style710" 
                                                            style="font-size: 9pt" Text='<%# Eval("Occupation") %>' />
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td class="style805">
                                                        Location</td>
                                                    <td class="style694">
                                                        :</td>
                                                    <td class="style721">
                                                        
                                                        <asp:Label ID="CountryLabel" runat="server" Text='<%# Eval("Country") %>' />
                                                        , <asp:Label ID="stateLabel" runat="server" Text='<%# Eval("state") %>' />
                                                        , <asp:Label ID="cityLabel" runat="server" Text='<%# Eval("city") %>' />
                                                        
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td class="style705" colspan="3">
                                                        <table class="style472">
                                                            style="font-family: 'Trebuchet MS'; font-size: 10pt; height: 6px;">
                                                            <tr>
                                                                <td class="style810" style="text-align: left">
                                                                    <asp:HyperLink ID="HyperLink34" runat="server" Font-Underline="False" 
                                                                        NavigateUrl='<%# Eval("UserName","~/paid user/viewFullProfile.aspx?UserName={0}") %>' 
                                                                        style="color: #003399">View Full Profile
                                                                </td>
                                                                <td class="style700" style="text-align: left">
                                                                    <asp:HyperLink ID="HyperLink33" runat="server" Font-Strikeout="False" 
                                                                        NavigateUrl='<%# Eval("UserName","~/paid user/sendMessage.aspx?UserName={0}") %>' 
                                                                        style="color: #CC6600">Personal Message
                                                                </td>
                                                                <td class="style704" style="text-align: left">
                                                                     </td>
                                                            </tr>
                                                        </table>
                                                    </td>
                                                </tr>
                                            </table>
                                        </itemtemplate>
                                    
                                    <br />
                                    <asp:TextBox ID="TextBox21" runat="server">
                                </td>
                            </tr>
                            <tr>
                                <td class="style713" style="vertical-align: top">
                                     </td>
                                <td class="style712" colspan="3">
                                    style="vertical-align: top; border-top-style: dashed; border-top-width: thin; border-top-color: #808080;">
                                    <span class="style813">Message:</span>
                                    <asp:Label ID="MessageLabel" runat="server" Text='<%# Eval("Message") %>' 
                                        style="font-family: 'Trebuchet MS'" />
                                </td>
                            </tr>
                            <tr>
                                <td class="style807" style="vertical-align: top">
                                </td>
                                <td class="style808" colspan="3">
                                </td>
                            </tr>
                        </table>
                        <asp:SqlDataSource ID="SqlDataSource10" runat="server" 
                            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                            SelectCommand="SELECT * FROM [tbl_FreeUserProfile] WHERE ([UserName] = @UserName)">
                            <SelectParameters>
                                <asp:ControlParameter ControlID="UserFromLabel" Name="UserName" 
                                    PropertyName="Text" Type="String" />
                            </SelectParameters>
                        
                    </itemtemplate>

解决方案

ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [tbl_Image1] WHERE ([UserName] = @UserName)"> <SelectParameters> <asp:ControlParameter ControlID="UserFromLabel" Name="UserName" PropertyName="Text" Type="String" /> </SelectParameters> <asp:SqlDataSource ID="SqlDataSource15" runat="server" ConnectionString="<%


ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [sr] FROM [tbl_FreeUserProfile] WHERE ([UserName] = @UserName)"> <SelectParameters> <asp:ControlParameter ControlID="UserFromLabel" Name="UserName" PropertyName="Text" Type="String" /> </SelectParameters> </td> <td class="style714" style="vertical-align: top"> </td> <td class="style716" style="vertical-align: top"> <asp:DataList ID="DataList4" runat="server" DataKeyField="sr" DataSourceID="SqlDataSource10" Width="100%"> <itemtemplate> <table class="style472"> style="font-family: 'Trebuchet MS'; font-size: 10pt; height: 44px;"> <tr> <td class="style719" colspan="3">  </td> </tr> <tr> <td class="style805"> Name</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="NameLabel" runat="server" CssClass="style750" Text='<%# Eval("Name") %>' />  <asp:Label ID="MiddleNameLabel0" runat="server" CssClass="style750" Text='<%# Eval("MiddleName") %>' />  <asp:Label ID="LastNameLabel1" runat="server" CssClass="style750" Text='<%# Eval("LastName") %>' /> </td> </tr> <tr> <td class="style805"> Age</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="AgeLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Age") %>' /> </td> </tr> <tr> <td class="style805"> Religion</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="ReligionLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Religion") %>' /> </td> </tr> <tr> <td class="style805"> Caste </td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="CasteLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Caste") %>' /> </td> </tr> <tr> <td class="style805"> Weight</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="WeightLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Weight") %>' /> </td> </tr> <tr> <td class="style805"> Height</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="HeightLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Height") %>' /> </td> </tr> <tr> <td class="style805"> Education</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="EducationLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Education") %>' /> </td> </tr> <tr> <td class="style805"> Occupation</td> <td class="style694"> :</td> <td class="style720"> <asp:Label ID="OccupationLabel" runat="server" CssClass="style710" style="font-size: 9pt" Text='<%# Eval("Occupation") %>' /> </td> </tr> <tr> <td class="style805"> Location</td> <td class="style694"> :</td> <td class="style721"> <asp:Label ID="CountryLabel" runat="server" Text='<%# Eval("Country") %>' /> , <asp:Label ID="stateLabel" runat="server" Text='<%# Eval("state") %>' /> , <asp:Label ID="cityLabel" runat="server" Text='<%# Eval("city") %>' /> </td> </tr> <tr> <td class="style705" colspan="3"> <table class="style472"> style="font-family: 'Trebuchet MS'; font-size: 10pt; height: 6px;"> <tr> <td class="style810" style="text-align: left"> <asp:HyperLink ID="HyperLink34" runat="server" Font-Underline="False" NavigateUrl='<%# Eval("UserName","~/paid user/viewFullProfile.aspx?UserName={0}") %>' style="color: #003399">View Full Profile </td> <td class="style700" style="text-align: left"> <asp:HyperLink ID="HyperLink33" runat="server" Font-Strikeout="False" NavigateUrl='<%# Eval("UserName","~/paid user/sendMessage.aspx?UserName={0}") %>' style="color: #CC6600">Personal Message </td> <td class="style704" style="text-align: left">  </td> </tr> </table> </td> </tr> </table> </itemtemplate> <br /> <asp:TextBox ID="TextBox21" runat="server"> </td> </tr> <tr> <td class="style713" style="vertical-align: top">  </td> <td class="style712" colspan="3"> style="vertical-align: top; border-top-style: dashed; border-top-width: thin; border-top-color: #808080;"> <span class="style813">Message:</span> <asp:Label ID="MessageLabel" runat="server" Text='<%# Eval("Message") %>' style="font-family: 'Trebuchet MS'" /> </td> </tr> <tr> <td class="style807" style="vertical-align: top"> </td> <td class="style808" colspan="3"> </td> </tr> </table> <asp:SqlDataSource ID="SqlDataSource10" runat="server" ConnectionString="<%


ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [tbl_FreeUserProfile] WHERE ([UserName] = @UserName)"> <SelectParameters> <asp:ControlParameter ControlID="UserFromLabel" Name="UserName" PropertyName="Text" Type="String" /> </SelectParameters> </itemtemplate>


这篇关于数据列表查找控件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆