2018年7月25日
C#读写Excel
摘要： Dictionary dict = new Dictionary(); List list = new List(); object missing = Missing.Value; Application excel = new Application(); excel.Visible = false; excel.UserControl = true; Workbook book = ex... 阅读全文
posted @ 2018-07-25 13:37 starriver 阅读(592) 评论(0) 推荐(0)
数据库查询的table结果转成对应实体类
摘要： /// /// table转实体类 /// /// private static void Model(System.Data.DataTable table) { models = new List(); foreach (DataRow row in table.Rows) { T model = new T(); foreach... 阅读全文
posted @ 2018-07-25 11:50 starriver 阅读(735) 评论(0) 推荐(0)
连接oracle(不需要下载其他程序,只引用一个dll)
摘要： OracleConnection con = new OracleConnection(@"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XXX)));Persist Security Info=True;User ID=XXX;Pas... 阅读全文
posted @ 2018-07-25 11:49 starriver 阅读(403) 评论(0) 推荐(0)