조회시 제약 조건을 활성화하지 못했습니다.

WinForms윈폼 조회시 제약 조건을 활성화하지 못했습니다.

추천0 비추천 0

페이지 정보

작성자 김대은

작성일 2022-10-10 09:00 조회 1,219회 댓글 5건

제품 버전 : C1.Win.C1TrueDBGrid.2 2.0.20123.61277

컨트롤 이름 : C1.Win.C1TrueDBGrid.2

본문

댓글목록

김대은님의 댓글

김대은

작성일 22-10-10 09:04

미안하지만 테이블의 데이타를 조회시 정상적으로 조회가 됩니다.
C1.Win.C1TrueDBGrid.2에 조회시 조회는 되지만 오류 메세지가 보여지면서
Groupping이 되지를 않습니다.
그런데 재 조회시에는 정상적으로 됩니다.

private void btn조회_Click(object sender, EventArgs e)

{

try

{

// TODO: 이 코드는 데이터를 'dataSet11.KEUM_CIRCUIT' 테이블에 로드합니다. 필요한 경우 이 코드를 이동하거나 제거할 수 있습니다.

this.kEUM_CIRCUITTableAdapter.Fill(this.kEUM_DBDataSet.KEUM_CIRCUIT, dtFromDate.Value.ToShortDateString(), dtToDate.Value.ToShortDateString());

this.c1TrueDBGrid1.GroupedColumns.Add(this.c1TrueDBGrid1.Columns["CHUL_DATE"]);

this.c1TrueDBGrid1.DataView = C1.Win.C1TrueDBGrid.DataViewEnum.GroupBy;

this.c1TrueDBGrid1.Columns["CHUL_DATE"].GroupInfo.Interval = C1.Win.C1TrueDBGrid.GroupIntervalEnum.Year;

this.c1TrueDBGrid1.Splits[0].DisplayColumns["ACT_A2"].Merge = C1.Win.C1TrueDBGrid.ColumnMergeEnum.Free;

this.c1TrueDBGrid1.Splits[0].DisplayColumns["GUBUN"].Merge = C1.Win.C1TrueDBGrid.ColumnMergeEnum.Free;

this.c1TrueDBGrid1.Splits[0].DisplayColumns["PALLET_TAG"].Merge = C1.Win.C1TrueDBGrid.ColumnMergeEnum.Free;

// 그룹화하는 동안 HireDate 열을 계속 표시합니다.

this.c1TrueDBGrid1.Columns["CHUL_DATE"].GroupInfo.ColumnVisible = true;

statusStrip1.Items.Add("조회한 내용은 총 " + this.kEUM_DBDataSet.KEUM_CIRCUIT.Rows.Count.ToString() + "건이 조회되었습니다.");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

미안하지만 테이블의 데이타를 조회시 정상적으로 조회가 됩니다.<br>C1.Win.C1TrueDBGrid.2에 조회시 조회는 되지만 오류 메세지가 보여지면서<br>Groupping이 되지를 않습니다.<br>그런데 재 조회시에는 정상적으로 됩니다.<br><div><br><div>&nbsp; &nbsp; &nbsp; &nbsp; private void btn조회_Click(object sender, EventArgs e)</div><div>&nbsp; &nbsp; &nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // TODO: 이 코드는 데이터를 'dataSet11.KEUM_CIRCUIT' 테이블에 로드합니다. 필요한 경우 이 코드를 이동하거나 제거할 수 있습니다.</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.kEUM_CIRCUITTableAdapter.Fill(this.kEUM_DBDataSet.KEUM_CIRCUIT, dtFromDate.Value.ToShortDateString(), dtToDate.Value.ToShortDateString());</div><div><br></div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.c1TrueDBGrid1.GroupedColumns.Add(this.c1TrueDBGrid1.Columns["CHUL_DATE"]);</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.c1TrueDBGrid1.DataView = C1.Win.C1TrueDBGrid.DataViewEnum.GroupBy;</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.c1TrueDBGrid1.Columns["CHUL_DATE"].GroupInfo.Interval = C1.Win.C1TrueDBGrid.GroupIntervalEnum.Year;</div><div><br></div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.c1TrueDBGrid1.Splits[0].DisplayColumns["ACT_A2"].Merge = C1.Win.C1TrueDBGrid.ColumnMergeEnum.Free;</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.c1TrueDBGrid1.Splits[0].DisplayColumns["GUBUN"].Merge = C1.Win.C1TrueDBGrid.ColumnMergeEnum.Free;</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.c1TrueDBGrid1.Splits[0].DisplayColumns["PALLET_TAG"].Merge = C1.Win.C1TrueDBGrid.ColumnMergeEnum.Free;</div><div><br></div><div><br></div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // 그룹화하는 동안 HireDate 열을 계속 표시합니다.</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.c1TrueDBGrid1.Columns["CHUL_DATE"].GroupInfo.ColumnVisible = true;</div><div><br></div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; statusStrip1.Items.Add("조회한 내용은 총 " + this.kEUM_DBDataSet.KEUM_CIRCUIT.Rows.Count.ToString() + "건이 조회되었습니다.");</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception ex)</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(ex.Message);</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }</div><div>&nbsp; &nbsp; &nbsp; &nbsp; }</div></div>

김대은님의 댓글

김대은

작성일 22-10-10 09:04

어떻케 해결해야 하는지 고수님들 부탁드립니다.

김대은님의 댓글

김대은

작성일 22-10-10 09:08

생성된 테이블이 하나이고 아래의 내용이 테이블 스크립트입니다.

CREATE TABLE KEUM_CIRCUIT

(

PROJ_NO NCHAR(6), -- 1 프로젝트 2

ACT_A2 NVARCHAR(20), -- 2 액티비티 3

CIRCUIT_NO NVARCHAR(50), -- 4 서킷 번호 7

SUB_NO NCHAR(10), -- 5 SUB NO 8

CIRCUIT_LEN FLOAT, -- 6 서킷 길이 9

GUBUN NVARCHAR(10), -- 7 구분 (태선, 세선) 1

NAT_NO NVARCHAR(20), -- 3 자재번호 4

NAT_DESC TEXT, -- 8 자재내역상세 5

IBGO_DRUM_NO NVARCHAR(10), -- 9 입고드럼번호 10

CUT_NO NVARCHAR(8), -- 10 절단순번 12

GROUP_NO NVARCHAR(15), -- 11 Group No 13

PALLET_TAG NVARCHAR(24), -- 12 팔래트Tag 번호 14

CHUL_REQ NVARCHAR(80), -- 13 요청자 15

REQ_LOCATE TEXT, -- 14 요청장소 16

CABLE_CUT_ORDER NVARCHAR(15), -- 15 케이블 절단오더 17

CHUL_REQ_DATE DATE, -- 16 불출요청일 19

CUT_EXP_DATE DATE, -- 17 절단예정일 20

CUT_DATE DATE, -- 18 절단일자 21

CHUL_DATE DATE, -- 19 출고일자 24

NAP_DATE DATE, -- 20 납품일자 22

CHUL_PALLET_NO NVARCHAR(22), -- 21 불출 팔래트번호 18

CHUL_CAR_NO NVARCHAR(40), -- 22 불출 차량번호 26

EXP_DATE DATE, -- 23 불출일자 25

JUKCHI_AREA VARCHAR(20), -- 24 배치번호 PDA에서 입력할 내용

C_MEMO TEXT, -- 25 메모 PDA에서 입력할 내용

PRIMARY KEY(PROJ_NO, ACT_A2, CIRCUIT_NO, SUB_NO)

)

이 내용을 CHUL_DATE로 그룹핑해서 조회하는 프로그램입니다..

생성된 테이블이 하나이고 아래의 내용이 테이블 스크립트입니다.<br><div>CREATE TABLE KEUM_CIRCUIT</div><div>(</div><div>&nbsp; &nbsp; &nbsp;PROJ_NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NCHAR(6),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 1 프로젝트&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</div><div>&nbsp; &nbsp; &nbsp;ACT_A2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NVARCHAR(20),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 2 액티비티&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</div><div>&nbsp; &nbsp; &nbsp;CIRCUIT_NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NVARCHAR(50),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 4 서킷 번호&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7</div><div>&nbsp; &nbsp; &nbsp;SUB_NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NCHAR(10),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -- 5 SUB NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8</div><div>&nbsp; &nbsp; &nbsp;CIRCUIT_LEN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FLOAT,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -- 6 서킷 길이&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9</div><div>&nbsp; &nbsp; &nbsp;GUBUN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NVARCHAR(10),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 7 구분 (태선, 세선)&nbsp; &nbsp; &nbsp; 1</div><div>&nbsp; &nbsp; &nbsp;NAT_NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NVARCHAR(20),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 3 자재번호&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4</div><div>&nbsp; &nbsp; &nbsp;NAT_DESC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEXT,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 8 자재내역상세&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5</div><div>&nbsp; &nbsp; &nbsp;IBGO_DRUM_NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NVARCHAR(10),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 9 입고드럼번호&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</div><div>&nbsp; &nbsp; &nbsp;CUT_NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NVARCHAR(8),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -- 10 절단순번&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12</div><div>&nbsp; &nbsp; &nbsp;GROUP_NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NVARCHAR(15),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 11 Group No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13</div><div>&nbsp; &nbsp; &nbsp;PALLET_TAG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NVARCHAR(24),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 12 팔래트Tag 번호&nbsp; &nbsp; &nbsp; &nbsp; 14</div><div>&nbsp; &nbsp; &nbsp;CHUL_REQ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NVARCHAR(80),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 13 요청자&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15</div><div>&nbsp; &nbsp; &nbsp;REQ_LOCATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEXT,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 14 요청장소&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 16</div><div>&nbsp; &nbsp; &nbsp;CABLE_CUT_ORDER&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NVARCHAR(15),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 15 케이블 절단오더&nbsp; &nbsp; &nbsp; &nbsp;17</div><div>&nbsp; &nbsp; &nbsp;CHUL_REQ_DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DATE,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 16 불출요청일&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19&nbsp; &nbsp; &nbsp;</div><div>&nbsp; &nbsp; &nbsp;CUT_EXP_DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATE,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 17 절단예정일&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20</div><div>&nbsp; &nbsp; &nbsp;CUT_DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATE,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 18 절단일자&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21</div><div>&nbsp; &nbsp; &nbsp;CHUL_DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DATE,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 19 출고일자&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 24&nbsp;</div><div>&nbsp; &nbsp; &nbsp;NAP_DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATE,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 20 납품일자&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22</div><div>&nbsp; &nbsp; &nbsp;CHUL_PALLET_NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NVARCHAR(22),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 21 불출 팔래트번호&nbsp; &nbsp; &nbsp; &nbsp;18</div><div>&nbsp; &nbsp; &nbsp;CHUL_CAR_NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NVARCHAR(40),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 22 불출 차량번호&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;26&nbsp;</div><div>&nbsp; &nbsp; &nbsp;EXP_DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATE,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 23 불출일자&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25</div><div>&nbsp; &nbsp; &nbsp;JUKCHI_AREA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VARCHAR(20),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -- 24 배치번호&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PDA에서 입력할 내용</div><div>&nbsp; &nbsp; &nbsp;C_MEMO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEXT,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- 25 메모&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PDA에서 입력할 내용</div><div>&nbsp; &nbsp; &nbsp;PRIMARY KEY(PROJ_NO, ACT_A2, CIRCUIT_NO, SUB_NO)</div><div>)</div><br><br>이 내용을 CHUL_DATE로 그룹핑해서 조회하는 프로그램입니다..<br><br>

김대은님의 댓글

김대은

작성일 22-10-11 15:56

고수님들 답 좀 달아주시면 안 될까요? 너무 급해서요 ㅠㅠ

김대은님의 댓글

김대은

작성일 22-10-20 22:19

안녕하십니까?
제발 고수님 도와 주십시요..

WinForms윈폼 Re: 조회시 제약 조건을 활성화하지 못했습니다.

추천0 이 글을 추천하셨습니다 비추천0

페이지 정보

작성자 GCK싸이먼

작성일 2022-10-12 09:01 댓글 0건

본문

댓글목록

등록된 댓글이 없습니다.

조회시 제약 조건을 활성화하지 못했습니다. > Q&A | 토론

MESCIUS 포럼

MESCIUS 커뮤니티

MESCIUS 포럼

MESCIUS 커뮤니티

ComponentOne

Q&A | 토론

WinForms윈폼 조회시 제약 조건을 활성화하지 못했습니다.

페이지 정보

본문

관련링크

댓글목록

김대은님의 댓글

김대은님의 댓글

김대은님의 댓글

김대은님의 댓글

김대은님의 댓글

WinForms윈폼 Re: 조회시 제약 조건을 활성화하지 못했습니다.

페이지 정보

본문

관련링크

댓글목록

카테고리

인기글

최신글

셀럽