Articles (2404) - Page 160

Articles posted by registered members of You can also post an article and win monthly prizes as well as gain community credit points.

2404 records found.
How to implement Remoting in ASP.NET 
Last updated on: 27 Nov 2007 01:35:10 PM by Raja | Views: 18401 | Category: ASP.NET |
.NET Remoting provides a way for application in different machines/domains to communicate with each other. To make an object remotable that should be inherited by MarshalByRefObject.
Reading appSettings and connectionStrings from web.config file in 
Last updated on: 27 Nov 2007 01:32:54 PM by Raja | Views: 55474 | Category: ASP.NET |
In this tutorials, I am going to explain how to read appSettings and connectionStrings values from the web.config file.
Several Ways to populate DropDownList Controls 
Last updated on: 27 Nov 2007 08:43:37 AM by SheoNarayan | Views: 132798 | Category: ASP.NET |
Votes: 5 | Rating: 4.6 out of 5
There are several ways to populate DropDownList control. In this article I have tried to cover some of them including populating DropDownList manually, programmatically, through xml, database, arraylist, hashtable. I have also covered how to specify different background color of every items of the DropDownList and how to generate DropDownList on the fly. At last I have covered how to get its index, text and value properties.
Source control for stored procedures in SQL Server 2005 
Last updated on: 12 Nov 2007 10:52:09 AM by Deeraj | Views: 17585 | Category: Sql Server |
.NET Developers working with Visual Studio 2005 IDE are well aware of the fact that source control for all the classes, pages, dlls can be integrated just by configuring source control in VS 2005 IDE.
Tracking Object (Table/Function/Stored Procedure etc.,) changes in SQL Server 2005 
Last updated on: 12 Nov 2007 10:50:45 AM by Deeraj | Views: 26405 | Category: Sql Server |
DBAs often need to track the changes being made to the database objects such as tables, user-defined functions and stored procedures etc.,. Our team size was 10 and a couple of members were responsible for each of the modules. My requirement was to track the changes made to the stored procedures right from its creation. My earlier articles explained on how source control can be made available for new/existing stored procedures. If you have missed those articles please catch them up at,
Debugging Stored Procedures in SQL Server 2005 
Last updated on: 12 Nov 2007 10:49:39 AM by Deeraj | Views: 183375 | Category: Sql Server |
Votes: 3 | Rating: 3.67 out of 5
Were you ever in need of debugging a stored procedure in SQL Server 2005. Any .NET Developer is well versed with debugging .NET applications. The .pdb files will be used internally to serve the purpose. Pdb files will have the mapping information from Native to MSIL and ultimately to the .NET code. I will not get into the internals of how this happens as this article falls under the SQL Server category.
Handling Special Chars in javascript 
Last updated on: 12 Nov 2007 06:13:27 AM by Satish | Views: 8904 | Category: JavaScript |
I was wondering how to handle special chars in the query string when redirecting the page to a different page with the help of Javascript. I thought of sharing this snippet.
  • Satish
    Traversing through all the dates in the given range of two dates 
    Last updated on: 12 Nov 2007 06:12:29 AM by Satish | Views: 5332 | Category: JavaScript |
    Here was the challenge for me, I had two dates like FromDate and ToDate. Lets say 01/01/2007 as FromDate and 01/01/2008 as ToDate. I need to traverse through all the dates in the given period. Initially, I was facing a lot of problem, however after many trial and error, I got it. Wish to share the code.
    Query foreign keys of all tables in a given database in SQL Server 2005 
    Last updated on: 07 Nov 2007 06:05:45 AM by Deeraj | Views: 10152 | Category: Sql Server |
    At times as a DBA/DB Programmer we may need to generate a report on foreign keys across all the tables in a given database. It would be a tedious job to use the SQL Server Management studio and build a relationship diagram. Here is a tip to quickly query the meta data and depict all the foreign keys.
    Web Analytics 
    Last updated on: 19 Oct 2007 11:54:48 AM by Amitgupta007_99 | Views: 6833 | Category: Web Analytics |
    What is Web Analytics?
    Change theme dynamically without page refresh in ASP.NET 
    Last updated on: 10 Oct 2007 07:18:41 PM by SheoNarayan | Views: 38519 | Category: ASP.NET |
    You must have noticed one link in, or other popular websites named "Page Options". When you click this link you get a popup displaying different small several color icons. After clicking one of these icons your page theme changes without entire page refresh. Now you are able to see the same page with different look and feel.
    Looping through all rows of the DataTable 
    Last updated on: 08 Oct 2007 06:54:47 PM by SheoNarayan | Views: 93642 | Category: C# |
    Votes: 2 | Rating: 5 out of 5
    Here is the working example of looping through all rows of the DataTable. You can download the code and simply run it by placing to your IIS root folder. Let me explain you looping through all rows of the DataTable step wise.
    Splitting string in C# 
    Last updated on: 01 Oct 2007 06:00:22 PM by SheoNarayan | Views: 34182 | Category: ASP.NET |
    Votes: 1 | Rating: 5 out of 5
    Here is a very simple example of how to split a string delimited with a particular character or string. I know this is very simple to do but I have find many people struggling in doing that. Attached code also demonstrate how to use StringBuilder, Foreach loop, Regex etc.
    Generating Ms Excel file from GridView with ASP.NET and C# 
    Last updated on: 12 Sep 2007 05:30:33 PM by Sheonarayan | Views: 38612 | Category: ASP.NET |
    Votes: 1 | Rating: 5 out of 5
    I was having one requirement of giving an option to the user to generate the Ms Excel sheet from the report that was given to the user in GridView. Initially it seems difficult but when I worked around, I found really easy way to do that.
    Amitgupta007_99 redirection 
    Last updated on: 23 Jul 2007 11:10:40 PM by Amitgupta007_99 | Views: 6074 | Category: ASP.NET |
    The easiest way to make a redirection in ASP.NET is using Response.Redirect(url). What it actually does is, that it creates a response with the "302 (Object Moved)" status code and the target destination. It tells the browser that the requested page is temporarily moved to a new location and then the browser makes a request to the new destination. If the page is permanently moved, then the 302 status code is no longer correct. Search engines also looks at 301 and 302 redirects differently. Here's a quote from The Internet Digest: There is no natural way of doing a 301 redirect in ASP.NET, so you have to set the HTTP headers manually. Below given is a small method that illustrates how to do it. All you have to do is to call it from the Page_Load or preferably from Page_Init or in ASP.NET 2.0 Page_PreInit.