try
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into Books (BooksID,BookName,Edition,AuthorsName,Sort,PublisherName,PubData,Price) values(" + insid + ",'" + insname + "','" + insedition + "','" + inswriter + "','" + inssort + "','" + inspublisher + "','" + inspub + "'," + insprice + ")", con);
cmd.ExecuteNonQuery();
Response.Write("<script>alert('插入成功!');</script>");
}
catch(Exception exp)
{
Response.Write(exp.ToString());
}
finally
{
con.Close();
}

这样看看输出的错误信息是什么..

[此贴子已经被作者于2007-1-15 16:47:41编辑过]

就是插入一条数据为什么要在两个页面呢？

楼主发的不是两个页面,是一个是前台显示的页面,一个是后台写的逻辑代码.

try
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into Books (BooksID,BookName,Edition,AuthorsName,Sort,PublisherName,PubData,Price) values(" + insid + ",'" + insname + "','" + insedition + "','" + inswriter + "','" + inssort + "','" + inspublisher + "','" + inspub + "'," + insprice + ")", con);
cmd.ExecuteNonQuery();
Response.Write("<script>alert('插入成功!');</script>");
}
catch(Exception exp)
{
Response.Write(exp.ToString());
}
finally
{
con.Close();
}
红色的地方用不用加上单引号，即：'" + insid + "'.

应该加上也没有错的.