[mssql] 특정 문자열 포함 sp 명 반환 SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%{{문자열}}}%' AND ROUTINE_TYPE = 'PROCEDURE' order by ROUTINE_NAME [fpspread][c#] vb CopyRowRange -> c#CopyRange vb6 http://help.grapecity.com/spread/Spread8/WebSiteHelp/funct147.html fpSpread1.CopyRowRange I& * Row_CNT& + 1, (I& + 1) * Row_CNT&, (I& + 1) * Row_CNT& + 1 c#.net http://helpcentral.componentone.com/NetHelp/SpreadNet6/WF/spwin-commethods.html sprList.Sheets[_sheetIndex].CopyRange(dataIndex * 4, 0, (dataIndex + 1) * 4, 0, dt.Rows.Count, sprList_Sheet1.ColumnHeader.Columns.Count, false); [fpspread][c#] spread lock 1. 셀에 입력이나 수정 삭제가 안되도록 잠근다.sprList_Sheet1.OperationMode = OperationMode.ReadOnly; 2. 원상태로 되돌린다.sprList_Sheet1.OperationMode = OperationMode.Normal; [fpspread][c#] ToolTip 적용 //ToolTip 초기화 FarPoint.Win.Spread.TipAppearance app = new FarPoint.Win.Spread.TipAppearance(); app.BackColor = Color.Yellow; app.Font = new Font("Comic Sans MS", 10); app.ForeColor = Color.Red; sprList.TextTipPolicy = FarPoint.Win.Spread.TextTipPolicy.Floating; sprList.TextTipAppearance = app; private void sprList_TextTipFetch(object sender, FarPoint.Win.Spread.TextTipFetchEventArgs e) { if (e.R.. [fpspread][c#] horizontalScrollBar Left align *.designer.cs //spread this.sprList.SetViewportLeftColumn(0, 0, 0); this.sprList.SetActiveViewport(0, 0, 0); [fpspread][c#] HeaderColumns, Columns Border 라인 넣기 private ComplexBorderSide borderStyle; //Thin line private ComplexBorder complexBorder; //ComplexBorder borderStyle = new ComplexBorderSide(Color.Black, 1, DashStyle.Solid); //Thin line complexBorder = new ComplexBorder(null, null, borderStyle, null); //헤더에 라인 넣기 sprList_Sheet1.ColumnHeader.Cells[0, 1].Border = complexBorder; sprList_Sheet1.ColumnHeader.Cells[1, 17].Border = complexBorder; sprLi.. [fpspread][c#] cell border style using using FarPoint.Win; using System.Drawing.Drawing2D; int _sheetIndex = 0; var targetCell = sprList.Sheets[_sheetIndex].Cells[row, col]; ComplexBorderSide borderStyle = new ComplexBorderSide(Color.Black, 1, DashStyle.Solid); //Thin line targetCell .Border = new ComplexBorder(null, null, borderStyle, borderStyle); [fpspread][c#] vb6 -> c# celltype 변경 //vb6fpSpread1.TypeCurrencyDecPlaces = 2fpSpread1.Value = Val(fpSpread1.Value) / Tmp@ * 100 //c#var currencyCell = new FarPoint.Win.Spread.CellType.CurrencyCellType();currencyCell.Separator = ".";currencyCell.DecimalPlaces = 2;sprList.Sheets[_sheetIndex].Cells[row, col].CellType = currencyCell;var tempCellValue = sprList.Sheets[_sheetIndex].Cells[row, col].Value / tempValue * 100;sprList.Sheets[.. 이전 1 ··· 6 7 8 9 10 11 12 ··· 31 다음