public DataTable Search_Student(string ID) { DAL.DataBase DAl = new DAL.DataBase(); DAl.open(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50); param[0].Value = ID; dt = DAl.SelectData("Search_Student", param); DAl.close(); return(dt); }
public DataTable delete_cyber(string Id, bool cyber) { DAL.DataBase DAl = new DAL.DataBase(); DAl.open(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@Id", SqlDbType.NVarChar, 50); param[0].Value = Id; param[1] = new SqlParameter("@cyber", SqlDbType.Bit); param[0].Value = cyber; dt = DAl.SelectData("delete_cyber", param); DAl.close(); return(dt); }