Discuss Content Posted by Koby Biller

Discussions about content posted by Koby Biller.

Should you use a DataReader or DataSet?

In the beginning, there was the recordset, a central feature of classic ADO. Like a Swiss army knife, it wasn’t the perfect tool for every job, but given the correct configuration, it could do whatever you needed it to do.

The recordset wasn’t always pretty to watch, however, and it came into prominence at a time when client/server applications for which it was optimized were being replaced by web applications. Its dark side included an amazing level of complexity and the number of special cases when it was used with particular providers.

RE: Notification on update

Hi Amit, Given the following details could you please quickly put together a trigger to send the last added name. I plan to use xp_sendmail but still trying to configure the MAPI.UserID int 4 UserName nvarcahar 50 Password char 10 EMailAddress nvarchar 50Table name = Users SQL Database = EUTScheduleThanks in advance.     

Discuss Content Posted by David Jackson

Discussions about content posted by David Jackson.

Teach Old Data New Tricks with the Fully Loaded Advances in ADO.NET 2.

The Microsoft® .NET Framework 2.0 delivers an updated ADO.NET that will streamline your data access development efforts. The ADO.NET team has worked with both the System.Xml team and the SQL Server™ team to provide a consistently rich developer experience, crossing technology boundaries from ADO.NET to XML and back. This will all be apparent as you dig into ADO.NET 2.0. There are improvements on so many fronts that you will certainly be pleased.

Rather than attempt to list every new and updated feature of ADO.NET 2.0, I will discuss in detail some of the more interesting improvements and focus on performance and flexibility.

RE: Dynamic SQL problem

Don't make me feel < snip and switch to my online dictionary> embarrassed </snip>  

Query Notifications in ADO.NET 2.0

Learn how to use the new notification technologies in ADO.NET 2.0 and SQL Server 2005 to handle ad-hoc data refreshes.

ADO.NET - A Data Access Layer

Developing applications for SQL Server usually results in a variety of access methods that the programmers use. A data access layer class, given to the developers, is usually seen as the best practice, but one that isn't usually implemented. In fact, in most software I've built, each developer uses his own method, or may cut and paste from another, but rarely is there a central access class. New Author Patryk Nowakowski brings us his solution using ADO.NET.

Discuss Content Posted by Ashish Kaushal

Discussions about content posted by Ashish Kaushal

Changing Databases Using XML

Need to apply changes to customer (or internal) databases in a calm, controlled manner? Dinish proposes an alterative to standard scripts that uses XML and a small VB app.