https://blog.youkuaiyun.com/gdsimonzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/gdsimon/article/details/6416669https://blog.youkuaiyun.com/gdsimon/article/details/6416669gdsimonFri, 13 May 2011 10:29:00 +0800最近想在一个Excel表中抽出公式来,Google后按别人用过的方法却怎么也不能成功:
   =MID(GET.CELL(41,A12),2,100) ----提示不能识别的公式(A12就是公式所在的单元格)
后来再查了一下才知道那个需要先定义一个名称,然后才可以调用此公式
插入->名称->定义名称  定义一个名称比如myTest,然后在引用位置上填上:=MID(GET.CELL(41,A12),2,100),按确定记录
 
在任一单元格上填上:]]>https://blog.youkuaiyun.com/gdsimon/article/details/6291469https://blog.youkuaiyun.com/gdsimon/article/details/6291469gdsimonThu, 31 Mar 2011 13:38:00 +0800可以使用三目运算,如:
]]>https://blog.youkuaiyun.com/gdsimon/article/details/6289205https://blog.youkuaiyun.com/gdsimon/article/details/6289205gdsimonWed, 30 Mar 2011 16:25:00 +0800CREATE TABLE [dbo].[Order](
[o_id] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[o_buyerid] [int] NOT NULL
)
1.OUPUT参数返回值
例： 向Order表插入一条记录,返回其标识
https://blog.youkuaiyun.com/gdsimon/article/details/6280989https://blog.youkuaiyun.com/gdsimon/article/details/6280989gdsimonSun, 27 Mar 2011 04:08:00 +0800在Iframe打开的页面中使用windows.parent.XXX就可以了！
例如要关闭父页：

    window.parent.opener=null;
    window.parent.open("", "_self");
    window.parent.close();]]>https://blog.youkuaiyun.com/gdsimon/article/details/6277718https://blog.youkuaiyun.com/gdsimon/article/details/6277718gdsimonFri, 25 Mar 2011 14:17:00 +0800https://blog.youkuaiyun.com/gdsimon/article/details/6269478https://blog.youkuaiyun.com/gdsimon/article/details/6269478gdsimonTue, 22 Mar 2011 23:09:00 +0800https://blog.youkuaiyun.com/gdsimon/article/details/6186521https://blog.youkuaiyun.com/gdsimon/article/details/6186521gdsimonTue, 15 Feb 2011 17:46:00 +0800https://blog.youkuaiyun.com/gdsimon/article/details/6168647https://blog.youkuaiyun.com/gdsimon/article/details/6168647gdsimonSat, 29 Jan 2011 11:17:00 +0800https://blog.youkuaiyun.com/gdsimon/article/details/6162938https://blog.youkuaiyun.com/gdsimon/article/details/6162938gdsimonTue, 25 Jan 2011 14:12:00 +0800 

create table #temp (employeeName nchar(10),payCategory nchar(12),amount numeric(10,2))
insert into #temp (employeeName,payCategory,amount) values ('王五','吃饭',10.2)
insert into #temp (employeeName,payCategory,amount) values ('王五']]>https://blog.youkuaiyun.com/gdsimon/article/details/6154720https://blog.youkuaiyun.com/gdsimon/article/details/6154720gdsimonThu, 20 Jan 2011 13:44:00 +0800来源:网络 作者:未知网上也有不少使用div + css进行布局的教程，却存在很多缺陷，一是对css的布局模型讲解不清楚，让人很难理解相对定位、浮动等概念；二是虽然避免了“表格套表格”的缺点，却带来了“div 套 div”的缺点，过量使用div标签；三是class网上也有不少使用div + css进行布局的教程，却存在很多缺陷，一是对css的布局模型讲解不清楚，让人很难理解相对定位、浮动等概念；二是虽然避免了“表格套表格”的缺点，却带来了“div 套 div”的缺点，过量使用div标签；三是cl]]>https://blog.youkuaiyun.com/gdsimon/article/details/6121424https://blog.youkuaiyun.com/gdsimon/article/details/6121424gdsimonThu, 06 Jan 2011 22:56:00 +0800https://blog.youkuaiyun.com/gdsimon/article/details/6120608https://blog.youkuaiyun.com/gdsimon/article/details/6120608gdsimonThu, 06 Jan 2011 16:09:00 +0800新建了个WEB应用程序,想新建一些类文件,但发觉App_Code目录没有了,于是就新增一个,增加后一看图标正常后就往里面新加类,但写好后运无法智能感知,编译时更加提示说找不到该类,于是上网Google之!
 
在Web应用程序中不能通过右键项目-〉”添加“-〉”添加ASP.NET文件夹“方式添加 。因为Web应用程序中App_Code就不存在 。
不过可以通过手动的方式创建，添加一个文件夹命名为App_Code就可以了。这样子创建的和在网站中创建的App_Code的]]>https://blog.youkuaiyun.com/gdsimon/article/details/5986739https://blog.youkuaiyun.com/gdsimon/article/details/5986739gdsimonThu, 04 Nov 2010 11:01:00 +08001、在之间插入一个Button,设置CommandName及CommandArgument属性.
如:

https://blog.youkuaiyun.com/gdsimon/article/details/4399351https://blog.youkuaiyun.com/gdsimon/article/details/4399351gdsimonSat, 01 Aug 2009 11:07:00 +0800https://blog.youkuaiyun.com/gdsimon/article/details/3608237https://blog.youkuaiyun.com/gdsimon/article/details/3608237gdsimonFri, 26 Dec 2008 00:19:00 +0800