<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[spr1ng的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/spr1ng</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; spr1ng]]></copyright><item><title><![CDATA[windows控件]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/119673171</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/119673171</guid><author>spr1ng</author><pubDate>Fri, 13 Aug 2021 12:52:12 +0800</pubDate><description><![CDATA[w
]]></description><category></category></item><item><title><![CDATA[数据库连接]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/119536846</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/119536846</guid><author>spr1ng</author><pubDate>Mon, 09 Aug 2021 14:11:52 +0800</pubDate><description><![CDATA[models

service 功能

views界面

models里表名就是类

下面是实体的写法









service里建DBHelper里写数据库的方法






]]></description><category></category></item><item><title><![CDATA[数据库访问通用类2]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/119415454</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/119415454</guid><author>spr1ng</author><pubDate>Thu, 05 Aug 2021 12:57:55 +0800</pubDate><description><![CDATA[一、把command的构件提出来

1、初始化工作



2、返回



3、调用











传sql文 事务修改

传命令事务修改，改动少，没啥必要








]]></description><category></category></item><item><title><![CDATA[封装数据通用访问类]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/119395972</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/119395972</guid><author>spr1ng</author><pubDate>Thu, 05 Aug 2021 00:15:13 +0800</pubDate><description><![CDATA[1、链接字符串



2、读取

读取前添加引用



新建类



读取链接字符串



建立链接对象


]]></description><category></category></item><item><title><![CDATA[程序中定义事务]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/119394968</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/119394968</guid><author>spr1ng</author><pubDate>Wed, 04 Aug 2021 23:48:05 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[数据库中定义事务]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/119382088</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/119382088</guid><author>spr1ng</author><pubDate>Wed, 04 Aug 2021 15:43:18 +0800</pubDate><description><![CDATA[实际工作中把事务放在存储过程中

事务里的varchar和nvarchar区别

存储过程的逻辑写在begin和end之间

下面就是带事务的存储过程的整体框架







代码调用存储过程带事务的


















...]]></description><category></category></item><item><title><![CDATA[c#数据适配器dataAdapter]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/119377407</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/119377407</guid><author>spr1ng</author><pubDate>Wed, 04 Aug 2021 10:59:59 +0800</pubDate><description><![CDATA[1、引用命名空间



2、数据库连接配置

3、读取配置文 件需要引用



4、两种实例化dataAdapter的方法



第三种实例dataAdapter的方法





第四种连接对象都不用构件了，也可以





dataAdapter填充数据

1、直接填充到结果集



2、查询两个结果集



​​​​​​​





注：设置表名映射在数据填充前。



填充数据到dataTable

如上的两种填充（到dataSet ,dataTable）都没有用到显示打开...]]></description><category></category></item><item><title><![CDATA[dataset]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/119347928</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/119347928</guid><author>spr1ng</author><pubDate>Tue, 03 Aug 2021 15:39:46 +0800</pubDate><description><![CDATA[创建dataSet如下两种方法







关系，一对一，一对多，多对多，中间表建立，权限 分配 。

如下一对多为例子，员工表和部门表







外键



上面如果new DataRelation里的第三个参数为false，那么就无法自己建立唯一和外键约束，需要手机写add。

表里信息





建立关系



使用关系，遍例数据





上面，遍历的dt2打印的dt1








...]]></description><category></category></item><item><title><![CDATA[c#datetable属性方法]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/119344876</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/119344876</guid><author>spr1ng</author><pubDate>Tue, 03 Aug 2021 10:44:07 +0800</pubDate><description><![CDATA[新建空的dataTable



创建DataTable步骤



创建 dateTable代码



创建好DataRow后，要把datarow放到datatable里



dataRowState属性



状态切换顺序







回滚

清空数据 复制架构数据，只复制架构










...]]></description><category></category></item><item><title><![CDATA[c#访问数据库]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/119170505</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/119170505</guid><author>spr1ng</author><pubDate>Wed, 28 Jul 2021 22:35:06 +0800</pubDate><description><![CDATA[sqlconnection用来连接sqlserver的





连接字符串的字符串的构建







配置文件中存储数据库连接

应用程序的配置文件

默认



选引用
















]]></description><category></category></item><item><title><![CDATA[c#arraylist list dictionary]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/119054678</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/119054678</guid><author>spr1ng</author><pubDate>Sat, 24 Jul 2021 10:51:13 +0800</pubDate><description><![CDATA[c#array list的简单用法


]]></description><category></category></item><item><title><![CDATA[js或php压缩图片]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/78318239</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/78318239</guid><author>spr1ng</author><pubDate>Mon, 23 Oct 2017 14:07:04 +0800</pubDate><description><![CDATA[图片压缩可以放在前端也可以放在后端
本人前端用js后端用php
js端主要是通过canvas和FileReader，如下地toDataURL二个参数就是设置图片的品质

canvas.toDataURL(type, encoderOptions);




type："image/jpeg"，"image/png"
encoderOptions: 0.0-1.0
php

]]></description><category></category></item><item><title><![CDATA[flex第一步]]></title><link>https://blog.youkuaiyun.com/spr1ng/article/details/4097197</link><guid>https://blog.youkuaiyun.com/spr1ng/article/details/4097197</guid><author>spr1ng</author><pubDate>Tue, 21 Apr 2009 13:06:00 +0800</pubDate><description><![CDATA[flex现在是ria界的热门，那么我们如何学好他呢. 下面就从基础说说。首先们要掌握as3语言。as3语言和javascript差不多都是基于ECMScript标准的。说白了也是一个脚本语言]]></description><category></category></item></channel></rss>