生成sql语句的问题 access数据库

操作access 备注大于64k
str1 字数不定 反正大于64k


string strDele = @"UPDATE one set nr='" + str1 + "' Where name='123'";
OleDbCommand myCommand = new OleDbCommand(strDele, myConn);
myCommand.ExecuteNonQuery();

这样肯定报错
-------------------------------------

str2 字数为 63k
str3 字数为 63k
(str2 str3 ....是从str1截取的)
string strDele = @"UPDATE one set nr='" + str2 + str3+"' Where name='123'";
OleDbCommand myCommand = new OleDbCommand(strDele, myConn);
myCommand.ExecuteNonQuery();
操作成功
--------------------------------------

问题是


我怎么才能按str1字数生成类似下面的代码呢
string strDele = @"UPDATE one set nr='" + str2 + str3+str4+"' Where name='123'";
string strDele = @"UPDATE one set nr='" + str2 + str3+str4+str5+"' Where name='123'";

---

不会。。友情mark

---

使用OLE  Object类型
http://topic.csdn.net/u/20070712/12/902691c7-46e7-4d41-ad8d-b4834bb476ec.html

---

引用

……
-------------------------------------

str2 字数为 63k
str3 字数为 63k
(str2 str3 ....是从str1截取的)
string strDele = @"UPDATE one set nr=