<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[sunping177的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/sunping177</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; sunping177]]></copyright><item><title><![CDATA[datatable循环查询时，如果有重复项，不进行插入]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/149560715</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/149560715</guid><author>sunping177</author><pubDate>Wed, 23 Jul 2025 09:20:35 +0800</pubDate><description><![CDATA[如果 string itemcode = dr["CHARGE_ITEM_CODE"].ToString();itemcode包含在 strlist中，跳出，如果不包含在 strlist中继续运行插入。声明变量 List<string> strlist = new List<string>();dtLabAppItem循环，dtClinicVsCharge通过它的值查询出来多条数据，]]></description><category></category></item><item><title><![CDATA[dataset中数据忽略一列数据之后去掉重复项]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/148533306</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/148533306</guid><author>sunping177</author><pubDate>Mon, 09 Jun 2025 13:51:58 +0800</pubDate><description><![CDATA[/ 故意改变Column2的值以制造差异。// 故意改变Column3的值以制造差异。dataset中数据忽略一列数据之后去重，并把去重复项之前的列一列数据进行合并。//通过groupby把需要重复的去掉，下面把重复项的某一列进行合并。// 假设我们想忽略Column2的差异。]]></description><category></category></item><item><title><![CDATA[winform下DevExpress中datagridview中数据批量保存不上]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/148432703</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/148432703</guid><author>sunping177</author><pubDate>Wed, 04 Jun 2025 18:52:01 +0800</pubDate><description><![CDATA[如上图，表中新增一个字段BILLS_ID，对应dataset中有值，但是保存的时候，其他值都可以保存上，唯独BILLS_ID不可以，找了很久没有找到原因。最后发现，是select的时候，为BILLS_ID赋空值  select ‘’ BILLS_ID from。应该改为 select BILLS_ID from。一个小失误，忙活好几个小时找原因。]]></description><category></category></item><item><title><![CDATA[C#Winform中DevExpress下的datagridview 特定列可编辑，其他列不可编辑]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/148432593</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/148432593</guid><author>sunping177</author><pubDate>Wed, 04 Jun 2025 18:42:44 +0800</pubDate><description><![CDATA[1.设置改gridview下optionsBehavior下的editable=ture；2.设置对应列下的allowedit=false。如上图，标红列可编辑，其他列皆不可编辑，]]></description><category></category></item><item><title><![CDATA[电脑打开多个微信]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/135908350</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/135908350</guid><author>sunping177</author><pubDate>Mon, 29 Jan 2024 11:27:59 +0800</pubDate><description><![CDATA[保存txt文件，把txt改为bat，双击bat文件，如上图，即可打开三个微信。2.新建一个txt文件，输入一下代码，输入几个start。1.找到微信位置复制。]]></description><category></category></item><item><title><![CDATA[自定义打印时，创建dataset保存多个入参]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/135123473</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/135123473</guid><author>sunping177</author><pubDate>Thu, 21 Dec 2023 09:50:11 +0800</pubDate><description><![CDATA[/声明一个dataset ds_show。// 为表ds_show 增加列。String printName = "结账";//为表ds_show赋值。//声明新的ds，把dt1和dt2都放入ds。//声明新的dt1和dt2。]]></description><category></category></item><item><title><![CDATA[日常随笔：winform中DevExpress控件一些属性]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/133639756</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/133639756</guid><author>sunping177</author><pubDate>Sat, 07 Oct 2023 15:03:52 +0800</pubDate><description><![CDATA[设置DevExpress控件遇到的属性设置问题]]></description><category></category></item><item><title><![CDATA[日常随手记]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/132970052</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/132970052</guid><author>sunping177</author><pubDate>Mon, 18 Sep 2023 11:24:47 +0800</pubDate><description><![CDATA[日常随手记]]></description><category></category></item><item><title><![CDATA[Dev控件 Gridcontrol，gridview 实现多选功能]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/132180500</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/132180500</guid><author>sunping177</author><pubDate>Wed, 09 Aug 2023 09:18:52 +0800</pubDate><description><![CDATA[Dev控件 Gridcontrol，gridview 实现多选功能]]></description><category></category></item><item><title><![CDATA[dev控件gridControl，gridview中添加合计]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/132066930</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/132066930</guid><author>sunping177</author><pubDate>Wed, 02 Aug 2023 17:21:40 +0800</pubDate><description><![CDATA[3.点击run designer，为要合计的项，设置SummaryItem下的summaryType选择sum，再把dispayFormat中的sum改为：合计即可。1.gridview属性中optionsView下，设置showFooter=ture；弹出的页面包括：结算日期，ID，姓名，费别，预交金收入，结算金额，收据号，合计（结算金额）2.GridControl中在show Footer前勾选，不然不显示合计。2.新页面：结算明细页中，添加绑定数据。1.双击合并结账查询，添加弹框。]]></description><category></category></item><item><title><![CDATA[DevExpress的GridView中的行（row）根据条件变色，选中不覆盖整行原本颜色]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/131201705</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/131201705</guid><author>sunping177</author><pubDate>Wed, 14 Jun 2023 10:13:13 +0800</pubDate><description><![CDATA[DevExpress的GridView中的行（row）根据条件变色，选中不覆盖整行原本颜色；Dev Gridview单元格背景颜色被选中行颜色覆盖的问题 Dev 如何让gridview选中行不变色]]></description><category></category></item><item><title><![CDATA[UDI-12541:操作产生了Oracle错误12541]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/130482778</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/130482778</guid><author>sunping177</author><pubDate>Thu, 04 May 2023 10:56:52 +0800</pubDate><description><![CDATA[3、修改成我的电脑主机名字，我的电脑-》属性：就可以看到。2、找到listener.ora。数据泵导入时，报如上图的错误。1、到 D:\app\。]]></description><category></category></item><item><title><![CDATA[impdp不是内部或外部命令]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/130482299</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/130482299</guid><author>sunping177</author><pubDate>Thu, 04 May 2023 10:52:25 +0800</pubDate><description><![CDATA[右击“我的电脑”—>“高级”—>“环境变量”—>“系统变量”—>path；oracle导入导出命令所在的目录"这样就好了；若添加了path还是不行，就可能是client安装的问题，安装时一定要选择“管理员”，而不要选择“运行时”。我的配置是这样的：D:\app\sp\product\11.2.0\dbhome_1\BIN;1、在windows环境变量下，配置path系统变量。oracle导入导出命令所在的目录:bin下面哦。]]></description><category></category></item><item><title><![CDATA[环境变量配置]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/128535026</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/128535026</guid><author>sunping177</author><pubDate>Tue, 03 Jan 2023 16:25:08 +0800</pubDate><description><![CDATA[java SE环境变量配置]]></description><category></category></item><item><title><![CDATA[oracle在本地创建数据库和导入DMP数据泵]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/128495849</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/128495849</guid><author>sunping177</author><pubDate>Fri, 30 Dec 2022 15:14:44 +0800</pubDate><description><![CDATA[oracle在本地创建数据库和导入DMP数据泵]]></description><category></category></item><item><title><![CDATA[Oracle查询日期格式的sql]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/115897400</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/115897400</guid><author>sunping177</author><pubDate>Tue, 20 Apr 2021 10:56:44 +0800</pubDate><description><![CDATA[查询带有日期格式的sql语句

select *
    from pat_visit t
   where to_char(t.ADMISSION_DATE_TIME,'yyyy-mm-dd')='2021-03-09'
]]></description><category></category></item><item><title><![CDATA[winform日期查询问题]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/79861372</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/79861372</guid><author>sunping177</author><pubDate>Mon, 09 Apr 2018 09:39:42 +0800</pubDate><description><![CDATA[在winform 中，查询当天数据有个简单易操作的方法1.添加winform控件，datetimePicker 属性无需设计，后台获取方式为：获取的时间格式为:2018-04-09 00:00:00  2018-04-10 00:00:00 ，查询当前日期 DateTime startDate = dtpStart.Value.Date;  DateTime endDate = dtpEnd.Va...]]></description><category></category></item><item><title><![CDATA[是否选择框使用方法，MessageBoxButtons]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/78839389</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/78839389</guid><author>sunping177</author><pubDate>Tue, 19 Dec 2017 09:52:55 +0800</pubDate><description><![CDATA[if (MessageBox.Show("修改供应商将清空已选其他供应商的入库明细，是否继续?", "提示信息", MessageBoxButtons.YesNo) == DialogResult.No)
                {
                    return;
                }]]></description><category></category></item><item><title><![CDATA[datagridview显示和保存下拉框中数据]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/78433598</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/78433598</guid><author>sunping177</author><pubDate>Fri, 03 Nov 2017 11:20:39 +0800</pubDate><description><![CDATA[原文请看：http://blog.youkuaiyun.com/sunping177/article/details/77572175 
这个是补充的，具体详情请看上面链接地址 
下拉框显示和保存时需要注意的一个地儿 
 
为数据下datapropertyName添加上后台数据库中的列，不然页面无法显示和保持数据]]></description><category></category></item><item><title><![CDATA[datagridview内容设置不可编辑]]></title><link>https://blog.youkuaiyun.com/sunping177/article/details/77833384</link><guid>https://blog.youkuaiyun.com/sunping177/article/details/77833384</guid><author>sunping177</author><pubDate>Mon, 04 Sep 2017 09:44:10 +0800</pubDate><description><![CDATA[在处理winform程序时，添加了增删改查等功能，仍然无法对datagridview内的数据进行编辑，查看代码没有问题，纠结了好一会儿，终于发现，哎。。。好吧 
取消红框中的相应的方框中的对勾，即可设置datagridview不可编辑，不可删除，不可添加等功能。反之为可编辑。]]></description><category></category></item></channel></rss>