public bool Edit(ColumnImgs item) { string sqlstr = "UPDATE [tbl_ColumnImgs] SET [CID] ='" + item.CID + "',[Title] = '" + item.Title + "',[ImgStr] = '" + item.ImgStr + "',[ImgLink] ='" + item.ImgLink + "',[Orders] ='" + item.Orders + "' WHERE id=" + item.ID; int res = DbHelperSQLite.ExecuteSql(sqlstr); return(res > 0); }
public bool Add(ColumnImgs item) { string sqlstr = "INSERT INTO [tbl_ColumnImgs] ([Id] ,[CID] ,[Title] ,[ImgStr] ,[ImgLink] ,[Orders]) VALUES (null ,'" + item.CID + "','" + item.Title + "','" + item.ImgStr + "','" + item.ImgLink + "','" + item.Orders + "')"; int res = DbHelperSQLite.ExecuteSql(sqlstr); return(res > 0); }