想要textbox显示数据库表中字段对应的值，可是偶下面的代码运行后，屏上只有空白框，没有取到数据库表中字段的值，要怎么改呢

Question

<form id="form1" runat="server">
   <EditItemTemplate>
  <table>
    <tr>
      <td align=right>
        <b>Employee ID:</b>
      </td>
      <td>
        <%# Eval("EmployeeID") %>
      </td>
    </tr>
    <tr>
      <td align=right>
        <b>First Name:</b>
      </td>
      <td>
        <asp:TextBox ID="EditFirstNameTextBox" RunAt="Server"
          Text='<%# Bind("FirstName") %>' />
      </td>
    </tr>
    <tr>
      <td align=right>
        <b>Last Name:</b>
      </td>
      <td>
        <asp:TextBox ID="EditLastNameTextBox" RunAt="Server"
            Text='<%# Bind("LastName") %>'  />
      </td>
    </tr>
    <tr>
      <td colspan="2">
        <asp:LinkButton ID="UpdateButton" RunAt="server"
          Text="Update" CommandName="Update" />
        &nbsp;
        <asp:LinkButton ID="CancelUpdateButton" RunAt="server"
          Text="Cancel" CommandName="Cancel" />
      </td>
    </tr>
  </table>
</EditItemTemplate>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:mr_08ConnectionString %>"
        SelectCommand="SELECT * FROM [xu]"></asp:SqlDataSource>
 </form>

---

maiyude

Answer 1

你用什么控件 只有编辑模板啊?

Answer 2

没有控件调用SqlDataSource1数据源

---

【孟子E章】

Answer 3

大大给看看，，，能否请您随便用啥控件，套用上面的代码就行。。。谢谢。。。

---

maiyude

Answer 4

      <asp:DataList ID="DataList1"  runat="server" DataSourceID="SqlDataSource1">
         <EditItemTemplate>
 <table>
    <tr>
      <td align=right>
        <b>Employee ID:</b>
      </td>
      <td>
        <%# Eval("EmployeeID") %>
      </td>
    </tr>
    <tr>
      <td align=right>
        <b>First Name:</b>
      </td>
      <td>
        <asp:TextBox ID="EditFirstNameTextBox" RunAt="Server"
          Text='<%# Bind("FirstName") %>' />
      </td>
    </tr>
    <tr>
      <td align=right>
        <b>Last Name:</b>
      </td>
      <td>
        <asp:TextBox ID="EditLastNameTextBox" RunAt="Server"
            Text='<%# Bind("LastName") %>'  />
      </td>
    </tr>
    <tr>
      <td colspan="2">
        <asp:LinkButton ID="UpdateButton" RunAt="server"
          Text="Update" CommandName="Update" />
        &nbsp;
        <asp:LinkButton ID="CancelUpdateButton" RunAt="server"
          Text="Cancel" CommandName="Cancel" />
      </td>
    </tr>
  </table>
</EditItemTemplate>

            <ItemTemplate>
                <asp:Button ID="Button2" runat="server" CommandName="Edit" Text="Button" />
            </ItemTemplate>

        </asp:DataList>
     <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:mr_08ConnectionString %>"
        SelectCommand="SELECT * FROM [xu]"></asp:SqlDataSource>

Answer 5

大大给看看，，，能否请您随便用啥控件，套用上面的代码就行。。。谢谢。。。

---

maiyude

      <asp:DataList ID="DataList1"  runat="server" DataSourceID="SqlDataSource1">
         <EditItemTemplate>
 <table>
    <tr>
      <td align=right>
        <b>Employee ID:</b>
      </td>
      <td>
        <%# Eval("EmployeeID") %>
      </td>
    </tr>
    <tr>
      <td align=right>
        <b>First Name:</b>
      </td>
      <td>
        <asp:TextBox ID="EditFirstNameTextBox" RunAt="Server"
          Text='<%# Bind("FirstName") %>' />
      </td>
    </tr>
    <tr>
      <td align=right>
        <b>Last Name:</b>
      </td>
      <td>
        <asp:TextBox ID="EditLastNameTextBox" RunAt="Server"
            Text='<%# Bind("LastName") %>'  />
      </td>
    </tr>
    <tr>
      <td colspan="2">
        <asp:LinkButton ID="UpdateButton" RunAt="server"
          Text="Update" CommandName="Update" />
        &nbsp;
        <asp:LinkButton ID="CancelUpdateButton" RunAt="server"
          Text="Cancel" CommandName="Cancel" />
      </td>
    </tr>
  </table>
</EditItemTemplate>

            <ItemTemplate>
                <asp:Button ID="Button2" runat="server" CommandName="Edit" Text="Button" />
            </ItemTemplate>

        </asp:DataList>
     <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:mr_08ConnectionString %>"
        SelectCommand="SELECT * FROM [xu]"></asp:SqlDataSource>

Answer 6

谢谢大大。。。。。

---

maiyude