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