求助:FreeTextBox问题。录入字数过时,为何保存不到数据库?
我现在用FreeTextBox来编辑文章,但是如果字数多的话不能保存到sql 2000数据库啊,这个保存字段为varchar(8000)
请问:
有何解决方法?
代码如下:
DateTime adddate1 = System.DateTime.Now;
string ls1=this.FreeTextBox1.Text.ToString().Trim();
//byte ls=Convert.ToByte(ls1).GetType();
string title=this.title.Value.ToString().Trim();
string author=this.Text1.Value.ToString().Trim();
string cc=this.Text2.Value.ToString().Trim();
string sql="insert into news(cateid,topicid,title,addtime,content,author,cc)values('"+DropDownList2.SelectedItem.Value.Trim()+"','"+DropDownList1.SelectedItem.Value.Trim()+"','"+title+"','"+adddate1+"','"+ls1+"','"+author+"','"+cc+"')";
try
{
db.ExecuteSql(sql);
Response.Write ("<script>alert('成功添加!')</script>") ;
Response.Write("<script language=javascript>window.location.reload('addnew.aspx');</script>");
}
catch(Exception ex)
{
Response.Write (ex.ToString());
}
}