<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ASDTP的博客]]></title><description><![CDATA[当你凝视深渊的时候，深渊也在凝视你。]]></description><link>https://blog.youkuaiyun.com/ASDTP</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ASDTP]]></copyright><item><title><![CDATA[MS SQLSERVER模糊查询like笔记]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/81135306</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/81135306</guid><author>ASDTP</author><pubDate>Fri, 20 Jul 2018 16:55:53 +0800</pubDate><description><![CDATA[1.以什么开头,查找姓名以张开头的数据
select * from userinfo where name like '张%'    最快

2.以什么结尾，查找姓名以宇结尾的
select * from userinfo where name like '%宇'

3.包含什么字符，查找姓名包含明
select * from userinfo where name like '%明%'    最...]]></description><category></category></item><item><title><![CDATA[winformNPOI导入导出]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80932669</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80932669</guid><author>ASDTP</author><pubDate>Thu, 05 Jul 2018 20:27:16 +0800</pubDate><description><![CDATA[        public Form1()
        {
            InitializeComponent();
        }
        private ManagerInfoBll miBll = new ManagerInfoBll();
        private void Form1_Load(object sender, EventArgs e)
 ...]]></description><category></category></item><item><title><![CDATA[MVC上传文件]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80831320</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80831320</guid><author>ASDTP</author><pubDate>Wed, 27 Jun 2018 16:35:33 +0800</pubDate><description><![CDATA[HTML代码            &amp;lt;form method=&quot;post&quot; action=&quot;~/Test/BaoMing&quot; enctype=&quot;multipart/form-data&quot;&amp;gt;
            &amp;lt;table&amp;gt;
                &amp;lt;tr&amp;gt;&amp;lt;td&amp;gt;附件：&amp;lt;/td&amp;gt;&amp;lt;td&]]></description><category></category></item><item><title><![CDATA[AJAX入门]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80705225</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80705225</guid><author>ASDTP</author><pubDate>Fri, 15 Jun 2018 14:43:38 +0800</pubDate><description><![CDATA[通过ajax不刷新页面计算2个数的和（异步请求）    &amp;lt;script type=&quot;text/javascript&quot; src=&quot;js/jquery-1.10.2.js&quot;&amp;gt;&amp;lt;/script&amp;gt;    &amp;lt;script type=&quot;text/javascript&quot;&amp;gt;        $(function () {            $(&quot;#btnResult&q]]></description><category></category></item><item><title><![CDATA[复制表结构]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80700833</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80700833</guid><author>ASDTP</author><pubDate>Fri, 15 Jun 2018 09:20:37 +0800</pubDate><description><![CDATA[创建一张新的表，字段全是另一张表创建一个和t_users表结构一模一样的表,新的表名是userinfoselect top 0 * into userinfo from T_Usersselect * from userinfo]]></description><category></category></item><item><title><![CDATA[SQL SERVER使用存储实现增删改查]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80697656</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80697656</guid><author>ASDTP</author><pubDate>Thu, 14 Jun 2018 20:02:40 +0800</pubDate><description><![CDATA[--使用存储过程实现增删改查--增加create proc usp_UserAdd@uname nvarchar(20),@upass nvarchar(20),@age intasbegin	insert into T_Users(UserName,PassWord,Age) values(@uname,@upass,@age)endexec usp_UserAdd @uname=王八犊子,@u...]]></description><category></category></item><item><title><![CDATA[SQL SERVER分页存储过程]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80694051</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80694051</guid><author>ASDTP</author><pubDate>Thu, 14 Jun 2018 16:04:44 +0800</pubDate><description><![CDATA[----使用存储过程写一个分页查询select * from T_Usersgocreate proc usp_getDataFY@pagesize int =10,	--每页记录条数                    --定义变量并赋初始值@pageindex int =1,  --当前要查看第几页的记录--@sumCount int output,	--总的记录条数            ...]]></description><category></category></item><item><title><![CDATA[WebStorm浏览网页找不到chrome的解决方法]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80684194</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80684194</guid><author>ASDTP</author><pubDate>Wed, 13 Jun 2018 19:44:10 +0800</pubDate><description><![CDATA[1、在webstrom中点击file下的settings-tools设置好之后，重新打开就可以了]]></description><category></category></item><item><title><![CDATA[SQLSERVER智能提示，不显示的问题。]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80682379</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80682379</guid><author>ASDTP</author><pubDate>Wed, 13 Jun 2018 17:14:23 +0800</pubDate><description><![CDATA[在SQLSERVER中新建好了一张user表，在新建查询中进行select  * from user查询的时候发现编辑器提示对象不存在这个情况的解决方法是：Ctrl+Shift+r就解决了。]]></description><category></category></item><item><title><![CDATA[.Net三层中BLL的作用]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80646223</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80646223</guid><author>ASDTP</author><pubDate>Sun, 10 Jun 2018 23:29:20 +0800</pubDate><description><![CDATA[1、BLL层在大多数使用过程中完全就是直接调用DAL层的方法，那BLL有什么用呢？他不是逻辑控制层吗？看上他的Add2方法是一个添加用户的方法，在BLL层中如何实现逻辑控制呢？在添加用户的时候我们需要判断该用户是否存在，如果存在就返回一个false，表示添加失败。这个时候BLL就展现出来逻辑控制的用途了，先判断一下用户，不存在在进行用户添加。...]]></description><category></category></item><item><title><![CDATA[自己写SqlHelper]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80645351</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80645351</guid><author>ASDTP</author><pubDate>Sun, 10 Jun 2018 21:54:49 +0800</pubDate><description><![CDATA[    public static class SqlHelper    {        public readonly static string connStr = ConfigurationManager.ConnectionStrings[&quot;connStr&quot;].ConnectionString;        /// &amp;lt;summary&amp;gt;        /// 执行增删改的方法...]]></description><category></category></item><item><title><![CDATA[自己写代码生成器]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80642714</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80642714</guid><author>ASDTP</author><pubDate>Sun, 10 Jun 2018 17:24:22 +0800</pubDate><description><![CDATA[1、先看界面效果根据默认的连接字符串查询出系统有多少表，在下拉框中加载出来，然后点击生成代码，生成数据模型类2、后端代码实现        private void button1_Click(object sender, EventArgs e)        {            comTable.Items.Clear();            DataTable table = Ge...]]></description><category></category></item><item><title><![CDATA[关于IsPostBack的理解]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80642273</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80642273</guid><author>ASDTP</author><pubDate>Sun, 10 Jun 2018 16:36:29 +0800</pubDate><description><![CDATA[引用:liuweilong120 的博客你第一次打开一个aspx页面，就是首次加载，然后你点击了页面中的某个按钮，或者其他控件，这个动作如果引起了页面的刷新，就是PostBack了，IsPostBack是个逻辑值，用于判断该次页面的刷新（加载）是客户端首次加载页面，还是客户端做出了什么请求的动作，为了响应此动作而再次加载页面。  一般都在页面首次加载时完成一些控件的初始化，数据的绑定之类的，这些事...]]></description><category></category></item><item><title><![CDATA[WebForm语法介绍]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80630358</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80630358</guid><author>ASDTP</author><pubDate>Sat, 09 Jun 2018 23:38:57 +0800</pubDate><description><![CDATA[1、在后端声明一个变量，在页面上输出直接输出这个变量的值效果2、在页面中使用C#代码进行输出            &amp;lt;ul&amp;gt;                &amp;lt;%for (int i = 0; i &amp;lt; 10; i++){%&amp;gt;                &amp;lt;li&amp;gt;&amp;lt;%=i %&amp;gt;&amp;lt;/li&amp;gt;                 &amp;lt;% }...]]></description><category></category></item><item><title><![CDATA[WebForm窗体文件之间的关系]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80630703</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80630703</guid><author>ASDTP</author><pubDate>Sat, 09 Jun 2018 11:34:31 +0800</pubDate><description><![CDATA[1、打开一个我们建好的web窗体找到物理文件他们三者之间的关系是？通过记事本打开aspx.cs和designer.cs发现他们都是由partial修饰partial是部分类的意思解释：在一个命名空间下定义2个Person类，编译的时候报错注意同一目录下的类名不能重复，加上partial修饰后。就编译成功了通过反编译证明这2个文件其实就是一个文件总结：在编译的时候，把2个文件合并成一个文件了，这就是...]]></description><category></category></item><item><title><![CDATA[GridView72般绝技——数据分页]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80630081</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80630081</guid><author>ASDTP</author><pubDate>Sat, 09 Jun 2018 09:17:07 +0800</pubDate><description><![CDATA[2.GridView分页1.开启GridView允许分页2.每页显示多少行数据3.当前GridView索引更改事件页面代码        &amp;lt;asp:GridView ID=&quot;GridView1&quot; runat=&quot;server&quot; BackColor=&quot;White&quot; BorderColor=&quot;#CCCCCC&quot; BorderStyle=&quot;None&quot; BorderWidth=&quot;1px&quot;]]></description><category></category></item><item><title><![CDATA[使用ADO.NET高速向SqlServer中插入数据]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80629567</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80629567</guid><author>ASDTP</author><pubDate>Sat, 09 Jun 2018 01:00:08 +0800</pubDate><description><![CDATA[            bool b = false;            Console.WriteLine(Convert.ToInt32(b));测试得知，C#中bool类型true是1，falses是0。而SQLSERVER数据库中，bit类型true是1,false是0//往数据库写入bit值，不支持0/1，只支持true/false往数据库写入bit值，不支持0/1，只支持true/...]]></description><category></category></item><item><title><![CDATA[GridView72般绝技——数据显示]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80629188</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80629188</guid><author>ASDTP</author><pubDate>Fri, 08 Jun 2018 23:41:00 +0800</pubDate><description><![CDATA[1、基本的数据绑定1.在页面中拖一个GridView控件2.在页面加载的时候显示数据        protected void Page_Load(object sender, EventArgs e)        {            SqlHelper s = new SqlHelper();    //由于SqlHelper不是静态类            DataTable dt ...]]></description><category></category></item><item><title><![CDATA[WebForm基础]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80628608</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80628608</guid><author>ASDTP</author><pubDate>Fri, 08 Jun 2018 22:25:47 +0800</pubDate><description><![CDATA[1、WebForm的优点和缺点在一个空的web项目中添加一web窗体，他的用法和winform差不多。都是拖控件下面用一个求和的例子演示1.1先在页面上拖2个文本框一个按钮点击按钮实现求和代码        protected void Button1_Click(object sender, EventArgs e)        {            int i = Convert.ToI...]]></description><category></category></item><item><title><![CDATA[获取本机IP地址]]></title><link>https://blog.youkuaiyun.com/ASDTP/article/details/80627906</link><guid>https://blog.youkuaiyun.com/ASDTP/article/details/80627906</guid><author>ASDTP</author><pubDate>Fri, 08 Jun 2018 20:55:54 +0800</pubDate><description><![CDATA[1.获取本机ipv4地址，使用控制台程序进行测试            IPHostEntry ipHost = Dns.GetHostByName(host);            string ipv4 = ipHost.AddressList[0].ToString();            Console.WriteLine(ipv4);效果2.获取所有IP地址            ...]]></description><category></category></item></channel></rss>