向SQL添加超常数据

SqlParameter objParam = new SqlParameter("@Detail",SqlDbType.Text);

objParam.Value= fckContent.Value;

string strSql = "insert into cngda_workshow Name,Author,ImageName,Detail,FileName,TypeID,UserID,FileSize,IsCheck)values(@Name,@Author,@ImageName,@Detail,@FileName,@TypeID,@UserID,@FileSize,@IsCheck)";

int iCount    = SqlHelper.ExecuteNonQuery(SqlHelper.getConnectionString(),CommandType.Text,strSql,

                       new SqlParameter("@Name",this.txtName.Text),

                       new SqlParameter("@Author",this.txtAuthor.Text),

                       new SqlParameter("@ImageName",strImageName),

                       objParam,

                       new SqlParameter("@FileName",strFileName),

                       new SqlParameter("@TypeID",this.objComBoTree.SelectID),

                       new SqlParameter("@UserID",1),

                       new SqlParameter("@FileSize",strFileSize),

                       new SqlParameter("@IsCheck",iIsCheck));

因为text字段的长度超过了8000，直接添加会出问题，所以必须显示的声明成text类型，才能正常添加到数据库里面。