protected override object GetDataFromDataRow(DataTable dt, int i)
{
TenDiaDiem tenDD = new TenDiaDiem();
tenDD.MaTenDiaDiem = (int)dt.Rows[i]["MaTenDiaDiem"];
tenDD.TenDiaDiem1 = dt.Rows[i]["TenDiaDiem"].ToString();
return((object)tenDD);
}
public bool insertTenDiaDiem(TenDiaDiem tenDD)
{
try
{
connect();
string insertCommand = "INSERT INTO TENDIADIEM VALUES( N'" +
tenDD.TenDiaDiem1 + "')";
executeNonQuery(insertCommand);
disconnect();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public TenDiaDiem getTenDiaDiem(int matendiadiem)
{
connect();
string query = "SELECT * FROM TENDIADIEM WHERE MaTenDiaDiem = " + matendiadiem;
adapter = new SqlDataAdapter(query, connection);
DataSet dataset = new DataSet();
adapter.Fill(dataset);
ArrayList ls = ConvertDataSetToArrayList(dataset);
List <TenDiaDiem> arr = new List <TenDiaDiem>();
foreach (Object o in ls)
{
arr.Add((TenDiaDiem)o);
}
TenDiaDiem dt = arr[0];
return(dt);
}