protected void tripDelete_Click(object sender, EventArgs e)
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
LinkButton tripDelete = sender as LinkButton;
GridViewRow row = tripDelete.NamingContainer as GridViewRow;
//string ProgCode = Convert.ToString(GridViewTrip.DataKeys[row.RowIndex].Value.ToString());
string ProgCode = row.Cells[0].Text;
int result;
myConn.Open();
SqlCommand cmd = new SqlCommand("DELETE FROM Trip WHERE TripID ='" + ProgCode + "'", myConn);
result = cmd.ExecuteNonQuery();
myConn.Close();
if (result == 1)
{
trip tripOjb = new trip();
tripDAO tripDAO = new tripDAO();
List <trip> tripList = new List <trip>();
tripList = tripDAO.getTripInfo();
GridViewImmTrip.DataSource = tripList;
GridViewImmTrip.DataBind();
}
//Response.Redirect("Tripmanagement.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
tripDAO tripDAO = new tripDAO();
List <trip> immTrip = new List <trip>();
immTrip = tripDAO.getImmersionTripInfo();
GridViewImmTrip.DataSource = immTrip;
GridViewImmTrip.DataBind();
List <trip> immTripHist = new List <trip>();
immTripHist = tripDAO.getImmersionTripHist();
GridViewImmHist.DataSource = immTripHist;
GridViewImmHist.DataBind();
}
