<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Line834dch738ly的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Line834dch738ly</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Line834dch738ly]]></copyright><item><title><![CDATA[DataGridView 设置某行的颜色]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/129136041</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/129136041</guid><author>Line834dch738ly</author><pubDate>Tue, 21 Feb 2023 09:29:06 +0800</pubDate><description><![CDATA[DataGridView 改变某行颜色]]></description><category></category></item><item><title><![CDATA[【无标题】]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/128936504</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/128936504</guid><author>Line834dch738ly</author><pubDate>Wed, 08 Feb 2023 15:27:24 +0800</pubDate><description><![CDATA[生成唯一码/随机数]]></description><category></category></item><item><title><![CDATA[Excel导入到DataTable]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/123255882</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/123255882</guid><author>Line834dch738ly</author><pubDate>Thu, 03 Mar 2022 15:42:11 +0800</pubDate><description><![CDATA[public static DataTable ExcelToTableByOleDB(string strExcelPath)
        {
            try
            {
                DataTable dtExcel = new DataTable();
                //数据表
                DataSet ds = new DataSet();
                //获取文件扩展名
      ]]></description><category></category></item><item><title><![CDATA[PDF转图片 Ghostscript.NET]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/122866374</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/122866374</guid><author>Line834dch738ly</author><pubDate>Thu, 10 Feb 2022 18:02:11 +0800</pubDate><description><![CDATA[PDF转图片 Ghostscript.NET
public static void ConvertPdf2Img(string input, string outputPath, ref List&lt;string&gt; output, ref string status)
{
    GhostscriptJpegDevice dev = new GhostscriptJpegDevice();
    output = new List&lt;string&gt;();
    try
    {
]]></description><category></category></item><item><title><![CDATA[Oracle 函数function返回table--管道化表函数]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/122866202</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/122866202</guid><author>Line834dch738ly</author><pubDate>Thu, 10 Feb 2022 17:53:11 +0800</pubDate><description><![CDATA[Oracle 函数function返回table–管道化表函数
1 、定义type行类型
CREATE OR REPLACE TYPE MESTK_ADMIN.LOTPARAM_TABLE_ROW  FORCE  as object
(
  PARAM_NAME varchar2(100),
  PARAM_VALUE     varchar2(100),
  PARAM_TYPE          varchar2(10)
);

2、定义table类型
CREATE OR REPLACE TYPE ME]]></description><category></category></item><item><title><![CDATA[C#中的AsEnumerable() 计算代码运行时间]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/121949349</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/121949349</guid><author>Line834dch738ly</author><pubDate>Wed, 15 Dec 2021 12:11:06 +0800</pubDate><description><![CDATA[C#中的AsEnumerable() 计算代码运行时间
1、引用 System.Data.DataSetExtensions
DataTable dtTable = new DataTable();
            EnumerableRowCollection&lt;DataRow&gt; var_dtTable = dtTable.AsEnumerable().Where&lt;DataRow&gt;(W =&gt; W["NAME"].ToString() == "JAVA");

2、计算代]]></description><category></category></item><item><title><![CDATA[Oracle 查询SQL遇到得坑]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/120145514</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/120145514</guid><author>Line834dch738ly</author><pubDate>Mon, 06 Sep 2021 21:48:47 +0800</pubDate><description><![CDATA[@Oracle 查询SQL遇到得坑
1.聚集函数
错误写法：AVG(COMM)
正确写法：AVG(COALESCE(COMM,0)) 将空值转换为0
对sum没什么影响，但对avg、count可能会出现预料之外得结果
2.当表中没有数据时，不加group by 会返回一行数据（输出正常），但加了group by会没有数据（输出报错）

...]]></description><category></category></item><item><title><![CDATA[Toad中查看执行计划报错：找不到计划表]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/120076637</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/120076637</guid><author>Line834dch738ly</author><pubDate>Fri, 03 Sep 2021 10:41:52 +0800</pubDate><description><![CDATA[Toad中查看执行计划报错：找不到计划表


直接创建TOAD所需要的计划表，该脚本在%oracle_home%\rdbms\admin\utlxplan.sql中，不过该脚本是创建PLAN_TABLE表，表结构一样，改名为TOAD_PLAN_TABLE


修改TOAD参数
将菜单 View -&gt; Options -&gt;Oracle -&gt; General -&gt; Explain Plan Table name中的参数修改为PLAN_TABLE



...]]></description><category></category></item><item><title><![CDATA[C# 在DataTable中使用LINQ]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/119895695</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/119895695</guid><author>Line834dch738ly</author><pubDate>Tue, 24 Aug 2021 18:03:11 +0800</pubDate><description><![CDATA[C# 在DataTable中使用LINQ

将LINQ查询结果保存为DataTable

IEnumerable&lt;DataRow&gt; results1 = (from myRow in dataFile.AsEnumerable()
                                   where myRow.Field&lt;string&gt;("Test Flow Type") == "2"
                                   select ]]></description><category></category></item><item><title><![CDATA[C# Reogrid表格输入数据，在表的单元格不失去焦点的情况下，数据更改失敗]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/118709195</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/118709195</guid><author>Line834dch738ly</author><pubDate>Tue, 13 Jul 2021 19:43:17 +0800</pubDate><description><![CDATA[C# Reogrid表格输入数据，在表的单元格不失去焦点的情况下，数据更改失敗
再點擊OK鍵之前添加以下代碼
this.reoGrid.CurrentWorksheet.EndEdit(EndEditReason.NormalFinish);


]]></description><category></category></item><item><title><![CDATA[2021-07-10]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/118634479</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/118634479</guid><author>Line834dch738ly</author><pubDate>Sat, 10 Jul 2021 14:04:28 +0800</pubDate><description><![CDATA[DataTableToExcel 和 ExcelToDataTable
using System;
using System.IO;
using System.Data;
using System.Reflection;
using System.Diagnostics;
using cfg = System.Configuration;
using System.Runtime.InteropServices;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserMo]]></description><category></category></item><item><title><![CDATA[2021-07-10]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/118634163</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/118634163</guid><author>Line834dch738ly</author><pubDate>Sat, 10 Jul 2021 13:43:22 +0800</pubDate><description><![CDATA[C# 連接Oracle數據庫Procedures
private string connectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(PORT=???))(CONNECT_DATA=(SERVICE_NAME=XXX)));User Id=XXX;Password=XXX";

//ProName：調用的Procedure名   
private void ExecuteSql(strin]]></description><category></category></item><item><title><![CDATA[IDEA java: invalid target release: 11]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/114304139</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/114304139</guid><author>Line834dch738ly</author><pubDate>Wed, 03 Mar 2021 11:21:09 +0800</pubDate><description><![CDATA[IDEA java: invalid target release: 11





]]></description><category></category></item><item><title><![CDATA[Oracle發送http請求]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/109889906</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/109889906</guid><author>Line834dch738ly</author><pubDate>Sat, 21 Nov 2020 10:21:20 +0800</pubDate><description><![CDATA[一、Oracle存儲過程
1、调用发送方法的存储过程
CREATE OR REPLACE procedure test_CallHttpRequest(
   pi_URL  in varchar2,    --發送的Http URL
   po_ReMsg  out varchar2  --返回信息
) is

  obj_xmldoc sys.xmltype;       --響應報文xml對象
  ro_xmlContent varchar2(10000); --請求報文
          
beg]]></description><category></category></item><item><title><![CDATA[.net WebService  wsdl 生成 dll 文件]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/109821814</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/109821814</guid><author>Line834dch738ly</author><pubDate>Thu, 19 Nov 2020 19:43:32 +0800</pubDate><description><![CDATA[一、利用WSDL.exe将webservice文件转化成cs类文件

開始 =》 所有程式 =》Microsoft Visual Studio 2010 =》Visual Studio Tools=》選中 Visual Studio 命令提示字元 (2010) 以系統管理員身份執行

命令： cdC:\Program Files\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6.1 Tools

wsdl/out:XXX_WebService.csh...]]></description><category></category></item><item><title><![CDATA[C#讀寫XML檔]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/105587349</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/105587349</guid><author>Line834dch738ly</author><pubDate>Fri, 17 Apr 2020 19:53:42 +0800</pubDate><description><![CDATA[string bfilePath = @"E:\111" ;
          if (Directory.Exists(bfilePath) == false)
          {
            MessageBox.Show("指定文件夾不存在,請重新選擇路徑！");
            return;
         }
        try
        {
...]]></description><category></category></item><item><title><![CDATA[mybatis设置select返回HashMap，字段值为null时，不会保存key]]></title><link>https://blog.youkuaiyun.com/Line834dch738ly/article/details/105405952</link><guid>https://blog.youkuaiyun.com/Line834dch738ly/article/details/105405952</guid><author>Line834dch738ly</author><pubDate>Thu, 09 Apr 2020 13:21:04 +0800</pubDate><description><![CDATA[mybatis-config.xml

  &lt;?xml version="1.0" encoding="UTF-8"?&gt;
 
 
  
 
 
 


spring-mybatis.xml




 


 


]]></description><category></category></item></channel></rss>