protected void Del_Click(string Yachtsno)
{
SqlConnection Conn = new SqlConnection();
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["sqlString"].ConnectionString;
DataTable dt = new DataTable();
try
{
string CmdString = @"";
CmdString = @"DELETE FROM Yachts where Yachtsno=@Yachtsno ";
SqlCommand cmd = new SqlCommand(CmdString, Conn);
cmd.Parameters.AddWithValue("Yachtsno", Yachtsno);
Conn.Open();
cmd.ExecuteNonQuery();
DataTable dt2 = Yachts();
Grid_Yachts.DataSource = dt2;
Grid_Yachts.DataBind();
ScriptManager.RegisterStartupScript(Page, GetType(), "alert", "<script>swal('刪除成功')</script>", false);
}
catch (Exception ex)
{
DB_string.log("Yachts_del:", ex.ToString());
ScriptManager.RegisterStartupScript(Page, GetType(), "alert", "<script>swal('刪除失敗','國家尚未全刪除')</script>", false);
}
finally
{
Conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["Username"] == null)
{
Response.Redirect("../../login.aspx");
}
else
{
DataTable dt = Yachts();
Grid_Yachts.DataSource = dt;
Grid_Yachts.DataBind();
}
}
}