protected override object GetDataFromDataRow(DataTable dt, int i) { BinhLuan bl = new BinhLuan(); bl.MaBinhLuan = (int)dt.Rows[i]["MaBinhLuan"]; bl.IdUser = dt.Rows[i].IsNull("IdUser") ? 0 : (int)dt.Rows[i]["IdUser"]; bl.NoiDung = dt.Rows[i]["NoiDung"].ToString(); bl.ThoiGian = (DateTime)dt.Rows[i]["ThoiGian"]; bl.MaDuLieu = (int)dt.Rows[i]["MaDuLieu"]; bl.TrangThai = (int)dt.Rows[i]["TrangThai"]; return((object)bl); }
public bool insertBinhLuan(BinhLuan bl) { try { connect(); string insertCommand = "INSERT INTO BINHLUAN VALUES(" + bl.MaDuLieu + ", " + bl.IdUser + ", N'" + bl.NoiDung + "', '" + bl.ThoiGian.Year + "-" + bl.ThoiGian.Month + "-" + bl.ThoiGian.Day + " " + bl.ThoiGian.Hour + ":" + bl.ThoiGian.Minute + ":" + bl.ThoiGian.Second + "'," + bl.TrangThai + ")"; executeNonQuery(insertCommand); disconnect(); return(true); } catch (Exception e) { return(false); } }