public DataTable Get_Student_Info(string Id) { DAL.DataBase dl = new DAL.DataBase(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@Id", SqlDbType.NVarChar, 50); param[0].Value = Id; dl.open(); DataTable dt = new DataTable(); dt = dl.SelectData("Get_Student_Info", param); return(dt); }
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); }
public DataTable Login(string Id, string Password) { DAL.DataBase dl = new DAL.DataBase(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@Id", SqlDbType.NChar, 10); param[0].Value = Id; param[1] = new SqlParameter("@Password", SqlDbType.NChar, 10); param[1].Value = Password; dl.open(); DataTable dt = new DataTable(); dt = dl.SelectData("SP_LOGIN", param); return(dt); }