数据源“SqlDataSource1”仅支持名为“DefaultView”的单个视图。您也可以将视图名称(也称为数据成员)保留为空以选择默认视图

Question

  <form id="form1" runat="server">
    <div>
        <asp:Repeater ID="Repeater1" runat="server" DataMember="id" 
            DataSourceID="SqlDataSource1">
            <HeaderTemplate>
                <table>
                    <tr>
                        <th>
                            Movie Title
                        </th>
                        <th>
                            Movie Direction
                        </th>
                    </tr>
            </HeaderTemplate>
            <ItemTemplate>
                <tr>
                    <td>
                        <%# Eval("title") %>
                    </td>
                    <td>
                        <%# Eval("director")%>
                    </td>
                </tr>
            </ItemTemplate>
            <AlternatingItemTemplate>
                <tr>
                    <td>
                        <%# Eval("title") %>
                    </td>
                    <td>
                        <%# Eval("director")%>
                    </td>
                </tr>
            </AlternatingItemTemplate>
            <FooterTemplate>
                </table>
            </FooterTemplate>
        </asp:Repeater>
    </div>
    </form>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:UnleashedString %>" 
        SelectCommand="SELECT [title], [director] FROM [Movies]"></asp:SqlDataSource>我的代码就是这样，请问这个bug是怎么回事，小弟不胜了解。

Answer 1

<asp:Repeater ID="Repeater1" runat="server" DataMember="id" 
            DataSourceID="SqlDataSource1">
不要 DataMember="id" 属性

Answer 2

也可以不用SqlDataSource,手动绑定
SqlConnection connect = new SqlConnection("连接字符串");
SqlDataAdapter adapter = new SqlDataAdapter("select * from table1", connect);
DataTable table = new DataTable();
adapter.Fill(table);
this.Repeater1.DataSource = table.DefaultView;
this.Repeater1.DataBind();