急！！！这段代码是根据什么来判断留言是否成功的？？？

[qq_33001897]

protected void Page_Load(object sender, EventArgs e)
{
if (Session["admin"] != null) //如果当前身份为非管理员登陆
{
admin_go.Text = "退出管理";
admin_go.NavigateUrl = "exit.aspx";
}
if (!this.IsPostBack)
{
string ToPage = Request.QueryString["ToPage"];
if (ToPage == null)
{
ToPage = "1";
}
if (!StrRegExp.IsID(ToPage))
{
ToPage = "1";
}
this.Bind_rptList(Convert.ToInt32(ToPage));
}
}
protected void addly_Click(object sender, EventArgs e) //单击添加留言的按钮
{
book binbin = new book();
binbin.username = Server.HtmlEncode(this.username.Text);
binbin.email = this.email.Text;
binbin.qq = this.qq.Text;
binbin.homepage = this.homepage.Text;
if (this.Radboy.Checked)
{
binbin.sex = "男";
binbin.face = "boy";
}
else
{
binbin.sex = "女";
binbin.face = "gril";
}
binbin.body = this.lybody.Text;
if (this.ishde.Checked)
{
binbin.ishide = true;
}
else
{
binbin.ishide = false;
}
Label1.Text = binbin.ishide.ToString();
if (saveinfo.savely(binbin))
{
Response.Redirect("lyb.aspx");
}
else
{
Response.Write("<script>alert('留言失败,服务器错误!');location.herf='lyb.aspx'");
}
}
private void Bind_rptList(int ToPage) //读取数据库中已有留言信息
{
int CurrentPage = ToPage;
int PageSize = 5;
int PageCount;
int RecordCount;
string PageSQL;
string DataTable = "book";
string DataFiled = "ID";
string DataFileds = "ID,UserName,Face,Sex,QQ,HomePage,Email,IsHidden,Adddate,body,isrely,rebody";
string DataOrders = "ID Desc";
SqlConnection Conn = DB.createdb();
// string connstring = ConfigurationManager.AppSettings["cn"];
// SqlConnection Conn = new SqlConnection();
// Conn.ConnectionString = connstring;
// conn.Open();
Conn.Open();
//* 取得记录总数，计算总页数
SqlCommand cmd = new SqlCommand("Select Count(" + DataFiled + ") From " + DataTable, Conn);
RecordCount = Convert.ToInt32(cmd.ExecuteScalar());
if ((RecordCount % PageSize) != 0)
{
PageCount = RecordCount / PageSize + 1;
}
else
{
PageCount = RecordCount / PageSize;
}
if (ToPage > PageCount)
{
CurrentPage = PageCount;
}
if (CurrentPage <= 1)
{
PageSQL = "Select Top " + PageSize + " " + DataFileds + " From " + DataTable + " Order By " + DataOrders;
}
else
{
PageSQL = "Select Top " + PageSize + " " + DataFileds + " From " + DataTable + " Where " + DataFiled + " Not In ( Select Top " + PageSize * (CurrentPage - 1) + " " + DataFiled + " From " + DataTable + " Order By " + DataOrders + " ) Order By " + DataOrders;
}
SqlDataAdapter oda = new SqlDataAdapter(PageSQL, Conn);
DataSet ds = new DataSet();
oda.Fill(ds, "infList");
this.lbTotalPage.Text = Convert.ToString(PageCount);
this.hlkFirstPage.NavigateUrl = "?ToPage=1";
this.hlkLastPage.NavigateUrl = "?ToPage=" + PageCount;
this.lbCurrentPage.Text = Convert.ToString(CurrentPage);
if (CurrentPage <= 1)
{
this.hlkPrevPage.Enabled = false;
CurrentPage = 1;
}
else
{
this.hlkPrevPage.Enabled = true;
this.hlkPrevPage.NavigateUrl = "?ToPage=" + (ToPage - 1);
}
if (CurrentPage >= PageCount)
{
this.hlkNextPage.Enabled = false;
CurrentPage = PageCount;
}
else
{
this.hlkNextPage.Enabled = true;
this.hlkNextPage.NavigateUrl = "?ToPage=" + (ToPage + 1);
}
rpt1.DataSource = ds.Tables["infList"].DefaultView;
rpt1.DataBind();
Conn.Close();
}
protected string showrely(bool isrely, string rebody)
{
if (isrely)
{
return "<br><br>       <font color='#2CB421'>管理员回复:  </font><font color='#000099'>" + Server.HtmlEncode(rebody) + "</font>";
}
else
{
return null;
}
}

protected string showbody(bool ishidden, string str_body)
{
if (!ishidden || Session["admin"] != null)
{
return str_body.Replace("\r\n", "<br>");

}

else
{
return "<br>  <font color=red>此留言为悄悄话!只有管理员可见!</font>";
}
}

protected string show_admin(int id)
{
if (Session["admin"] != null)
{
return "<a href=re.aspx?id=" + id + ">回复</a>" + "   <a href=del.aspx?id=" + id + ">删除</a>";
}
else
{
return null;
}
}

[从事CSharp程序开发]

你定义的是nchar(10)，所以转成bool会出错 你需要把这个改成bit类型才可以

[qq_33001897]

<%# showrely((bool)Eval("isrely"),Eval("rebody").ToString()) %>

[从事CSharp程序开发]

\lyb.aspx:行号 222 这行的代码发来看下

[从事CSharp程序开发]

只能重建表了

[qq_33001897]

数据库不允许更改了 怎么办？只能重建表吗？？

[qq_33001897]

现在又报错了。 用户代码未处理 System.InvalidCastException Message=指定的转换无效。 Source=App_Web_ire03mjw StackTrace: 在 ASP.lyb_aspx.__DataBind__control4(Object sender, EventArgs e) 位置 d:\软件\程序5-13\程序5-13\lyb.aspx:行号 220 在 System.Web.UI.Control.OnDataBinding(EventArgs e) 在 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) 在 System.Web.UI.Control.DataBind() 在 System.Web.UI.Control.DataBindChildren() InnerException:

[qq_33001897]

这是表结构

[从事CSharp程序开发]

isrely

[从事CSharp程序开发]

改成 <%# showrely(Convert.ToBoolean(Eval("isrely")),Eval("rebody").ToString()) %> 试试 另外，看下这个表里已有数据的isreply的值是多少

[qq_33001897]

[qq_33001897]

是改这句吗？ <%# showrely((bool)Eval("isrely"),Eval("rebody").ToString()) %> 改成

<%# showrely(Convert.ToBoolean(Eval("isrely")),Eval("rebody").ToString()) %>

这样？

[qq_33001897]

还是不行 用户代码未处理 System.InvalidCastException Message=对象不能从 DBNull 转换为其他类型。 Source=mscorlib StackTrace: 在 System.DBNull.System.IConvertible.ToBoolean(IFormatProvider provider) 在 System.Convert.ToBoolean(Object value) 在 ASP.lyb_aspx.__DataBind__control4(Object sender, EventArgs e) 位置 d:\软件\程序5-13\程序5-13\lyb.aspx:行号 222 在 System.Web.UI.Control.OnDataBinding(EventArgs e) 在 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) 在 System.Web.UI.Control.DataBind() 在 System.Web.UI.Control.DataBindChildren() InnerException:

[从事CSharp程序开发]

新增数据时没往这个字段写值。 先从数据库里删掉已有数据，再把 SqlCommand cmd = new SqlCommand("insert into book(username,sex,body,qq,email,face,adddate,ishidden,homepage) values(@username,@sex,@body,@qq,@email,@face,@adddate,@ishidden,@homepage)", conn); 改成

SqlCommand cmd = new SqlCommand("insert into book(username,sex,body,qq,email,face,adddate,ishidden,homepage,isrely) values(@username,@sex,@body,@qq,@email,@face,@adddate,@ishidden,@homepage,0)", conn);

[从事CSharp程序开发]

可以先不改那句看下能不能正常运行，如果不能正常运行再改

[qq_33001897]

改不改都不行。 数据库里其他表的数据也要删除吗？ 还是只用删除这一个表的

[qq_33001897]

那之前那句还用改吗？

[从事CSharp程序开发]

只要删这个表的，删完再修改那个新增的SQL语句

[从事CSharp程序开发]

我平时不怎么上Q的，上CSDN也是抽时间上。 解决了就结贴给分吧

[qq_33001897]

解决了！！！太感谢了！ 能不能加个QQ好友？？以后有问题还能请教..

[qq_33001897]

那好吧 ，，不过真是太谢谢了！！困扰我3天了