摘要：
Check/Uncheck all items in a CheckBoxList using ASP.NET and Javascript The CheckBoxList control in ASP.NET 2.0 provides a group of checkboxes that can be dynamically generated by binding it to a dat...
阅读全文
posted @ 2008-04-02 15:50
josephshi
阅读(869)
推荐(0)
编辑
摘要：
Reset values of all controls using ASP.NET 2.0 and JavaScript A very common requirement that comes up when building a form with lot of fields is resetting the controls back to their original state. ...
阅读全文
posted @ 2008-04-02 15:39
josephshi
阅读(502)
推荐(0)
编辑
摘要：
How to Print in ASP.NET 2.0 One of the most common functionality in any ASP.NET application is to print forms and controls. There are a lot of options to print forms using client scripts. In the art...
阅读全文
posted @ 2008-04-02 15:35
josephshi
阅读(380)
推荐(0)
编辑
摘要：
Error Logging using ASP.NET 2.0 Errors and failures may occur during development and operation of a website. ASP.NET 2.0 provides tracing, instrumentation and error handling mechanisms to detect and...
阅读全文
posted @ 2008-04-02 15:25
josephshi
阅读(278)
推荐(0)
编辑
摘要：
How to open popup windows in IE/Firefox and return values using ASP.NET and Javascript With the forums flooded with questions of opening a popup window, passing values to the popup window and then r...
阅读全文
posted @ 2008-04-02 15:19
josephshi
阅读(2119)
推荐(1)
编辑
摘要：
In this article, we will explore some of the most frequently asked questions about the GridView control. The article discusses ten tips and tricks that you can use while using the GridView control. Ti...
阅读全文
posted @ 2008-04-02 15:06
josephshi
阅读(622)
推荐(0)
编辑
摘要：
ASP.NETvalidation controls provide an easy-to-use but powerful mechanism ofensuring that data is entered correctly on the forms. There are 6validation controls included in the ASP.NET 2.0 and ASP.NET ...
阅读全文
posted @ 2008-04-02 14:57
josephshi
阅读(650)
推荐(0)
编辑
摘要：
Selectinga row in the GridView causes a postback. In order to highlight a row inthe GridView, you have to set the ‘SelectedRowStyle’ property whichtakes effect when the postback occurs. In...
阅读全文
posted @ 2008-04-02 14:46
josephshi
阅读(604)
推荐(0)
编辑
摘要：
The 'WAITFOR' command is used to delay the execution of a batch, stored procedure or transaction till a specified time duration or till an actual time. Let me demonstrate this: Create a DELAY for a s...
阅读全文
posted @ 2008-04-02 14:35
josephshi
阅读(225)
推荐(0)
编辑
摘要：
At times, in our stored procedures or sql queries, we need to check if the date specified in the variables is a valid date. Use the ISDATE() function. The ISDATE() function determines whether the ...
阅读全文
posted @ 2008-04-02 14:32
josephshi
阅读(271)
推荐(0)
编辑
摘要：
sp_spaceused returns number of rows, disk space reserved, and disk space used by a table. However when you have to return the space used by all the tables in a database, you have two options: One is ...
阅读全文
posted @ 2008-04-02 14:19
josephshi
阅读(284)
推荐(0)
编辑
摘要：
When columns have the identity property set on them, the value automatically increases on every row, depending on the seed and incrementing value. So let us create a table with an identity column ...
阅读全文
posted @ 2008-04-02 14:12
josephshi
阅读(883)
推荐(0)
编辑
摘要：
The 'tablediff' utility is a new feature in SQL Server 2005 used to compare differences of schema and data between source and destination table or view. This utility is particularly useful while r...
阅读全文
posted @ 2008-04-02 14:09
josephshi
阅读(312)
推荐(0)
编辑
摘要：
@@VERSION returns information about the version, processor, build date, copyright info and the operating system of the current SQL Server installation SELECT @@VERSION as VERSION returns 'Microso...
阅读全文
posted @ 2008-04-02 14:08
josephshi
阅读(251)
推荐(0)
编辑
摘要：
It is quiet easy to determine the current week in a year as shown below : SELECT DATEPART( wk, GETDATE()) However, to determine the current week in a month, use this query written by AMB Code hig...
阅读全文
posted @ 2008-04-02 13:58
josephshi
阅读(234)
推荐(0)
编辑
摘要：
Ever needed to save the result of your SELECT query to a text file. Well use xp_cmdshell. xp_cmdshell is an extended stored procedure kept in the master database. It issues OS commands directly to...
阅读全文
posted @ 2008-04-02 13:54
josephshi
阅读(315)
推荐(0)
编辑
摘要：
The Object_ID() function in SQL Server can be utilised in a number of ways. One such utility is to verify if an object exists. The Object_ID() takes in the object name and object type as paramete...
阅读全文
posted @ 2008-04-02 13:42
josephshi
阅读(939)
推荐(0)
编辑
摘要：
By default, you get both the date and time value whenever you retrieve a datetime value from the database. So something like : SELECT GETDATE() returns 2007-12-17 21:17:33.933 Let us quickly see ho...
阅读全文
posted @ 2008-04-02 13:17
josephshi
阅读(223)
推荐(0)
编辑
摘要：
We often find ourselves in the need of generating unique numbers in our database applications. Let us quickly take a tour of how to do that using Sql server 2005. SQL Server contains the NEWID() fun...
阅读全文
posted @ 2008-04-02 13:15
josephshi
阅读(262)
推荐(0)
编辑
