Convert Data Reader to Data Table

The usual workaround for this purpose is loop through the rows in the Data Reader and assign each rows to Data Table, This is a time consuming process.But Dot Net 2.0 and above provides a new DataTable.Load() as a quicker solution.Here is the methodDataTable.Load(IDataReader);...

Convert data table to data reader

In some situations you may need to convert your data table to data reader, suppose you have a Data table named dt and getDataFromDB() is a function that returns a data table, here is the steps to convert data table to data reader. DataTable dt = new DataTable(); dt = getDataFromDB();...

30 Common String Operations in C# and VB.NET

In this article, I have compiled some common String operations that we encounter while working with the String class. All the samples are based on two pre-declared string variables: strOriginal and strModified. C#     string strOriginal = "These functions...

Use .NET Built-in Methods to Save Time and Headaches

During our everyday programming tasks we run into several repetitive code blocks that after the 20th time you implement them become really annoying. The worst case is to re-implement these code blocks every time, and the better case is to create a central class library...

Laws of Computer Programming

1.    Any given program, once deployed, is already obsolete. 2.    It is easier to change the specification to fit the program than vice versa. 3.    If a program is useful, it will have to be changed. 4.    If...

T-SQL: Recently Executed Query

I am a regular reader of Pinal Dave's blog SqlAuthority. I always found something new in his blog to work with SQL Server. Here is something I would like to share: Get the recent executed SQL Queries from SQL Server. 1.SELECT deqs.last_execution_time AS [Time], dest.TEXT...

Limiting the length of a multiline textbox

Limiting the length of an ASP.net mulitline textbox control is easy. Add a RegularExpressionValidator, set the ControlToValidateProperty to the ID of the TextBox you wish to validate and set the ValidationExpression property to :^[\s\S]{0,300}$ This tells...

Setting the default Button for a TextBox in ASP.NET

Hitting the enter key in a TextBox can sometimes have undesired effects like the wrong submit Button being “clicked“. The method described below allows you to specify a default Button to submit when the user hits the enter key in a TextBox....

Had a Gr8 time @PUG Developer Summit - 16th Jan 2010

Hi, Last Saturday, I attended my first PUG Developer Summit & it was really gr8 fun. Got to know a lot of new things. The session started with Silverlight 4 which was given by Vikram Pendse - MVP . He showed some really cool demos, the one in which we can actually take...

SQL Server performance with NOCount On

HiWhen working with Database, the most difficult and important thing is to ensure that the database is as fast as possible. After a few year when the number of users in a database grow and the data also start to increase, the performance starts to slide down. At this point...

Design pattern – What can they mean?

Hi How and why did the design pattern started. So I started hunting in the google for my curiosity and found some interesting stuff. So I thought I would share them with you. A repeatable solution for commonly occurring problem in the software programming is called design...

Programmatically set the Page Description and Keywords in Asp.Net 4.0

Hi, One of the small but new features in Asp.Net 4.0 is the addition of the Title, Metakeyword and Metadescription property in the page class itself. Now we can easily set the Title, Metakeyword and Metadescription (very important for sites looking for SEO.) from the page...

Asp.net 4.0 FormView Control Enhancement

Hi,another of the new features of Asp.net 4.0 is the enhancement(in terms of rendering) made in the Formview control. By default the Formview control would render table, tr and td tags for display of content. This can be of much trouble to many of the designer because they...

Important SQL Server and Windows “End of Support” Dates you should know about….

There are some important dates about the end of support for specific products and releases involving SQL Server and Windows that I want you to be aware of:  Important Upcoming SQL Server Support Dates 1) SQL Server 2005 Service Pack 2 support ends next week January...

how to change Visual Studio's default browser

In this article I will explain how to change visual studio's default browser. Posted via email from fenildesai's posterous ...

Access Viewstate across pages in ASP.NET

Introduction There was one question during my recent work in one of my ASP.NET Project. “Is it possible to access the ViewState variable of one page on another page?” My answer was “No” . Because i have read in books that Viewstate is page specific, it is available only...