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);
}