devexpress datagrid 与ColorEdit 如何存入数据库
这样一个数据库表,Color字段,我们希望与datagrid关联:
USE [SchedulerDB] GO /****** Object: Table [dbo].[Resources] Script Date: 11/19/2014 10:16:03 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[Resources]) AND type in (NU)) DROP TABLE [dbo].[Resources] GO USE [SchedulerDB] GO /****** Object: Table [dbo].[Resources] Script Date: 11/19/2014 10:16:03 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Resources]( [UniqueID] [int] IDENTITY(1,1) NOT NULL, [ResourceID] [int] NOT NULL, [ResourceName] [nvarchar](50) NULL, [Color] [int] NULL, [Image] [image] NULL, [CustomField1] [nvarchar](max) NULL, CONSTRAINT [PK_Resources] PRIMARY KEY CLUSTERED ( [UniqueID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=NMS_Description, @value=N岗位 , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NTABLE,@level1name=NResources GO
在一切OK后,发现,会遇到一个没有实现IConverible接口的错误。
解决办法是:
也就是说,把StoreColorAsInteger设置成为True