Articles (2402) - Page 160

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

2402 records found.
 
SheoNarayan
Several Ways to populate DropDownList Controls 
Last updated on: 27 Nov 2007 08:43:37 AM by SheoNarayan | Views: 128073 | 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.
Deeraj
Source control for stored procedures in SQL Server 2005 
Last updated on: 12 Nov 2007 10:52:09 AM by Deeraj | Views: 16799 | 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.
Deeraj
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: 25261 | 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, http://dotnetfunda.com/articles.
Deeraj
Debugging Stored Procedures in SQL Server 2005 
Last updated on: 12 Nov 2007 10:49:39 AM by Deeraj | Views: 177326 | 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.
Satish
Handling Special Chars in javascript 
Last updated on: 12 Nov 2007 06:13:27 AM by Satish | Views: 8419 | 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: 4953 | 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.
Deeraj
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: 9765 | 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.
  • Amitgupta007_99
    Web Analytics 
    Last updated on: 19 Oct 2007 11:54:48 AM by Amitgupta007_99 | Views: 6404 | Category: Web Analytics |
    What is Web Analytics?
    SheoNarayan
    Change theme dynamically without page refresh in ASP.NET 
    Last updated on: 10 Oct 2007 07:18:41 PM by SheoNarayan | Views: 37036 | Category: ASP.NET |
    You must have noticed one link in yahoo.com, msn.com 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.
    SheoNarayan
    Looping through all rows of the DataTable 
    Last updated on: 08 Oct 2007 06:54:47 PM by SheoNarayan | Views: 90189 | 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.
    SheoNarayan
    Splitting string in C# 
    Last updated on: 01 Oct 2007 06:00:22 PM by SheoNarayan | Views: 33060 | 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.
    Sheonarayan
    Generating Ms Excel file from GridView with ASP.NET and C# 
    Last updated on: 12 Sep 2007 05:30:33 PM by Sheonarayan | Views: 37214 | 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
    ASP.net redirection 
    Last updated on: 23 Jul 2007 11:10:40 PM by Amitgupta007_99 | Views: 5631 | 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.
    Chinnu21
    sending email using system.net.mail 
    Last updated on: 20 Jul 2007 04:49:56 AM by Chinnu21 | Views: 13539 | Category: ASP.NET |
    Below is a C# and VB.NET class that demonstrates using System.Net.Mail to send an email.
    Deysomnath
    Resizable GridView Column 
    Last updated on: 12 Jul 2007 02:45:48 AM by Deysomnath | Views: 27512 | Category: ASP.NET |
    This article will help us to implement resizable gridview column There's four important points to remember about it all. 1.Based on how the code is written, the Grid that has resizable columns must be contained in some other element (in these examples I use a DIV) and that element must have a style set of "position: absolute;". You need this to size the black vertical bar that attaches to the mouse correctly when performing an actual resize. 2.Based on how the code is written, you can only perform resize operations on table header cells (TH tags). This simply feels like the right way to do it - you could make it TD tags instead, and be able resize the column for the entire height of the table if you wanted to. 3.The actual table must have a style set of "table-layout: fixed;" If you don't set this style, strange things happen (try it and see, it goes all loopy when you resize . 4.To save having to remember to put too many requirements in the implementation, the black ve ...