 |
Using the Microsoft Managed Provider for Oracle...
|
| Total Hit (770) |
Microsoft has brought the power and speed of the Managed Provider for SQL Server to the Oracle database. In this article we see how to use it directly, and to call a stored procedure with a join.
|
Rating
 |
|
|
|
Returning Multiple Resultsets with the DataReader
|
| Total Hit (856) |
Recently I was asked to create a data entry page for a table with 35 columns, 10 of which needed to be DropDownLists (combo boxes). It seemed very inefficient, and required too many coding key strokes, to go to the database 10 times to get the values for the DropDownLists. I started looking for a be
....Read More |
| Rating
|
|
|
|
Use the DataReader to Process Data One Row at a Time
|
| Total Hit (5413) |
At times you may find the need to do some processing of rows from a database before they are displayed to the user. We all remember processing classic ado recordsets one row at a time. You can do the same thing with .Net's DataReader which produces a very fast forward-only stream of database table d
....Read More |
| Rating
|
|
|
|
Page and Data Caching in .Net
|
| Total Hit (4694) |
In this article we’re going to take a look at the features available to the ASP.NET programmer that enable performance improvement via the use of caching. Caching is the keeping of frequently used data in memory for ready access by your ASP.NET application. As such caching is a resource trade-off be
....Read More |
| Rating
|
|
|
|
Create and Read Cookies
|
| Total Hit (906) |
In this article we will see how to determine if a user's browser accepts cookies, how to create both session and persistent cookies, how to read cookies, and how to store and read cookies with sub-keys (cookie dictionary). First, the .aspx page, which is mostly labels and explanations of what the pr
....Read More |
| Rating
|
|
|
|
Send Email and Attachments with ASP.Net
|
| Total Hit (753) |
In this example you will see how to send email and one way of sending attachments from within an .aspx file. The text boxes for the various components of the email are wrapped in a panel control, so if you have not used panels, you can learn a little about that .net control.
....Read More |
| Rating
|
|
|
|
|
|
|
|
Using the Luhn Algorithm
|
| Total Hit (512) |
Validate credit card numbers, Canadian Social Insurance Numbers, and other unique numbers using the Luhn algorithm.
|
| Rating
|
|
|
|
Screen Scraping in ASP.NET
|
| Total Hit (522) |
Screen scraping is a lot easier in .NET than it was in classic ASP where you had to use the infamous INET.DLL. The System.Net namespace provides all the methods we need to perform screen scraping in .NET. I will show you the code without a great deal of explanation. In this first example program we
....Read More |
| Rating
|
|
|
|
Popup - The .NET Way
|
| Total Hit (532) |
In this article we are going to build a method and an overload of the same which will open a popup window without using javascript or VB code in the .aspx page.
|
| Rating
|
|
|
|
Windows Server 2003 for ASP.NET Developers
|
| Total Hit (743) |
This article looks at Windows Server 2003 and why you might want to consider upgrading your servers to use the product at this point in time through an examination of what new features the product provides and what the upgrade consequences might be for your ASP.NET applications. As apart of this we
....Read More |
| Rating
|
|
|
|
Forms Authentication Against SQLServer
|
| Total Hit (522) |
In this article I'll cover how we can extend the inbuilt facilites of ASP.NET a little to provide authentication against a SQLServer database. Forms authentication is the method we shall focus on, in particular integrating a SQLServer authority.
|
| Rating
|
|
|
|
ViewState
|
| Total Hit (568) |
ViewState is the mechanism by which page state (information) is maintained between page post backs, i.e. a web form is submitted by the user, this same page performs some processing and perhaps presents further information to the user.
|
| Rating
|
|
|
|
Exam 70-305 Hints and Tips
|
| Total Hit (573) |
This 'article', for want of a better word, is a collection of hints and tips for the 70-305 Microsoft Certification Exam: Developing and implementing web applications with VB.NET and ASP.NET. Each entry addresses areas of knowledge known to be tested during versions of the exam but that are concerne
....Read More |
| Rating
|
|
|
|
Debugging an ASP.NET Web Application, Part II - Debugging
|
| Total Hit (882) |
Bugs are a fact of the programmer's life. How can we deal with them efficiently? In this series of two articles I'm going to look at two main areas of finding and fixing errors in your program - Tracing and Debugging.
|
| Rating
|
|
|
|
|
|
Event Handling in ASP.NET
|
| Total Hit (554) |
The ASP.NET model hides the programmer from some of the full complexities of event handling in VB.NET, as does the IDE of VS.NET so this article shall hopefully provide a little insight into what's available in the .NET framework.
|
| Rating
|
|
|
|
Creating and Using .NET Components
|
| Total Hit (891) |
Code reuse is an important concept in software engineering. This article looks at how we can implement one method of code reuse via the building of reusable components.
|
| Rating
|
|
|
|
Separating Code from Content in ASP.NET Pages via Code-Behind
|
| Total Hit (570) |
ASP.NET web forms can be logically divided into two sections: the user interface (UI) components and the code for the page. The user interfaces comprises HTML and ASP.NET controls. The code programmatically interacts with the UI elements.
|
| Rating
|
|
|
|
Globalization and Localization
|
| Total Hit (518) |
The .NET Framework provides support for globalization and localization. Localization is the custumization of data and resources for specific 'locales' or languages. Whereas in pre-Internet days it wasn't unusual for an application to be designed for use in a single country, now an Internet applicati
....Read More |
| Rating
|
|
|
|
Debugging an ASP.NET Web Application, Part I - Tracing
|
| Total Hit (891) |
Bugs are a fact of the programmer's life. How can we deal with them efficiently? In this series of two articles I'm going to look at two main areas of finding and fixing errors in your program - Tracing and Debugging.
|
| Rating
|
|
|
|
Comparing the Performance of Various Iteration Methods
|
| Total Hit (517) |
When you have to iterate through large amounts of data, you can save significant time by choosing your iteration method carefully.
Method #1: Enumeration
Method #2: Indexing
Method #3: Indirect Array
Method #4: Direct Array
Method #5: Pointer Math
....Read More |
| Rating
|
|
|
|
|
|
Dropdown list for the foreign key of a table in a datagrid
|
| Total Hit (933) |
The script populates an ArrayList with values from the database and then binds the list to the dropdown inside the datagrid. You would want to do something similar, but you'll need to store the foreign key as well as the text.
|
| Rating
|
|
|
|
|
|
Obtaining Data Based Upon Multiple Selections From a ListBox...
|
| Total Hit (959) |
This article will demonstrate how to allow multiple selections in a ListBox control and how to build a WHERE clause on the fly that will fill a DataGrid with data based upon the selections made in the ListBox. There is really no new ground broken here. The article just demonstrates a technique or tw
....Read More |
| Rating
|
|
|
|
Reading Excel (.xls) Files with ADO.NET...
|
| Total Hit (4301) |
Since Excel has an OleDB provider, we can use ADO.NET's OleDb functionality to connect to Excel. It does take a little preparation on the Excel side however. You might think that since Excel has rows and columns we might be able to use that and refer to A1 and B3, etc. We can't (as far as I know). W
....Read More |
| Rating
|
|
|
|
Returning Resultsets Using Sql Server Stored Procedures...
|
| Total Hit (841) |
Every modern database system has a stored procedure language. SQL Server is no different and has a relatively sophisticated and easy to use system. This article will not attempt to go into depth in explaining SQL Server stored procedure programming - there are whole books devoted to the subject. Ins
....Read More |
| Rating
|
|
|
|
Export DataSets to Excel...
|
| Total Hit (1948) |
Often we need to load the data from a dataset into an excel spreadsheet to be manipulated and/or saved off to a local file. There are several ways to accomplish this using either Crystal Reports or ActiveReports. However there is a simple, elegant way to do the same thing without the need for a repo
....Read More |
| Rating
|
|