public partial class Data_DateAdd : System.Web.UI.Page
{
database DB = new database();
protected void Page_Load(object sender, EventArgs e)
{
txtTime.Text = DateTime.Now.ToString();
}
protected void btnGcz_Click(object sender, EventArgs e)
{
using (SqlConnection con = DB.getstrConn())
{
con.Open();
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "proc_InsertDate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@tm", SqlDbType.DateTime).Value = Convert.ToDateTime(txtTime.Text);
cmd.Parameters.Add("@syksw", SqlDbType.Float).Value = Convert.ToDouble(txtSyksw.Text);
cmd.Parameters.Add("@tqzk", SqlDbType.NVarChar,500).Value = txtWther.Text;
cmd.Parameters.Add("@wd", SqlDbType.Float).Value = Convert.ToDouble(txtTemp.Text);
cmd.Parameters.Add("@gcry", SqlDbType.NVarChar, 500).Value = txtGcry.Text;
cmd.Parameters.Add("@jlry", SqlDbType.NVarChar, 500).Value = txtJlry.Text;
cmd.Parameters.Add("@sm", SqlDbType.NVarChar, 500).Value = txtRmk.Text;
cmd.ExecuteNonQuery();
Response.Write("<script>alert('插入成功!')</script>");
}
}
using (SqlConnection con = DB.getstrConn())
{
con.Open();
using (SqlCommand cmd1 = con.CreateCommand())
{
cmd1.CommandText = "proc_SelectTopDate";
cmd1.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd1);
adapter.Fill(ds);
string id = ds.Tables[0].Rows[0]["id"].ToString();
Response.Redirect("DataAdd.aspx?id=" + id);
}
}
}
}问题:不晓得怎么回事,无法执行到Response.Write("<script>alert('插入成功!')</script>");
{
database DB = new database();
protected void Page_Load(object sender, EventArgs e)
{
txtTime.Text = DateTime.Now.ToString();
}
protected void btnGcz_Click(object sender, EventArgs e)
{
using (SqlConnection con = DB.getstrConn())
{
con.Open();
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "proc_InsertDate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@tm", SqlDbType.DateTime).Value = Convert.ToDateTime(txtTime.Text);
cmd.Parameters.Add("@syksw", SqlDbType.Float).Value = Convert.ToDouble(txtSyksw.Text);
cmd.Parameters.Add("@tqzk", SqlDbType.NVarChar,500).Value = txtWther.Text;
cmd.Parameters.Add("@wd", SqlDbType.Float).Value = Convert.ToDouble(txtTemp.Text);
cmd.Parameters.Add("@gcry", SqlDbType.NVarChar, 500).Value = txtGcry.Text;
cmd.Parameters.Add("@jlry", SqlDbType.NVarChar, 500).Value = txtJlry.Text;
cmd.Parameters.Add("@sm", SqlDbType.NVarChar, 500).Value = txtRmk.Text;
cmd.ExecuteNonQuery();
Response.Write("<script>alert('插入成功!')</script>");
}
}
using (SqlConnection con = DB.getstrConn())
{
con.Open();
using (SqlCommand cmd1 = con.CreateCommand())
{
cmd1.CommandText = "proc_SelectTopDate";
cmd1.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd1);
adapter.Fill(ds);
string id = ds.Tables[0].Rows[0]["id"].ToString();
Response.Redirect("DataAdd.aspx?id=" + id);
}
}
}
}问题:不晓得怎么回事,无法执行到Response.Write("<script>alert('插入成功!')</script>");
Response.Write("<script>alert('插入成功!')</script>");
//把这个去掉
//把
Response.Redirect("DataAdd.aspx?id=" + id);
//换成
Response.Write("<script>alert('插入成功!');window.location.href='DataAdd.aspx?id="+id+"';</script>");
1#的方式利用JS重定向就可以在客户端实现重定向
最好是
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "func1", "alert('插入成功!');window.location.href='DataAdd.aspx?id="+id+"'";, true);