怎样才能把它的text插入数据库?
我这摸写的:
string s= Editor1.Text.ToString().Replace("'","''");
......
com.Parameters.Add("@s", SqlDbType.Char).Value = s;
运行时只要有图片就会出错,我数据库的字段设过char,varchar,bit都不成,怎办呀?
错误信息:
String or binary data would be truncated.
The statement has been terminated.
我这摸写的:
string s= Editor1.Text.ToString().Replace("'","''");
......
com.Parameters.Add("@s", SqlDbType.Char).Value = s;
运行时只要有图片就会出错,我数据库的字段设过char,varchar,bit都不成,怎办呀?
错误信息:
String or binary data would be truncated.
The statement has been terminated.
错误信息:
String or binary data would be truncated.
The statement has been terminated.只要cuteEditor中有图片就肯定不能插近数据库,显示上段错误
确实如此,谢谢!
能否顺便解释一下ntext与char的区别,此控件我刚开始使用,以后难免有很多不明之处,请您
明天..后天..大后天..接着指导此控件的使用!
char 固定长度的ascii字符串类型 varchar是可变长的 nvarchar 可变长的unicode查sql文档....
Character charchk = new Character();Character类:Character.cs:using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;/// <summary>
/// Character 的摘要说明
/// </summary>
public class Character
{
public Character()
{
//
// TODO: 在此处添加构造函数逻辑
//
} public string Getcharin(string keys)
{
string KeyEndValue = keys;
string char_inj = "'|and|exec|insert|select|delete|update|count|chr|mid|master|truncate|char|declare|xp_cmdshell|exec master|net localgroup administrators|net user|drop table|truncate|asc|<script>|--";
string[] SQL_inj = char_inj.Split('|');
string char_safe = "’|and|exec|insert|select|delete|update|count|chr|mid|master|truncate|char|declare|xp_cmdshell|exec master|net localgroup adminstrators|net user|drop table|truncate|asc|〈script〉|--";
string[] SQL_safe = char_safe.Split('|');
int co = SQL_inj.Length;
for (int j = 0; j < SQL_inj.Length; j++)
{
KeyEndValue = KeyEndValue.Replace(SQL_inj[j], SQL_safe[j]);
}
return KeyEndValue;
} public string Getcharout(string keys)
{
string KeyEndValue = keys;
string char_inj = "'|and|exec|insert|select|delete|update|count|%|chr|mid|master|truncate|char|declare|xp_cmdshell|exec master|net localgroup administrators|net user|drop table|truncate|asc|<script>|--";
string[] SQL_inj = char_inj.Split('|');
string char_safe = "’|and|exe|insert|delete|update|count|%chr|mid|master|truncate|char|declare|xp_cmdshell|exec master|net localgroup adminstrators|net user|drop table|truncate|asc|<script>|--";
string[] SQL_safe = char_safe.Split('|');
for (int j = 0; j < SQL_safe.Length; j++)
{
KeyEndValue = KeyEndValue.Replace(SQL_safe[j], SQL_inj[j]);
}
return KeyEndValue;
}
}