Try
{
insert progress...}
Catch(Exception e1)
{
//justify error from e1
if(e1.ToString().find("unique"))
Response.write("重复输入,数据库出错")
}
{
insert progress...}
Catch(Exception e1)
{
//justify error from e1
if(e1.ToString().find("unique"))
Response.write("重复输入,数据库出错")
}
该错误应为2627吧!
还有没有finde()这个方法!
Response.write("重复输入,数据库出错")
i=executesql("INSERT formname(field list) VALUES(value list) WHERE NOT EXISTS
(SELECT name FROM formname WHERE name='yourname')"
如果name已存在,则i=0.