string sql = "insert into Messages (Name,Sex,Tel,QQ,Email,Title,Content,Time) values(@name,@sex,@tel,@QQ,@email,@title,@content,@time) ";
return ExecuteCommand(sql, new OleDbParameter[] {
new OleDbParameter("@name",name),
new OleDbParameter("@sex",sex),
new OleDbParameter("@tel",tel),
new OleDbParameter("@QQ",QQ),
new OleDbParameter("@email",email),
new OleDbParameter("@title",title),
new OleDbParameter("@content",content),
new OleDbParameter("@time",time)
});
return ExecuteCommand(sql, new OleDbParameter[] {
new OleDbParameter("@name",name),
new OleDbParameter("@sex",sex),
new OleDbParameter("@tel",tel),
new OleDbParameter("@QQ",QQ),
new OleDbParameter("@email",email),
new OleDbParameter("@title",title),
new OleDbParameter("@content",content),
new OleDbParameter("@time",time)
});
SQL是这样用的new SqlParameter("@Url", SqlDbType.NChar,50)};第一个是参数名,第二个是数据类型 ,第三个是大小(可无)
insert into Messages ([Name],Sex,Tel,QQ,Email,Title,[Content],[Time])
values(@name,@sex,@tel,@QQ,@email,@title,@content,@time)
insert into Messages (Name,Sex,Tel,QQ,Email,Title,Content,Time) values(@name,@sex,@tel,@QQ,@email,@title,@content,@time)
这根本就不是SQL语句,执行肯定错误。如果是
你那一整篇放进去以后也肯定有问题。
return dbh.ExecuteCommand(sql, new OleDbParameter[] { new OleDbParameter("@MsgName",MsgName),
new OleDbParameter("@Sex",Sex),
new OleDbParameter("@Phone",Phone),
new OleDbParameter("@QQ",QQ),
new OleDbParameter("@Email",Email),
new OleDbParameter("@Home",Home),
new OleDbParameter("@Face",Face),
new OleDbParameter("@Title",Title),
new OleDbParameter("@Content",Content)
});这个能正确运行