关于添加的问题

Question

看看代码！你是添加页面是吧。

Answer 1

代码如下：Button1_Click是保存按钮

private void CreateDataSet(string SqlStr)
{
try
{
string ConnStr=System.Configuration.ConfigurationSettings.AppSettings["ConnectString"];
SqlConnection Conn=new SqlConnection(ConnStr);
Conn.Open();
SqlDataAdapter Cmd;
DataSet ds;
ds=new DataSet();
Cmd=new SqlDataAdapter(SqlStr,Conn);
Cmd.Fill(ds);
if(ds.HasErrors)
{
Response.Write("发生错误！！错误原因：");
Response.Write(ds.HasErrors.GetTypeCode());
}
else
{
Response.Write("祝贺你！添加成功！！");
//Response.End();
}
}
catch(Exception Ex)
{
Response.Write(Ex.Message.ToString());//
}
}
public void Button1_Click(object sender, System.EventArgs e)
{
string SqlStr="insert into guestbook values("+1+",'"+username.Text+"','"+post_time.Text+"','"+content.Text+"')";
CreateDataSet(SqlStr);
Response.Write("Button1.Click");
}