ASP.NET c# 新闻系统,内容
string str="";
str=this.FreeTextBox1.Text;
string str1=Regex.Replace(this.FreeTextBox1.Text,"'","''");
str=Regex.Replace(str,"'","''");
cmd.CommandText="select CONVERT(char(10),GETDATE(),120)as 服务器时间";
string dt=Convert.ToString(cmd.ExecuteScalar());
cmd.CommandText="insert into xwnews (liebiao,biaoti,nr,fabiaoren,fabiaodate,cishu,biaozhi) values("+this.DropDownList1.SelectedValue+",'"+str1+"','@neirong','"+name+"','"+dt+"',0,0)";
cmd.Parameters.Add("@neirong",SqlDbType.NText,10000,str);
cmd.Parameters["@neirong"].Value=str;
cmd.ExecuteNonQuery();
数据库类型ntext
System.Data.SqlClient.SqlException: 将截断字符串或二进制数据。语句已终止。