josephshi - 博客园

2008年4月2日

Find out all the Primary Key and Foreign Key Constraints in a table

摘要： Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->SELECT Table_Name as [Table], Column_Name as [Column], Constraint_Name as [Constraint], Table_Sch... 阅读全文

posted @ 2008-04-02 13:11 josephshi 阅读(209) 评论(0) 推荐(0) 编辑

Read and Write compressed data to a binary file using ASP.NET

摘要： Read and Write compressed data to a binary file using ASP.NET The BinaryReader and BinaryWriter in System.IO namespace read and write primitive types in binary, to a stream. The System.IO.Compressio... 阅读全文

posted @ 2008-04-02 13:06 josephshi 阅读(901) 评论(0) 推荐(0) 编辑

[转载]Generate dynamic SQL statements in SQL Server

摘要： When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool — although you must be careful when using it. This article explores how you can use this fun... 阅读全文

posted @ 2008-04-02 10:44 josephshi 阅读(331) 评论(0) 推荐(0) 编辑

[转载]SQL Server: Design for security from the start

摘要： site:http://articles.techrepublic.com.com/5100-22_11-5035150.html?tag=rbxccnbtr1 Takeaway: Security in the development of a SQL Server database must be a priority right from the start, beginning with ... 阅读全文

posted @ 2008-04-02 10:40 josephshi 阅读(205) 评论(0) 推荐(0) 编辑

2008年3月17日

Integrated Security

摘要： Microsoft安全支持提供器接口（SSPI）是定义得较全面的公用API，用来获得验证、信息完整性、信息隐私等集成安全服务，以及用于所有分布式应用程序协议的安全方面的服务。应用程序协议设计者能够利用该接口获得不同的安全性服务而不必修改协议本身。上面这句话的意思就是这个连接采用了这个接口，如果没有定义就会出错！ ============== Integrated Security 身份验证方... 阅读全文

posted @ 2008-03-17 12:28 josephshi 阅读(255) 评论(0) 推荐(0) 编辑

2008年2月27日

Web Crawler, spider, ant, bot... how to make one?

摘要： Introduction A web crawler is a program that browses the World Wide Web in a methodical and automated manner. It also known as web spider, web robot, ant, bot, worm, and automated indexer. Famous exam... 阅读全文

posted @ 2008-02-27 13:43 josephshi 阅读(461) 评论(0) 推荐(0) 编辑

Using Excel Sheets as a Database Backend

摘要： Why use Excel as a Database? Most developers know how to use back ends like Microsoft SQL server, Oracle, Microsoft Access or IBM DB2 as database back ends for their applications. Microsoft Excel in t... 阅读全文

posted @ 2008-02-27 13:40 josephshi 阅读(517) 评论(0) 推荐(0) 编辑

2008年1月30日

nice site

摘要： http://www.multicians.org/thvv/proverbs.html 阅读全文

posted @ 2008-01-30 09:58 josephshi 阅读(218) 评论(0) 推荐(0) 编辑

2008年1月25日

Understanding Interfaces in C#

摘要： Understanding Interfaces in C# Abstract ... 阅读全文

posted @ 2008-01-25 12:43 josephshi 阅读(104) 评论(0) 推荐(0) 编辑

2008年1月15日

CodeSnip: How to Get Id of the Record Using ASP.NET and SQL Server 2000

摘要： Listing 1 – Simple WebForm used for the Test First Name Last Name We will create a database named DummyDB and a table with the n... 阅读全文

posted @ 2008-01-15 16:52 josephshi 阅读(402) 评论(0) 推荐(0) 编辑

Speed testing in .NET - System.Diagnostics.Stopwatch

摘要： System.Diagnostics.Stopwatch is a replacement for what most people probably do to identify the time spent on excecuting a method. The process usually goes something like: create a DateTime.Now value a... 阅读全文

posted @ 2008-01-15 16:37 josephshi 阅读(233) 评论(0) 推荐(0) 编辑

How to debug a JavaScript code

摘要： Method 1. Open .js file in Visual Studio and insert breakpoint at the line you want to debug. Open Attach to Process dialog window (menu item Debug | Attach to Process...) and attach to Internet Explo... 阅读全文

posted @ 2008-01-15 16:27 josephshi 阅读(231) 评论(0) 推荐(0) 编辑

Do not include the "@" character when supplying stored procedure parameter names to a SQL Server database

摘要： Avoid using database-specific tokens with stored procedure parameter names. ADO.NET classes for specific providers include code to adjust parameter names as required. This will ease migration existi... 阅读全文

posted @ 2008-01-15 16:26 josephshi 阅读(206) 评论(0) 推荐(0) 编辑

Keep the number of files in your /app_code directory small

摘要： In order to improve Web Site Project build times keep number of files in your /app_code directory small. If you end up having a lot of class files within this directory, move them into separate class ... 阅读全文

posted @ 2008-01-15 16:20 josephshi 阅读(292) 评论(0) 推荐(0) 编辑

Use on-demand web-site compilation option to improve build times,按照不同的要求提高编译速度

摘要： On-demand web-site compilation mode means that when you edit page and then hit F5 (run with debugging) or Ctrl-F5 (run without debugging) the solution will compile all of the class library projects, t... 阅读全文

posted @ 2008-01-15 16:14 josephshi 阅读(243) 评论(0) 推荐(0) 编辑

Use parameters instead of string concatenation for forming SQL queries,用参数方式来生成sql语句,而不是用连接字符串的方式

摘要： String concatenation is not a secure approach as clever person can execute unwanted SQL statement by some tricks (SQL injection attack). Use parameters if possible. Bad code: SqlCommand command =... 阅读全文

posted @ 2008-01-15 16:10 josephshi 阅读(258) 评论(0) 推荐(0) 编辑

How to get virtual path of web application

摘要： Getting the virtual paths local to server is pretty straight forward most of the time; just use Page.ResolveURL("~/whatever"). But what if you're in the BLL part of your app? Seeing as the Page.Resolv... 阅读全文

posted @ 2008-01-15 15:59 josephshi 阅读(268) 评论(0) 推荐(0) 编辑

Speed up string comparison,加快比较字符串

摘要： The Compare method compares strings in a local-aware fashion, so it has to convert the Unicode code of each character into a numeric value that reflects its position in the current culture's alphabet.... 阅读全文

posted @ 2008-01-15 15:52 josephshi 阅读(295) 评论(0) 推荐(0) 编辑

Conditional breakpoints in Visual Studio,VS中有条件的断点

摘要： You can specify a breakpoint condition which will be evaluated when a breakpoint is reached. The debugger will break only if the condition is satisfied. To specify a condition: In a source window... 阅读全文

posted @ 2008-01-15 15:48 josephshi 阅读(624) 评论(0) 推荐(0) 编辑

Use Tab twice to get the code snippets that are available within code editor

摘要： Take for example of foreach loop, just press 2 tabs after typing "fore"... that's it you got the code snippet as mentioned below: Other useful code snippets are: for - for loop while - for ... 阅读全文

posted @ 2008-01-15 15:44 josephshi 阅读(160) 评论(0) 推荐(0) 编辑