Browse by Tags

关于SQL2005使用OpenRowSet的一些设置（从Excel 导入数据到Sqlserver)

今天收到任务，需要导用户数据到Sqlserver 2005上面去。就想起之前有过直接写sql语句的做法，在网上没有怎么搜就基本有 select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0' ,'Excel 5.0;HDR=YES;IMEX=2;DATABASE=D:\22.75D\dudu\flexihr\用户测试数据\xxx\QualificationMF.xls',[Qualification$]) 直接copy到数据库command window运行就报告 Msg 7399, Level 16, State 1,...

Posted to jawance (Weblog) by jawance on 07-07-2009
不同字符集合update出现Cannot resolve the collation conflict between

完整的错误信息: Cannot resolve the collation conflict between "Chinese_Taiwan_Stroke_CI_AS" and "Chinese_PRC_CI_AS" in the equal to operation. 解决的办法是字段后加上 collate xx_字符_类型. for example. update [OIL500]..scU set passwd = b.passwd from [asana]..scU as b where [OIL500]..sc_user.loginname =...

Posted to jawance (Weblog) by jawance on 06-10-2009
用户密码强度检测控件放送

近日写的用户密码强度检测控件其中有两个地方值得共享给大家看看，当然啦本人是觉得这两个有好的地方才分享的啦。先来个界面看看先。这里界定了 4 个 Level , NotUse: "NotUse" – 不能使用 , Weak: "Weak" — 弱 , Average: "Average" — 一般 , Strong: "Strong" — 强 , VeryStrong: "Very Strong" — 非常强 1. 控件的使用方法 <% @ Register Src ="~...

Posted to jawance (Weblog) by jawance on 06-05-2009
IE 浏览器一般使用的字体还有简繁体用的字体参考

1 ． English : ( 以下是一般 IE 浏览器具有的字体 ) StaffID Employment--- 〉标准 11 StaffID Employment--- 〉 time new romar 11 StaffID Employment - à ms pMlingLiu 11 StaffID Employment - à Courier New 11 StaffID Employment à 宋体 11 StaffID Employment à Arial 11 StaffID Employment à Candara 11 2 ．中文： ( 只有以下几种字体 for 简体 /...

Posted to jawance (Weblog) by jawance on 06-05-2009
Web Html 模拟window应用程序显示不规则提示文本框

Web Html 模拟 window 应用程序显示不规则提示文本框， ( 如何模拟箭头标示信息 (tooltips 图形显示信息 )) 一：引言一般 html 页面对表现图形的能力比不上 window application 的，如果能在 web application 上表现出这样的效果真的是太好了。上图就是一个 web application 里面的对于某些需要提醒用户录入的地方进行了 tooltip 信息显示。二：模拟方法（ 1 ）使用 Map Html 元素进行描点（这个请参考相关的文章，这个最传统）（ 2 ）使用 div 描线画图（这个觉得挺特别我就介绍这个）（ 3...

Posted to jawance (Weblog) by jawance on 06-01-2009
ASP.NET Cookies Overview( Cookies 使用要点)

1。不改变subkey最多的能保存的Cookies 数目：20 Browsers also impose limitations on how many cookies your site can store on the user's computer. Most browsers allow only 20 cookies per site; if you try to store more, the oldest cookies are discarded. Some browsers also put an absolute limit, usually 300, on the...

Posted to jawance (Weblog) by jawance on 04-25-2009
WPF UI Automation

This article demonstrates how to create a simple Windows UI Automation application

Posted to Aggregated Feeds (Weblog) by Anonymous on 02-05-2009
Functional Programming in C# 3.0 using Lambda Expression - Part 1

This article explains how to use C# 3.0 lambda expression for functional programming.

Posted to Aggregated Feeds (Weblog) by Anonymous on 02-05-2009
Progress Indication while Uploading/Downloading Files using WCF

This article examines the implementation of upload and download functionality with progress indication (progress bar feature) using Windows Communication Foundation.

Posted to Aggregated Feeds (Weblog) by Anonymous on 02-04-2009
How to use a custom expression builder to provide declarative, strongly-typed references to types and members

This article provides an example of how to implement and use a custom expression builder to extend compile-time support in your ASP.NET pages.

Posted to Aggregated Feeds (Weblog) by Anonymous on 02-04-2009

Page 1 of 144 (1440 items) 1 2 3 4 5 Next > ... Last »