5 Resources for

sqldatareader

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Ensure object cleanup in your .NET applications: Recognizing the need to call and use the dispose method is essential to developing applications that perform properly. This article outlines the steps you should follow to ensure appropriate object cleanup in a .NET application. Garbage collection in the Microsoft .NET common language runtime CLR environment absolves...; Tags: Microsoft .NET, Databases, Middleware, Tony Patton, .NET, Programming languages, SqlCommand, SqlConnection, SqlDataReader, .NET Newsletter, Method, TechRepublic Inc., Database, Connection, Object, Storage, Application Servers, Software Development, Software/Web Development, Hardware, Enterprise Software, Software, Data Management; Technical articles 2005-07-20
Utilize ADO.NET and C# to work with BLOB data: While working on a project that involved storing and retrieving data with SQL Server, Tony Patton encountered a new twist: dealing with BLOBs. Find out how he used ADO.NET to access and store BLOBs. Storing and retrieving data with Microsoft SQL Server is a common task associated with...; Tags: Tony Patton, .NET Newsletter, FileStream, TechRepublic Inc., Database, Microsoft ADO.NET, Microsoft SQL Server, Data, Server, C#, BLOB, SqlDataReader, sConn, SqlConnection, SqlCommand, Databases, Storage, Enterprise Software, Software, Data Management, Hardware; Technical articles 2005-07-01
Ensure object cleanup in your .NET applications: Garbage collection in the Microsoft .NETcommon language runtime CLR environment absolves developers fromtracking memory usage and knowing when to free memory. However,developers still need to stay abreast of an object's lifetime, thusbeing aware of when the object is no longer used. This articleoutlines the steps you should follow to ensure...; Tags: Microsoft .NET, SqlCommand, SqlConnection, SqlDataReader, Tony Patton; Technical articles 2005-07-20
Utilize ADO.NET and C# to work with BLOB data: Storing and retrieving data with MicrosoftSQL Server is a common task associated with most applications. On apast project, I was presented with a new twist on thisinteraction: large data types or BLOBs. The project entailedstoring and retrieving Microsoft Word documents and image files.This article covers the backend aspect of the...; Tags: BLOB, Reading BLOB, Tony Patton, Reading BLOB data, FileStream, Microsoft ADO.NET, Microsoft SQL Server, C#, SqlDataReader; Technical articles 2005-07-01
Simplify .NET SQL queries with the Data Access Application Block: Although Microsoft's .NET Application Block is well documented, the practical tips and tricks that make it more usable on a day-to-day basis are harder to find. This article gathers some code that will make the Data Access Application Block easier to use in everyday .NET/SQL Server projects.Getting startedYou can download...; Tags: .NET, Microsoft development tools, Databases, William Sempf MCP, CIBS, IWA, ExecuteNonQuery, ExecuteScalar method, ExecuteDataset, Data Access Application Block, ExecuteReader, SqlDataReader, SQL-query, DataSet dataSet, data access, ExecuteScalar, connString; Technical articles 2003-07-15

Additional Resources

Data Access Application Block (msi): The Data Access Application Block encapsulates performance and resource management best practices and can easily be used as a building block in your own .NET application. If you use it, you will reduce the amount of custom code you need to create, test and maintain. Specifically, the Data Access Application...; Tags: Data Access, Data Access Application Block; Software downloads 2007-09-07
Perform bulk copies with .NET 2.0's SqlBulkCopy class: The .NET Framework 2.0's SqlBulkCopy class allows you to easily move data programmatically from any data source to a SQL Server table. Learn how to use SqlBulkCopy to streamline data transfers. A common development task is transferring data between disparate data sources. If you have worked with SQL...; Tags: Microsoft .NET, Microsoft SQL Server, SqlBulkCopy, Databases, Tony Patton, .NET, development task, DestinationTableName property, SqlBulkCopy class, data source, database, server, .NET Newsletter, Caveat, Data, Class, .NET Framework 2.0, DataTable, Listing C, Storage, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware; Technical articles 2007-05-29
Protect database resources with clean .NET code: In a previous article, I wrote about the importance of observing certain rules for object cleanup in .NET code. One of theworst examples I've experienced is with database interaction. I once fixed an application whoseperformance slowly degraded after a restart as databaseconnections were consumed. The problem lay in the fact...; Tags: database, database connection, Microsoft .NET, Tony Patton; Technical articles 2005-07-21
Protect database resources with clean .NET code: Developers are keen to open and utilize a database connection, but it is common to overlook the process of closing and returning the resources utilized to the system. Tony Patton examines how this can be accomplished. In a previous article, I wrote about the importance of observing...; Tags: Microsoft .NET Framework, Microsoft .NET, Storage, Databases, Tony Patton, .NET, Middleware, database connection, database, garbage collector, .NET Newsletter, Method, TechRepublic Inc., Data, Resource, Object, Hardware, Enterprise Software, Software, Data Management; Technical articles 2005-07-21
Include totals with numeric values via DataGrid: DataGrid is a valuable part of any developer's toolbox. Learn how you can use DataGrid to include total values, which is often a requirement when working with numeric values. I talk to a lot of people who sneer when discussing the DataGrid control; they...; Tags: DataGrid, Tony Patton, C#, .NET, totalFreight, sConn, server, .NET Newsletter, Database, Paging, Column, Freight, Databases, Enterprise Software, Software, Data Management; Technical articles 2005-06-29
Clean up your ADO.NET mess to ensure good application performance: While much has been written about how easy ADO.NET makes it to access data from a variety of data sources, there are things to which you must pay attention to maintain good application performance. One of these is the proper termination and cleanup of ADO.NET objects to be certain that...; Tags: .NET, Databases, Microsoft .NET Framework, Baseline Inc., Microsoft ADO.NET, garbage collection, database connection, database, Microsoft SQL Server; Technical articles 2003-04-14
Understanding the ASP.NET DataGrid control: Tabular presentation of data: Love it or hate it, as a programmer, you just can't live without it. In the past, overzealous ASP programmers and the "spaghetti" style of coding resulted in the use of numerous HTML <table> elements fighting for attention with inline ASP function calls and statements. This...; Tags: C#, .NET, Microsoft ASP.NET, Guest Contributor, DataGrid, BindMe, server; Technical articles 2004-04-30
Include totals with numeric values via DataGrid: I talk to a lot of people who sneer whendiscussing the DataGridcontrol; they often discard it in favor of third-partyalternatives. DataGrid, a core piece of the .NET Framework, isactually a valuable part of my development toolbox. Presenting data in a table format provides manyopportunities. I'll explain how...; Tags: DataGrid, DataGrid Control, sConn, server, Tony Patton, totalFreight; Technical articles 2005-06-29
Secure your database interaction with SSL: The details of securing the communications between a client and Web application are often covered, but what about the communication between the application and database server? Here's a look at securing the database interaction with Secure Sockets Layer SSL. The beginning of 2005 started on a bad note, as...; Tags: Microsoft SQL Server, SSL, Authentication/Encryption, Databases, Tony Patton, SSL/TLS, Network security, SECURITY, Enterprise software, database, InstantSSL, Microsoft SQL Server 2000, .NET Newsletter, TechRepublic Inc., Microsoft Windows 2000, Communication, Server, Networking, Software, Data Management; Technical articles 2005-07-21
Perform bulk copies with .NET 2.0's SqlBulkCopy class: A common development task is transferring data betweendisparate data sources. If you have worked with SQL Server, the bcp bulk copy command will be familiar to you. It allowsyou to quickly bulk copy large files into SQL Server tables or views. With .NETFramework 1.1, you can utilize bcp via a...; Tags: Databases, .NET, Microsoft .NET, development task, Tony Patton, DestinationTableName property, SqlBulkCopy, SqlBulkCopy class, Microsoft SQL Server, data source, database, server; Technical articles 2007-05-29
Access SQL-based data with C# and ADO.NET: ADO.NET is a framework of classes that allow you to accessdata and provide you with a direct way to get the necessary information foryour .NET applications. In this article, I discuss how you can access SQLServer-based data using C# and ADO.NET. I will use a simple C# application asan example.ConnectionsConnections...; Tags: C#, CommandText, database, Irina Medvinskaya, Microsoft Access, Microsoft ADO.NET, Microsoft SQL Server, SQL, SqlCommand; Technical articles 2006-07-18
Which dataset should you choose?: I've recently noticed some confusion amongcoworkers and clients regarding dataset options. This confusionstems from the fact that a dataset may or may not be typed. Thedeveloper makes the choice, which affects how the dataset isutilized in the code. In this article, I examine dataset types tofurther clarify their differences. ...; Tags: Dim cntString, dataset, cntString, strSQL, Tony Patton, Nothing, developer, SqlConnection; Technical articles 2005-06-28
Secure your database interaction with SSL: The beginning of 2005 started on a bad note, as I had to dealwith a stolen credit card. The issue led me to consider security inthe world of online transactions and data access. The details of securing the communicationsbetween a client and Web application are often covered,...; Tags: Microsoft SQL Server, SSL, Tony Patton, database, InstantSSL, Microsoft SQL Server 2000; Technical articles 2005-07-21
Access Oracle data with .NET's new managed provider: Microsoft promotes SQL Server as the database for your .NET applications, but with Oracle’s strong presence, you will undoubtedly need to utilize Oracle data in a .NET application. Oracle data was accessible in ADO.NET, using generic OLE-DB providers, but performance lagged behind that of SQL Server’s managed provider. Microsoft recognized...; Tags: .NET, Application servers, Middleware, Databases, Microsoft Corp., Microsoft Access, Baseline Inc., Oracle Corp., Microsoft .NET, database; Technical articles 2003-03-03
Which is best for you: DataReader or DataSet?: By Mark A. StrawmyerPrior to the release of the Microsoft .NET Framework, programmers had few data access technology choices for interacting with data stored in a database. An ActiveX Data Object ADO Recordset was the option commonly used to hold query results and data contents. It originally required a constant...; Tags: XML, Storage, Databases, .NET, Enterprise software, Crowe, Chizek and Company LLP, DataReader, Dataset, database; Technical articles 2003-09-05

<< Previous
page 1 of 1
Next >>

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now

Best Practices for Maximizing Microsoft Access 2003: This pre-packaged presentation contains everything you need to instruct end users about how to get the most out of Microsoft Access--even if you don't ...; Buy Now

sqldatareader

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Additional Resources

The Green Enterprise