using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;public partial class liuyan : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
if (MessageName.Text != "" && MessageContent.Text != "")
{
/*liuyan ly=new liuyan
{
name=MessageName.Text,
time=DateTime.Now.ToString(),
context=MessageContent.Text;
}*/
SqlConnection sqlcon = new SqlConnection(db.connDB());
sqlcon.Open();
SqlCommand com = new SqlCommand("insert into Login(name,time,content)values('" + MessageName.Text.Trim() + "','" + DateTime.Now.ToString() + "','" + MessageContent.Text.Trim() + "')", sqlcon);
int sum=Convert.ToInt32(com.ExecuteNonQuery());
sqlcon.Close(); try
{
Response.Write("<script>alert('留言成功')</script>"); }
catch
{
Response.Redirect("Default.aspx");
}
}
else
Response.Write("<script>alert('留言失败,主题与内容不为空')</script>"); }
protected void Button2_Click(object sender, EventArgs e)
{
MessageName.Text = "";
MessageContent.Text = "";
}
}
time字段可直接在数据库中设置默认值getdate()
还有你的 try catch 没有意义
Response.Write("<script>alert('留言成功')</script>");这句永远不会错吧
还有你的 try catch 没有意义
Response.Write("<script>alert('留言成功')</script>");这句永远不会错
Response.Write("<script>alert('留言失败,主题与内容不能为空')</script>"); 吧
SQL语句错误 红色标记的Values前面记得空格!