很奇怪了，请各位帮忙哦~~~急。。
private void tijiao_Click(object sender, System.EventArgs e)
{
string sUserName = username.Text;
StringBuilder sbSql = new StringBuilder("INSERT INTO Users (UserName,Pwd,PwdQuestion,PwdAnswer,Email,Idcards) VALUES (");
sbSql.Append("\"" + username.Text + "\",");
sbSql.Append("\"" + pwd.Text + "\",");
sbSql.Append("\""+ pwdq.Text + "\",");
sbSql.Append("\""+ pwda.Text + "\",");
sbSql.Append("\""+ email.Text + "\",");
sbSql.Append("\""+ idcard.Text + "\",");
Response.Write(sbSql.ToString());
try
{
SqlBase.ExecuteSql(sbSql.ToString());
Response.Redirect("register1.aspx");
}
catch(Exception ex)
{
if(ex.Message == "object unavailable!")
Response.Redirect("Register.aspx?userName=" + sUserName);
else
throw new Exception(ex.Message);
}
}
我写了个注册的程序。在数据库为ACCESS可以用，可是我换为数据库不SQL就出了错。
提示错误为：
“/eshop”应用程序中的服务器错误。
--------------------------------------------------------------------------------
在此上下文中不允许使用 '33'。此处只允许使用常量、表达式或变量。不允许使用列名。
sbSql.Append("\"" + username.Text + "\",");
那括号里头的值要怎么定呢。请各位大侠帮忙
问题点数：50、回复次数：6Top
1 楼zhongkeruanjian（编程亮子）回复于 2006-03-03 16:42:38 得分 0
"换成'Top
2 楼songxiaozhao（雨朋）回复于 2006-03-03 16:43:49 得分 0
sql里面不要双引号,要单引号
比如你写sql="insert into Table1 (username) values ('"+username.Text+"')";
sbSql.Append("\"" + username.Text + "\",");
sbSql.Append("\"" + pwd.Text + "\",");
sbSql.Append("\""+ pwdq.Text + "\",");
sbSql.Append("\""+ pwda.Text + "\",");
sbSql.Append("\""+ email.Text + "\",");
sbSql.Append("\""+ idcard.Text + "\",");Top
3 楼Lukiya（路基亚）回复于 2006-03-03 16:44:02 得分 0
\"改'试下。Top
4 楼hacker09（）回复于 2006-03-03 17:17:06 得分 0
是下面这面句不要变吗
StringBuilder sbSql = new StringBuilder("INSERT INTO Users (UserName,Pwd,PwdQuestion,PwdAnswer,Email,Idcards) VALUES (");
那这sbSql.Append(………………); 那这括号里头要怎么写呢Top
5 楼hacker09（）回复于 2006-03-03 17:56:06 得分 0
songxiaozhao(雨朋)
谢谢你啦！你说的方法是对的Top
6 楼njuzgj（罐子）回复于 2006-03-03 21:16:52 得分 0
UPTop
