public List <HocPhanN> GetHP(string s)
{
List <HocPhanN> list = new List <HocPhanN>();
DataTable dataTable = new DataTable();
using (sqlConnection = new SqlConnection(Connect))
{
var sql = "select * from HocPhan where ID_Khoa = '" + s + "'";
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
sqlDataAdapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
HocPhanN hocPhan = new HocPhanN();
//hocPhan.ID_Khoa = row["ID_Khoa"].ToString();
hocPhan.Ten_HP = row["Ten_HP"].ToString();
//hocPhan.Ma_SV = row["Ma_SV"].ToString();
//hocPhan.Ma_D = row["Ma_D"].ToString();
hocPhan.Ma_HP = row["Ma_HP"].ToString();
list.Add(hocPhan);
}
}
return(list);
}
public List <HocPhanN> SearchHP(string s)
{
DataTable dataTable = new DataTable();
List <HocPhanN> list = new List <HocPhanN>();
var sql = "select Ma_HP,Ten_HP from HocPhan where Ma_HP like '%" + s + "%'";
list.Clear();
using (sqlConnection = new SqlConnection(Connect))
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
sqlDataAdapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
HocPhanN hocPhan = new HocPhanN();
hocPhan.Ma_HP = row["Ma_HP"].ToString();
hocPhan.Ten_HP = row["Ten_HP"].ToString();
list.Add(hocPhan);
}
}
return(list);
}
