开发环境:SQL SERVER 2005 + C# 2005 + WINDOWS SERVER 2003 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
public virtual DataSet1.FactoryManualDataTable GetNoSmallImage() {
this.Adapter.SelectCommand = this.CommandCollection[3];
DataSet1.FactoryManualDataTable dataTable = new DataSet1.FactoryManualDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
...
this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand();
this._commandCollection[3].Connection = this.Connection;
this._commandCollection[3].CommandText = "SELECT ID, CategoryName, FactoryName, ShortName, UserName, SourceImagePath,FileNa" +
"me, SmallImagePath, IsRecognised, Details, Memo, AddDate\r\nFROM FactoryManual\r\nWH" +
"ERE (SmallImagePath IS NULL)";
this._commandCollection[3].CommandType = global::System.Data.CommandType.Text;FactoryManual表有两个约束:
约束1:ALTER TABLE [dbo].[FactoryManual] ADD CONSTRAINT [DF_FactoryManual_new_ProductId] DEFAULT (newid()) FOR [new_ProductId]
约束2:ALTER TABLE [dbo].[FactoryManual] ADD CONSTRAINT [DF_FactoryManual_AddDate] DEFAULT (getdate()) FOR [AddDate]试过把dataset的enforcecontraints设为false也不行.执行GetNoSmallImage()老是出现错误:
未能启用约束。一行或多行中包含违反非空、唯一或外键约束的值。请大家指教!
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
public virtual DataSet1.FactoryManualDataTable GetNoSmallImage() {
this.Adapter.SelectCommand = this.CommandCollection[3];
DataSet1.FactoryManualDataTable dataTable = new DataSet1.FactoryManualDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
...
this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand();
this._commandCollection[3].Connection = this.Connection;
this._commandCollection[3].CommandText = "SELECT ID, CategoryName, FactoryName, ShortName, UserName, SourceImagePath,FileNa" +
"me, SmallImagePath, IsRecognised, Details, Memo, AddDate\r\nFROM FactoryManual\r\nWH" +
"ERE (SmallImagePath IS NULL)";
this._commandCollection[3].CommandType = global::System.Data.CommandType.Text;FactoryManual表有两个约束:
约束1:ALTER TABLE [dbo].[FactoryManual] ADD CONSTRAINT [DF_FactoryManual_new_ProductId] DEFAULT (newid()) FOR [new_ProductId]
约束2:ALTER TABLE [dbo].[FactoryManual] ADD CONSTRAINT [DF_FactoryManual_AddDate] DEFAULT (getdate()) FOR [AddDate]试过把dataset的enforcecontraints设为false也不行.执行GetNoSmallImage()老是出现错误:
未能启用约束。一行或多行中包含违反非空、唯一或外键约束的值。请大家指教!
解决方案 »
- C#中如何获取资源文件中的Excle文件?
- 一上午看了都没思路,关于SQL的问题
- C#连接oracle 出现的版本不同的问题
- 大家好!一个关于Timer控件的提问!谢谢!
- 如何从一个文件夹里读取多个文件啊?
- 寻C#好书
- 求助啊,一个简单的问题,关于ListView的
- 谁给小弟做出来,并可执行,我给他1000000000000000000000000分!!!!!
- “图表,打印”怎么用?只需各位给引个路!在线等待!!
- 使用Microsoft Visual Studio .NET的C#做ASP.NET程序的问题
- 菜鸟提问youjavascript 复选框问题
- 求教...水晶报表加载问题,我在线等ING.....急!!急!!急!!急!!急!!急!!
select * from FactoryManual where adddate>'2008-01-01'
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FactoryManual](
[ID] [int] IDENTITY(1,1) NOT NULL,
[new_ProductId] [uniqueidentifier] NOT NULL CONSTRAINT [DF_FactoryManual_new_ProductId] DEFAULT (newid()),
[CategoryName] [nvarchar](80) COLLATE Chinese_PRC_CI_AS NULL,
[FactoryName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL,
[ShortName] [nvarchar](80) COLLATE Chinese_PRC_CI_AS NULL,
[UserName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[SourceImagePath] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
[SmallImagePath] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[FileName] [nvarchar](150) COLLATE Chinese_PRC_CI_AS NULL,
[IsRecognised] [bit] NOT NULL,
[Details] [text] COLLATE Chinese_PRC_CI_AS NULL,
[Memo] [nvarchar](300) COLLATE Chinese_PRC_CI_AS NULL,
[AddDate] [smalldatetime] NOT NULL CONSTRAINT [DF_FactoryManual_AddDate] DEFAULT (getdate()),
CONSTRAINT [PK_FactoryManual] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FactoryManual](
[ID] [int] IDENTITY(1,1) NOT NULL,
[new_ProductId] [uniqueidentifier] NOT NULL CONSTRAINT [DF_FactoryManual_new_ProductId] DEFAULT (newid()),
[CategoryName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[FactoryName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[ShortName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[UserName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[SourceImagePath] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL,
[SmallImagePath] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[FileName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[IsRecognised] [bit] NOT NULL,
[Details] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
[Memo] [nvarchar](150) COLLATE Chinese_PRC_CI_AS NULL,
[AddDate] [smalldatetime] NOT NULL CONSTRAINT [DF_FactoryManual_AddDate] DEFAULT (getdate()),
CONSTRAINT [PK_FactoryManual] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]