 |
Using the Microsoft Managed Provider for Oracle...
|
| Total Hit (769) |
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 (854) |
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 (5411) |
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 (4691) |
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
|
|
 |
Component Services for .NET, Part I of IV
|
| Total Hit (2186) |
The topic of component services is about creating enterprise applications that need to be secure, reliable, available, efficient and scalable. Component Services, aka COM+ (previously MTS), is the part of the Windows Server OS that supports these goals. The idea is that integrating your application
....Read More |
| Rating
|
|
|
|
Create and Read Cookies
|
| Total Hit (904) |
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
|
|
|
|
.NET Remoting - Part II
|
| Total Hit (3513) |
Remoting provides a very flexible environment for distributed applications in the .NET arena. In part one of this series of four articles (note that this is an extension of the initially planned three as indicated in article I) I introduced the background to distributed applications and the .NET rem
....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
|
|
|
|
.NET Remoting - Part I
|
| Total Hit (1214) |
Remoting provides a flexible architecture for distributed applications in .NET. This series of articles shall examine the topic of remoting.
|
| 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
|
|
|
|
|
|
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
|
|
 |
Replace function in C#
|
| Total Hit (8625) |
Currently C# has no replace function build in .net where are Vb.net has it. This function helps you to replace strings.
|
Rating
 |
|
|
|
|
|
An Introduction to Regular Expressions and Their Use in .NET II...
|
| Total Hit (1545) |
In the first article in this series we introduced background information regarding regular expressions as well as starting to look at the support for regular expressions in .NET. In this article we'll look in more detail at this latter area.
|
| Rating
|
|
|
|
An Introduction to Regular Expressions and Their Use in .NET I...
|
| Total Hit (2548) |
Regular expressions pop up in several locations in .NET and its supporting technologies. A prime example would be in the RegularExpression server validation control but the power of regular expressions are also utilised elsewhere, for example within XSD schemas with the pattern facet. This gives a g
....Read More |
| Rating
|
|
|
|
Updating with the SQLDataAdapter...
|
| Total Hit (907) |
Using the SQLDataAdapter's Update method is a very valuable and timesaving approach when synching a DataSet with a database. The SQLDataAdapter updates the SQL Server data source through the DataSet object, which tracks changes at the row level, through the RowState property. There are several metho
....Read More |
| Rating
|
|
|
|
|
|
Obtaining Data Based Upon Multiple Selections From a ListBox...
|
| Total Hit (958) |
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 (4297) |
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 (839) |
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 (1945) |
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
|
|