// <snippet3> public bool Delete() { if (ID.Equals(DBNull.Value)) { // The Employee object is not persisted. return(true); } else { // The Employee object is persisted. // Use the SqlDataSource control as a convenient wrapper for // the ADO.NET code needed to delete a record from the database. ConnectionStringSettings cts = ConfigurationManager.ConnectionStrings["NorthwindConnection"]; SqlDataSource sds = new SqlDataSource(); try { sds.ConnectionString = cts.ConnectionString; sds.DeleteParameters.Add(new Parameter("empID", TypeCode.Int32, this.ID.ToString())); sds.DeleteCommand = "DELETE FROM [Order Details] " + "WHERE OrderID IN (SELECT OrderID FROM Orders WHERE EmployeeID=@empID)"; sds.Delete(); sds.DeleteCommand = "DELETE FROM Orders WHERE EmployeeID=@empID"; sds.Delete(); sds.DeleteCommand = "DELETE FROM EmployeeTerritories WHERE EmployeeID=@empID"; sds.Delete(); sds.DeleteCommand = "DELETE FROM Employees WHERE EmployeeID=@empID"; sds.Delete(); return(true); } finally { // Clean up resources. sds.Dispose(); } } }
public string delProject(string project_code) { UserLoginData loginData = new UserLoginData(); loginData = (UserLoginData)HttpContext.Current.Session["login_data"]; LogData log_data = new LogData(); log_data.ModuleCode = new LogData().Module_NewStdPayment; log_data.Username = loginData.User_ID; log_data.Message = "Delete "; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string response = ""; try { // if (oracleObj.Delete() > 0) // { oracleObj.DeleteCommand = "Delete From PROJECT_ADDITIONAL Where PROJECT_CODE='" + project_code + "'"; if (oracleObj.Delete() > 0) { log_data.Message += " Project_Addition With:" + project_code; oracleObj.DeleteCommand = "Delete From PROJECT Where PROJECT_CODE='" + project_code + "'"; if (oracleObj.Delete() > 0) { log_data.Message += " ,PROJECT With:" + project_code; oracleObj.DeleteCommand = "Delete From PROJECT_CONFIG Where PROJECT_CODE='" + project_code + "'"; if (oracleObj.Delete() > 0) { log_data.Message += " ,PROJECT_CONFIG With:" + project_code; response = "OK"; log_data.StatusCode = log_data.LogStatus_SUCCESS; } else { log_data.StatusCode = log_data.LogStatus_FAILED; } } else { log_data.StatusCode = log_data.LogStatus_FAILED; } } else { log_data.StatusCode = log_data.LogStatus_FAILED; } // } } catch (Exception e) { response = e.Message.ToString(); log_data.StatusCode = log_data.LogStatus_ERROR; log_data.Message += " [" + e.ToString() + "]"; } new Log().WriteLog(log_data); return(response); }
public string deleteWorkLoadConfig(string lecturer_type, string lecturer_position) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Delete From WorkLoadConfig Where LecturerType='" + lecturer_type + "' And LecturerPosition='" + lecturer_position + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:WorkLoadConfig:deleteWorkLoadConfig" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
/// <summary> /// ลบข้อมูลจากตาราง TQF2SEC3STRUCTUREGROUP /// </summary> /// <param name="CurrCode">รหัสหลักสูตร(Curriculum)</param> /// <returns>Success</returns> public string deleteTQF2Sec3StructureGroup(string CurrCode) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Delete From TQF2SEC3STRUCTUREGROUP Where CURRCODE ='" + CurrCode + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteTQF2Sec3StructureGroup: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
public string deleteRegistrationConfig(string student_year, string degree_char, string section) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Delete From REGISTRATION_CONFIG Where STUDENT_YEAR_ADMISSION=" + student_year + " AND DEGREE_CHAR='" + degree_char + "' AND SECTION='" + section + "'"; try { oracleObj.DeleteCommand = sql; if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { HttpContext.Current.Session["response"] = "Unit Test:RegistrationConfig:deleteRegistrationConfig" + " ไม่สามารถดำเนินการได้" + sql; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
public string deleteHourRefer(string degree_char, string course_type) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Delete From HOUR_REFER_CONFIG Where DEGREE_CHAR='" + degree_char + "' AND COURSE_TYPE='" + course_type + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:HourRefer:deleteHourRefer" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return response; }
/// <summary> /// ลบข้อมูลจากตาราง LECTUREREXPRIENCE /// </summary> /// <param name="sql">SQL Command</param> /// <returns>Success</returns> public string deleteLecturerExprienceManual(string sql) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteLecturerExprienceManual: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// ลบข้อมูลจากตาราง ENGLISH_DB /// </summary> /// <param name="EnglishDbId">รหัสมาตรฐานภาษาอังกฤษ</param> /// <returns>OK</returns> public string deleteEnglishDb(string EnglishDbId) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Delete From ENGLISH_DB Where ENGLISH_DB_ID ='" + EnglishDbId + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteEnglishDb: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// ลบข้อมูลจากตาราง STUDENT_PROCEEDING /// </summary> /// <param name="StudentEnglishTestId">รหัสผลการสอบภาษาอังกฤษ</param> /// <returns>OK</returns> public string deleteStudentProceeding(string StudentProceedingId) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Delete From STUDENT_PROCEEDING Where STUDENT_PROCEEDING_ID ='" + StudentProceedingId + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteStudentProceeding: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
//if user decides to delete account protected void ButtonDelete_Click(object sender, EventArgs e) { //check is password has been entered if (tboxCurrentPW.Text == "") { LabelError.Text = "You need to enter your password in order to delete your account"; divChange.Visible = true; divCurrent.Visible = false; return; } //check if password is correct if (password_validaton()) { SqlDataSource objDS = new SqlDataSource(); objDS.ProviderName = ConfigurationManager.ConnectionStrings["ConnectionString_myDatabase"].ProviderName; objDS.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString_myDatabase"].ConnectionString; //deleted the account and goes to logout, this will null the session values objDS.DeleteCommand = "DELETE FROM [Forum_User]" + "WHERE [pk_User_ID]=[?]"; objDS.DeleteParameters.Add("pk_Thread_ID", Session["pk_User_ID"].ToString()); objDS.Delete(); Response.Redirect("Logout.aspx"); } else { LabelError.Text = "You entered your password incorrectly"; divChange.Visible = true; divCurrent.Visible = false; } }
public string deleteVerificationRegis(string AcademicYear, string Semester, string Student_ID, string Course_Code, string degree_char) { string TableName = getTableName(degree_char); string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Delete From " + TableName + " Where ACADEMIC_YEAR='" + AcademicYear + "' And SEMESTER='" + Semester + "' And STUDENT_ID='" + Student_ID + "' And COURSE_CODE='" + Course_Code + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString() + " "; } return(response); }
// V1.0.0 public string deleteConfigNewStudentReg(string academic_year, string semester, string degree_char, string faculty_code) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Delete From CONFIG_NEWSTD_REG Where ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' And FACULTY_CODE='" + faculty_code + "' AND DEGREE_CHAR='" + degree_char + "' "; try { oracleObj.DeleteCommand = sql; if (oracleObj.Delete() > 0) { response = "OK"; } } catch { HttpContext.Current.Session["response"] = "Unit Test:ConfigNewStudentReg:deleteConfigNewStudentReg" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
public string deleteAddWorkLoad(string academic_year, string semester, string lecturer_id) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Delete AddWorkLoad Where ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' And LECTURER='" + lecturer_id + "' "; try { oracleObj.DeleteCommand = sql; if (oracleObj.Delete() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:AddWorkLoad:deleteAddWorkLoad" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
/// <summary> /// ลบข้อมูลจากตาราง QUALIFICATIONDETAIL /// </summary> /// <param name="sql">sql</param> /// <returns>Success</returns> public string deleteQualificationDetailManual(string sql) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); //string sql = "Delete From QUALIFICATIONDETAIL Where UUIDNUMBER ='" + UUIDNumber + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteQualificationDetail: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// ลบข้อมูลจากตาราง QUALIFICATIONDETAIL /// </summary> /// <param name="LectIdentity">เลขประจำตัวประชาชน(SysUser)</param> /// <param name="QualificationDegree">ชื่อคุณวุฒิ</param> /// <param name="Year">ปีที่จบการศึกษา</param> /// <param name="Academy">สถาบันที่สำเร็จการศึกษา</param> /// <returns>Success</returns> public string deleteQualificationDetail(string LectIdentity, string QualificationDegree, string Year, string Academy) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Delete From QUALIFICATIONDETAIL Where LECTIDENTITY ='" + LectIdentity + "' And QUALIFICATIONDEGREE ='" + QualificationDegree + "' And YEAR ='" + Year + "' And ACADEMY ='" + Academy + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteQualificationDetail: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
// V1.0.0 public string deleteConfig(string delete_id) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); try { oracleObj.DeleteCommand = "Delete From STUDENT_ID_CONFIG Where ID=" + delete_id; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); if (oracleObj.Delete() == 1) { response = "OK"; } } catch { HttpContext.Current.Session["response"] = "Unit Test:StudentIDConfig:deleteConfig" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
public string deleteAcademicCalendar(string academic_year, string semester, string degree_char) { string response = ""; string sql = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); sql = "Delete From Academic_Calendar Where ACADEMIC_YEAR='" + academic_year + "' AND SEMESTER='" + semester + "' AND DEGREE_CHAR='" + degree_char + "'"; try { oracleObj.DeleteCommand = sql; if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { HttpContext.Current.Session["response"] = "Unit Test:AcademicCalendar:deleteAcademicCalendar" + " ไม่สามารถดำเนินการได้" + sql; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
// V 1.0.0 public string deleteLecturerTable(LecturerTableData delete_data, string degree_char) { string response = ""; try { string TableName = getTableName(degree_char); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Delete From " + TableName + " Where ACADEMIC_YEAR='" + delete_data.AcademicYear + "' And SEMESTER='" + delete_data.Semester + "' And COURSE_CODE='" + delete_data.Course_Code + "' And SEC_NO=" + delete_data.Sec_No + " And SUBSEC_NO=" + delete_data.SubSec_No + " And ROOM_CODE='" + delete_data.Room_Code + "' And BUILDING_CODE='" + delete_data.Building_Code + "' And CAMPUS_CODE='" + delete_data.Campus_Code + "' And TEACHING_DAY='" + delete_data.Teaching_Day + "' And TEACHING_START_TIME='" + delete_data.Teaching_Start_Time + "' And TEACHING_END_TIME='" + delete_data.Teaching_End_Time + "' "; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); } } catch { HttpContext.Current.Session["response"] = "Unit Test:LecturerTable:deleteLecturerTable" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
/// <summary> /// ลบข้อมูลจากตาราง DIVISION /// </summary> /// <param name="DivisionCode">รหัสสาขา</param> /// <returns>Success</returns> public string deleteDivision(string DivisionCode) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Delete From DIVISION Where DIVISIONCODE ='" + DivisionCode + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteDivision: " + exception; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
public string deleteCampus(string CampusCode) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Delete From CAMPUS Where CAMPUS_CODE ='" + CampusCode + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:System Config:Delete Campus" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
/// <summary> /// ลบข้อมูลจากตาราง LECTUREREXPRIENCE /// </summary> /// <param name="LectIdentity">บัตรประจำตัวประชาชน</param> /// <returns>Success</returns> public string deleteLecturerExprience(string LectIdentity) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Delete From LECTUREREXPRIENCE Where LECTIDENTITY ='" + LectIdentity + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteLecturerExprience: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// ลบข้อมูลจากตาราง TQF2SEC4SUB1 /// </summary> /// <param name="T2S4Sub1No">รหัสการพัฒนาคุณลักษณะพิเศษของนักศึกษา</param> /// <returns>Success</returns> public string deleteTQF2Sec4Sub1(string T2S4Sub1No) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Delete From TQF2SEC4SUB1 Where T2S4SUB1NO ='" + T2S4Sub1No + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteTQF2Sec4Sub1: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
public string deletePlan(string plan_code) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Delete From CURRTYPE Where CURRTYPECODE ='" + plan_code + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:Plan: ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
/// <summary> /// ลบข้อมูลจากตาราง SERVICESTATUS /// </summary> /// <param name="ServiceStatusCode">A=ทุกคณะ/วิทยาลัย, O=ภายในคณะ/วิทยาลัย</param> /// <returns>Success</returns> public string deleteServiceStatus(string ServiceStatusCode) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Delete From SERVICESTATUS Where SERVICESTATUSCODE ='" + ServiceStatusCode + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteServiceStatus: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
public string deleteMajor(string Major_Code) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Delete From MAJOR Where MAJOR_CODE ='" + Major_Code + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; try { SqlDataSource2.DeleteCommand = "delete [Account_Order_M] where id=" + Request["Id"]; int affraw = SqlDataSource2.Delete(); if (affraw == 0) { Label8.Text = "error"; Button1.Visible = false; } else { Label8.Text = "ok"; Button1.Visible = false; } } catch (Exception ex2) { Response.Write(ex2.ToString()); } finally { SqlDataSource2.Dispose(); } }
/// <summary> /// ลบข้อมูลจากตาราง COURSEELECTIVEMEMBER /// </summary> /// <param name="CourseElectiveCode">รหัสวิชา xxx</param> /// <param name="FacultyCode">รหัสคณะ</param> /// <returns>Success</returns> public string deleteCourseElectiveMemberManual(string sql) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); //string sql = "Delete From COURSEELECTIVEMEMBER Where COURSEELECTIVECODE ='" + CourseElectiveCode + "' And FACULTYCODE='" + FacultyCode + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteCourseElectiveMember: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// ลบข้อมูลจากตาราง CURRFORMAT /// </summary> /// <param name="CurrFormatCode">รหัสรูปแบบหลักสูตร</param> /// <returns>Success</returns> public string deleteCurrFormat(string CurrFormatCode) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Delete From CURRFORMAT Where CURRFORMATCODE ='" + CurrFormatCode + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteCurrFormat: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
protected void btnDelete_Click(object sender, EventArgs e) { string myMessage = null; for (int i = 0; i < GridView1.Rows.Count; i++) { CheckBox myCheckBox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1"); Label myID = (Label)GridView1.Rows[i].FindControl("Label1"); if (myCheckBox.Checked == true) { myMessage = myMessage + myID.Text + "or[P_id]="; } } int index = myMessage.LastIndexOf("or[P_id]="); if (index > 0) { myMessage = myMessage.Substring(0, index); } //lblMsg.Text += myMessage; SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = @"Data Source=.;Initial Catalog=Guardian_Angel;Integrated Security=True"; sds.DeleteCommand = "delete NPGrouping where [N_id]=" + DetailsView1.Rows[0].Cells[1].Text + "and ([P_id]=" + myMessage + ")"; sds.Delete(); Response.Redirect(Request.Url.ToString()); }
/// <summary> /// ลบข้อมูลจากตาราง COURSEELECTIVE /// </summary> /// <param name="CourseElectiveCode">รหัสวิชา</param> /// <param name="Id">Primary Key</param> /// <returns>Success</returns> public string deleteCourseElective(string Id) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Delete From COURSEELECTIVE Where ID ='" + Id + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "deleteCourseElective: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
// V 1.0.0 public string deleteSubCredit2(string academic_year, string semester, string course_code, int sec_no, int subsec_no, string teach_day, string teach_start, string teach_end, string degree_char) { string response = ""; try { string TableName = getTableName(degree_char); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Delete From " + TableName + " Where ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' And COURSE_CODE='" + course_code + "' And SEC_NO=" + sec_no + " And SUBSEC_NO=" + subsec_no + " And TEACHING_DAY = '" + teach_day + "' And TEACHING_START_TIME = '" + teach_start + "' And TEACHING_END_TIME = '" + teach_end + "'"; oracleObj.DeleteCommand = sql; try { if (oracleObj.Delete() > 0) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); } } catch { HttpContext.Current.Session["response"] = "Unit Test:SubCredit:deleteSubCredit" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
protected void delete_seat(String Route_has_Bus_ID) { SqlDataSource seat = new SqlDataSource(); seat.ConnectionString = ConfigurationManager.ConnectionStrings["BusTicketConnectionString1"].ToString(); seat.DeleteCommand = "DELETE FROM [Seat] WHERE Route_has_Bus_ID = " + Route_has_Bus_ID; seat.Delete(); }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString=WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; try { //update //SqlDataSource2.UpdateParameters.Add("Order_date", TextBox1.Text); //SqlDataSource2.UpdateParameters.Add("Assign_numbers", TextBox2.Text); //SqlDataSource2.UpdateParameters.Add("Account_numbers", DropDownList1.Text); //SqlDataSource2.UpdateParameters.Add("Account_abstract", TextBox3.Text); //SqlDataSource2.UpdateParameters.Add("Income", TextBox4.Text); //SqlDataSource2.UpdateParameters.Add("Spend", TextBox5.Text); //SqlDataSource2.UpdateCommand = "Update [Joural_Order_M] set Order_date=@Order_date, Assign_numbers=@Assign_numbers, Account_numbers=@Account_numbers, Account_abstract=@Account_abstract, Income=@Income, Spend=@Spend where Id=" + Request["Id"]; //update SqlDataSource2.DeleteCommand = "delete [Account_Order_M] where Id=" + Request["Id"]; //delete table Joural_Order_M content //SqlDataSource2.DeleteParameters.Add("Order_date", Label1.Text); //SqlDataSource2.DeleteParameters.Add("Assign_numbers", Label2.Text); //SqlDataSource2.DeleteParameters.Add("Account_numbers", Label3.Text); //SqlDataSource2.DeleteParameters.Add("Account_abstract", TextBox3.Text); //SqlDataSource2.DeleteParameters.Add("Income", TextBox4.Text); //SqlDataSource2.DeleteParameters.Add("Spend", TextBox5.Text); //delete table Joural_Order_M content int affraw = SqlDataSource2.Delete(); if (affraw == 0) { Label1.Text = "Error"; } else { Label1.Text = "Delete OK"; Button1.Visible = false; } } catch (Exception ex2) { Response.Write("error" + ex2.ToString()); } finally { SqlDataSource2.Dispose(); } }