asp.net c# 汉字插入oracle数据表出现 列在此处不允许
但是,如果插入的是字母和数据,插入就没有问题
看了很多帖子,都是说汉字显示的是乱码,没找到插入时的问题。
我估计是字符集的问题,也按照一些帖子上说的设置了,现在ORACLE里面那个表里和注册表里用的都是zhs16gbk。
下面是代码:
protected void Button2_Click(object sender, EventArgs e)
{
string ConnectionString = "Data Source=orcl;user=syyhsimis;password=syyhsimis;";//写连接串
OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
try
{
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into SF01 values(" + this.TextBox2.Text + "," + this.TextBox3.Text + "," + this.TextBox4.Text + "," + this.TextBox5.Text + "," + this.TextBox6.Text + "," + this.TextBox7.Text + " )";
cmd.ExecuteNonQuery();
}
catch (Exception ee)
{
Response.Write(ee.Message);
WebMessageBox1("数据库操作错,增加失败");
}
finally
{
conn.Close(); //关闭连接
}
Response.Write("<script>alert('增加成功!')</script>");
Response.Write("<script language='javascript'>location.href=location.href;</script>");
}
但是,如果插入的是字母和数据,插入就没有问题
看了很多帖子,都是说汉字显示的是乱码,没找到插入时的问题。
我估计是字符集的问题,也按照一些帖子上说的设置了,现在ORACLE里面那个表里和注册表里用的都是zhs16gbk。
下面是代码:
protected void Button2_Click(object sender, EventArgs e)
{
string ConnectionString = "Data Source=orcl;user=syyhsimis;password=syyhsimis;";//写连接串
OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
try
{
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into SF01 values(" + this.TextBox2.Text + "," + this.TextBox3.Text + "," + this.TextBox4.Text + "," + this.TextBox5.Text + "," + this.TextBox6.Text + "," + this.TextBox7.Text + " )";
cmd.ExecuteNonQuery();
}
catch (Exception ee)
{
Response.Write(ee.Message);
WebMessageBox1("数据库操作错,增加失败");
}
finally
{
conn.Close(); //关闭连接
}
Response.Write("<script>alert('增加成功!')</script>");
Response.Write("<script language='javascript'>location.href=location.href;</script>");
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货