Mit

# Xaml #CS // Error1. CheckBox mycheckbox = dataGrid1.Columns[7].GetCellContent(dataGrid1.Items[Row_num])) as CheckBox; // Error2. bool? chks = ((CheckBox)dataGrid1.Columns[7].GetCellContent(dataGrid1.Items[Row_num])).IsChecked;).IsChecked;) // Solved FrameworkElement item = dataGrid1.Columns[7].GetCellContent(dataGrid1.Items[Row_num]); DataGridTemplateColumn temp = (dataGrid1.Columns[7] as Data..

https://docs.microsoft.com/en-us/dotnet/framework/wpf/graphics-multimedia/how-to-animate-a-rectangle How to: Animate a Rectangle - WPF How to: Animate a Rectangle In this article --> This example shows how to animate changes to the size and position of a rectangle. Example The following example uses an instance of the RectAnimation class to animate the Rect property of a RectangleGeometry docs.m..

DataTable Column Sum Total DataTable sumDataTable = new DataTable(); sumDataTable.Columns.Add("total", typeof(string)); sumDataTable.Columns.Add("workedhours", typeof(int)); sumDataTable.Columns.Add("tfshours", typeof(int)); DataRow row = sumDataTable.NewRow(); row["total"] = "Total"; row["workedhours"] = oldDataTable.Compute("Sum(workedhours)", "workedhours > 0"); row["tfshours"] = oldDataTable..

[MSSQL] 서버 수준의 URN 필터가 잘못되었습니다. SELECT @@SERVERNAME '현재 서버네임 확인 1. 서버네임삭제 EXEC sp_dropserver '조회된 서버네임' GO 2. 서버네임생성 EXEC sp_addlinkedserver '?????\SQLEXPRESS' GO

>>첨부된 파일 다운로드 >> 압축풀기 >> 압축해제된 renewcert 폴더에 인증키복사 CMD(관리자로그인) >> CD 압축해제된폴더 >> renewcert 기존키이름.pfx 새로운키이름.pfx "CN=Teon\Teon" 비밀번호 * 인증기간은 10년으로 변경됨. http://may.be/renewcert/

private void Text_body_KeyDown(object sender, KeyEventArgs e) { var myTextBox = (TextBox)sender; int caret = myTextBox.CaretIndex; int iLine = myTextBox.GetLineIndexFromCharacterIndex(caret); if (iLine < 11) { e.Handled = true; return; } }

convert(datetime, left(CB_insert_time,charindex(' ',@시간,1)-1) + ' ' + right(@시간,charindex(' ',reverse(@시간),1)-1) + case when charindex('오전',@시간,1) > 0 then 'AM' else 'PM' end )

https://stackoverflow.com/questions/27157390/wpf-custom-window-windows-edge-resize-feature Wpf custom window, Windows edge resize feature Got a custom wpf window (WindowStyle=None, AllowTransparancy=true) and wondering how to get Windows edge resize features to work.. you know when draging window and mouse touches left, right or top ... stackoverflow.com

Xaml code:​​​​​​​ public MainWindow() { InitializeComponent(); for (int i = 0; i

Microsoft.Office.Interop을 사용하여 셀별로 복사하면 너무오래걸려 Row 일괄 복사하도록하여 성능향상 DataGrid -> DataView -> DataTable 로 변환하고 foreach 에서 DataRow 별로 일괄 붙이기. DataView Dview = (DataView)result_grid2.ItemsSource as DataView; DataTable Ex_table = Dview.Table; string excelRange1 = "A" + cellRowIndex;// 복사 시작범위 string excelRange2 = "BL" + cellRowIndex;// 복사 종료범위 worksheet.Range[excelRange1, excelRange2].Value2 = dr.Item..