摘要:
I Have a table with 60 rows data, But now I just want to get ten rows starting from the twentieth row, for example: give me records between 21 and 30. Is there a way can do it? yes, here is the co... 阅读全文
摘要:
Update (3 August 2004, 10:20) A simple but effective approach supplied by mike , check it out . Many of the bugs reported against ASP.NET applications have to do with unexpected user input. One common... 阅读全文
摘要:
I have a following Question to ask all of you: Suppose you have a table named tblRoles with column named "RoleName". Now, construct a query that will select all the role names into a single var... 阅读全文
摘要:
In general, SQL Cursors are very useful and powerful because they offer a high degree of row-level data manipulation, but this power comes at a price: negative performance. So sometimes we need to... 阅读全文
摘要:
Sometimes we need to persist the scroll position of a page after a post back and not reset to the top, In ASP.NET 2.0, you can use the SmartNavigation feature. However, setting SmartNavigation to ... 阅读全文
摘要:
Attributes are classes that allow you to add additional information to elements of your class structure(types, methods, properties, and so forth).This sample demonstrates the creation and use of c... 阅读全文
摘要:
I encountered a problem when coding where I wanted to convert a string to an enum last night, First, I generated a long list of switch and case statements to handle this problem. But it is very aw... 阅读全文
摘要:
1. What's the advantage of using System.Text.StringBuilder over System.String? StringBuilder is more efficient in the cases, where a lot of manipulation is done to the text. Strings are immutable,... 阅读全文
摘要:
Sometimes our clients maybe have such demand it is load the datagrid data(eg.address book) into an excel spreadsheet. There are several ways to accomplish this, However there is a simple, effectiv... 阅读全文
摘要:
By default, the control that is provided in a DataGrid's Edit Mode is the TextBox control, unless of course you are using EditItemTemplates, which is left for another discussion. In Edit mode, the... 阅读全文
摘要:
Long time ago, I upgraded my msn to a new version 6.1, since then i'm no longer able to login. when i sign in, a message pops up, that says, something like: Sorry we could not sign you in, bec... 阅读全文
摘要:
If you've worked with the Int32, DateTime, Decimal types in C#, you probably faced a little problem one day: these data types don't support the null value. Stop grumbling! Don't search further... 阅读全文
摘要:
In this article, Franz Bouma does some benchmarking to compare the performance differences between dynamic queries and stored procedures. Interesting results... dynamic queries are faster 阅读全文