急啊~~留言板回复内容修改问题

Question

前台代码
<asp:DataList ID="DataList_guest" runat="server" style="position: relative; left: 0px; top: 3px;" Height="3px" Width="762px" CellPadding="4"  ForeColor="#333333" OnItemDataBound="DataList_guest_ItemDataBound"  >
                         <ItemTemplate>
                        <div  align="left">
                       留言者：<%# DataBinder.Eval(Container.DataItem,"userName","{0}") %>
                       留言时间：<%# DataBinder.Eval(Container.DataItem,"postTime","{0}") %>
                       留言IP：<%# DataBinder.Eval(Container.DataItem,"IP","{0}") %>
                       </div>
                       <div align="right">
                        <asp:LinkButton ID="lbtnreply" runat="server" Style="position: relative" CommandArgument=<%# DataBinder.Eval(Container.DataItem,"ID","{0}") %> OnCommand="lbtnreply_Command">回复留言</asp:LinkButton>
                        <asp:LinkButton ID="lbtndel" runat="server" Style="position: relative" CommandArgument=<%# DataBinder.Eval(Container.DataItem,"ID","{0}") %> OnCommand="lbtndel_Command">删除留言</asp:LinkButton></div>
                        <hr />
                       <font color="#3399cc">
                       <div align="left">
                       留言信息：<%# DataBinder.Eval(Container.DataItem,"Contents","{0}") %>
                       </font>
                       <hr />
                       <font color="#cc0099">
                       回复信息：<%# DataBinder.Eval(Container.DataItem, "reply", "{0}")%><br />
                       </font></DIV>
                    </ItemTemplate> 
                            
                        <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                        <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                        <AlternatingItemStyle BackColor="White" />
                        <ItemStyle BackColor="#FFFBD6" ForeColor="#333333" />
                        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                        <SeparatorTemplate>
                            <hr />
                        </SeparatorTemplate>
                    </asp:DataList>后台绑定 public void databindlist()
    {
        string query = null;
        SqlConnection con = new SqlConnection(com.GetCon());
        int curpage = Convert.ToInt32(this.Label1.Text);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter();
        query = "select * from guest order by ID DESC";
        //query = "select * from guest where id in(select guestid from reverts )"; 
        sda.SelectCommand = new SqlCommand(query, con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "parent");
        query = "select * from reverts r inner join guest g on r.guestid=g.id";  //query = "select * from reverts";
        SqlCommand cmd = new SqlCommand(query, con);
        sda = new SqlDataAdapter(cmd);
        sda.Fill(ds, "child");
        ds.Relations.Add("reply", ds.Tables["parent"].Columns["id"], ds.Tables["child"].Columns["guestid"]);
        System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
        ps.DataSource = ds.Tables["parent"].DefaultView;
        ps.AllowPaging = true;
        ps.PageSize = 5;
        ps.CurrentPageIndex = curpage - 1;
        this.btnPre.Enabled = true;
        this.btnNext.Enabled = true;        if (curpage == 1)
        {
            this.btnPre.Enabled = false;
        }
        if (curpage == ps.PageCount)
        {
            this.btnNext.Enabled = false;
        }        this.DataList_guest.DataSource = ps;
        this.DataList_guest.DataBind();
        //获取总留言条数
        ToatalCountRecord = Convert.ToString(ps.PageCount);
        cmd = new SqlCommand("select count(*) from guest", con);
        this.Label2.Text = "总留言条数：" + Convert.ToString(cmd.ExecuteScalar()) + "条";
        con.Close();    }
是主从表,现在就是回复信息没显示,运行只显示了"System.Data.RelatedView",请各位大虾指点下,谢谢了

Answer 1

ds.Relations.Add("replyid", ds.Tables["parent"].Columns["id"], ds.Tables["child"].Columns["guestid"]); 
--------------------------
改下第一个参数的名字或者干脆不要看看

Answer 2

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlCommands1 sc1 = new SqlCommands1();
        sc1.upDate();
    }
    protected void Submit_Click(object sender, EventArgs e)
    {
        if (Page.IsPostBack)
        {
           SqlCommands1 sc1 = new SqlCommands1();
            sc1.inSert(textbox1.Text.ToString(),textbox2.Text.ToString());
            SqlDataReader sdr = sc1.upDate();
            rptShow.DataSource = sdr;
            rptShow.DataBind();
            sdr.Close();
            sdr.Dispose();
            textbox1.Text = "";
            textbox2.Text = "";        }
    }
    protected void LogOut_Click(object sender, EventArgs e)
    {
        textbox1.Text = "";
        textbox2.Text = "";
    }
    
}