摘要：写配置文件public void WriteConfigurationFile(string path) { using (System.IO.StreamWriter streamWriter = new System.IO.StreamWriter(path, true)) { if (_vdtSource == null || _vdtSource.Rows.Count == 0) { return; }... 阅读全文
想办法处理gridControl行中的checkedit事件
2013-06-01 12:06 by hongjiumu, 2117 阅读, 0 推荐, 收藏,
摘要：想办法处理gridControl行中的checkedit事件：private void Reorganize(){ GridControl gridControl = gridControl1; DevExpress.XtraGrid.Columns.GridColumn checkColumn = ((ColumnView)gridControl.Views[0]).Columns["Checked"]; RepositoryItemCheckEdit et = new RepositoryItemCheckEdit(); checkColumn.ColumnEdit.. 阅读全文
执行语句使用exec (sql)
2013-06-01 12:00 by hongjiumu, 871 阅读, 0 推荐, 收藏,
摘要：declare @fields varchar(max)set @fields=(select name+',' from sys.columns where object_id = object_id(N'p.e_LOG_AFSIP_BLOCK_ALL')and name in ( select ColName from cfg.Dict_Col where TblID=(select TblID from cfg.Dict_Tbl where TblName='p.e_LOG_AFSIP_BLOCK_ALL')) for xml path(& 阅读全文
能不能多想一点呢？
2013-06-01 11:59 by hongjiumu, 151 阅读, 0 推荐, 收藏,
摘要：一个老外走在桥上，看到河里有一人在摸着什么。不解问：“你在干嘛呢？”河里人答：“摸石头”！老外在桥上问：“摸石头干嘛？”河里人说：“过河。”老外说：“这不是有桥吗？干嘛不走？”河里人说：“这个，我还带着渔网呢，顺便捞点鱼。”老外问:“你到底是想过河还是想捞鱼，”河里人：“你傻X啊，直接说捞鱼会被人骂的！” 阅读全文
取得一个表的所有字段
2013-06-01 11:58 by hongjiumu, 190 阅读, 0 推荐, 收藏,
摘要：select name from sys.columns where object_id = object_id(N'表名') 阅读全文
删除datatable的重复行
2013-04-25 23:31 by hongjiumu, 344 阅读, 0 推荐, 收藏,
摘要：删除datatable的重复行private void RemoveRepeat(ref System.Data.DataTable dataTableSource) { List<string> list = new List<string>(); StringBuilder builder = null; System.Data.DataRow currenDr = null; string currentStr = string.Empty; for (int i ... 阅读全文
导出大Excel
2013-04-25 23:30 by hongjiumu, 297 阅读, 0 推荐, 收藏,
摘要：public static void Export(string filePath,string strSql){ ExcelApp.Application excelApp = new ExcelApp.Application(); ExcelApp._Workbook workbook = excelApp.Workbooks.Add(); try { workbook.Activate(); ExcelApp._Worksheet worksheet = workbook.Worksheets.Add(); string ... 阅读全文
System.AppDomain.CurrentDomain.BaseDirectory总是取得根目录
2013-04-21 10:37 by hongjiumu, 624 阅读, 0 推荐, 收藏,
摘要：System.AppDomain.CurrentDomain.BaseDirectory总是取得根目录 阅读全文
open the folder
2013-04-21 10:36 by hongjiumu, 277 阅读, 0 推荐, 收藏,
摘要：private void OpenFolder(string path){ string windir = Environment.GetEnvironmentVariable("WINDIR"); System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo.FileName = windir + @"\explorer.exe"; process.StartInfo.Arguments = path; process.Start();} 阅读全文
winform调用plugin
2013-04-20 22:45 by hongjiumu, 365 阅读, 0 推荐, 收藏,
摘要：winform插件开发：try { System.Reflection.Assembly assembly = System.Reflection.Assembly.LoadFrom(Application.StartupPath + "\\Kuwait2GNSNForms.dll"); Type[] types = assembly.GetTypes(); foreach (Type type in types) { ... 阅读全文
浙公网安备 33010602011771号