개발자의 사투

DataTable Pivot(DataTable dt, DataColumn pivotColumn, DataColumn pivotValue) { if (dt.isNullOrEmpty() || dt.Rows.Count == 0) return null; // find primary key columns //(i.e. everything but pivot column and pivot value) DataTable temp = dt.Copy(); temp.Columns.Remove(pivotColumn.ColumnName); temp.Columns.Remove(pivotValue.ColumnName); string[] pkColumnNames = temp.Columns.Cast() .Select(c => c.Co..

https://stackoverflow.com/questions/47593142/visual-studio-locked-file Visual Studio locked file I use the latest Visual Studio Community 2017 (15.4). And since i installed Visual Studio (never worked in it before). I have ALWAYS despite version had this issue. After compiling a couple of time... stackoverflow.com //$(TargetPath) == "$(TargetDir)$(TargetFileName)"? 프로젝트 → 속성 → 빌드이벤트 → 빌드 전 이벤트 추..

CONVERT(CHAR(10), DATETIME, 23) 2021-01-02 YYYY-MM-DD CONVERT(CHAR(23), DATETIME, 21) 2021-01-02 13:14:15.678 YYYY-MM-DD HH:MM:SS.MS CONVERT(CHAR(8), DATETIME, 112) 20210102 YYYYMMDD

DECLARE @TEMP TABLE ( idx INT, value varchar(10) ) INSERT INTO @TEMP(idx, value) values (1, 'Ga') INSERT INTO @TEMP(idx, value) values (2, 'Na') INSERT INTO @TEMP(idx, value) values (2, 'Da') INSERT INTO @TEMP(idx, value) values (3, 'Ra') INSERT INTO @TEMP(idx, value) values (3, 'Ma') INSERT INTO @TEMP(idx, value) values (3, 'Ba') SELECT * FROM @TEMP WHERE 1=1 SELECT DISTINCT STUFF(( SELECT ',' ..

CheckListBoxControl.Apperance.TextOptions.WordWrap = Wrap MeasureItem 이벤트 설정 private void checkedListBoxControl1_MeasureItem(object sender, MeasureItemEventArgs e) { DevExpress.XtraEditors.CheckedListBoxControl lb = sender as DevExpress.XtraEditors.CheckedListBoxControl; string itemValue = Convert.ToString(lb.Items[e.Index]); float i = 0; using (System.Drawing.Graphics graphics = System.Drawing...

devenv.exe 파일 검색 위치 예시(C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE) devenv.exe 선택 → 마우스 우클릭 → 호환성 문제 해결 선택 프로그램 문제 해결 선택 → 프로그램에 추가 권한 필요 → 다음

DevExpress.XtraRichEdit.RichEditControl 사용 시 특정 행을 비교해서 굵게 표시하는 기능 private void specificLineBold(List compareStr) { if (compareStr.isNullOrEmpty()) { return; } Document document = richEditControl1.Document; for (int i = 0; i < richEditControl1.Document.Paragraphs.Count; i++) { DocumentRange documentRange = richEditControl1.Document.Paragraphs[i].Range; string specificLineStr = richEditControl1.D..

C#으로 SendMessage 와 WndProc를 사용하던 중 COM DLL을 호출 할 경우 0X8001010d오류가 발생하였다. 구글링 검색후 해당처럼 적용하니 매우 정상적으로 작동되었다. private delegate void CheckDelegate(stirng a) protected override void WndProc(ref Message m) { try { switch (m.Msg) { case clsWin32.WM_COPYDATA: CheckDelegate function; function = new CheckDelegate(CheckInf); IAsyncResult result = function.BeginInvoke(""); break; default: break; } } catch (..

GridOptionsView.ShowIndicator - allows you to hide the row indicator panel. GridOptionsView.ShowIndicator Property | WinForms Controls | DevExpress Documentation GridOptionsView.ShowIndicator Property Namespace: DevExpress.XtraGrid.Views.Grid Assembly: DevExpress.XtraGrid.v20.1.dll Declaration C# VB.NET [DefaultValue(true)] [XtraSerializableProperty] public virtual bool ShowIndicator { get; set;..

insert into InfoUser (UserId, Code) select UserId, 617 as Code from InfoUser group by UserId