public static void Save(FrameSet one, string which) { string sql = "insert into t_frameset(theHeight,theWidth,theSrc,theType) values({0},{1},'{2}','{3}')"; sql = string.Format(sql, one.Height.ToString(), one.Width.ToString(), one.Src, which); AccessDb.ExecuteNonQuery(sql); }
public static void Edit(FrameSet one, string which) { string sql = "update t_frameset set theHeight={0},theWidth={1},theSrc='{2}' where theType='{3}'"; sql = string.Format(sql, one.Height.ToString(), one.Width.ToString(), one.Src, which); AccessDb.ExecuteNonQuery(sql); }
public static FrameSet GetOne(string which) { string sql = "select * from t_frameset where theType='" + which + "'"; DataTable dt = AccessDb.Execute(sql).Tables[0]; if (dt == null) { return(null); } FrameSet one = new FrameSet(); one.Height = int.Parse(dt.Rows[0]["theHeight"].ToString()); one.Width = int.Parse(dt.Rows[0]["theWidth"].ToString()); one.Src = dt.Rows[0]["theSrc"].ToString(); return(one); }