listing c

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Handle errors in the data tier with SQL Server

Listing AInteresting article. I suppose it would be useful to return the @@error value in the stored procedure so a .NET developer could know what the error code is. Otherwise, they would just have a generic error message which could make debugging more difficult.On a side note, I...

Tags: .NET, Databases, Programming languages, Middleware, saa@..., Listing C, Handle Error, data tier, error code, Microsoft SQL Server, server

Discussion threads 2007-10-31

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

Get a handle on directory security with .NET's DirectorySecurity object

By using .NET's DirectorySecurity class and the Directory class's methods, you can easily manipulate a file system's security to control user access to directories. Tony Patton offers more details in this article. An important topic when working with .NET directories is security; that is, you want the users who...

Tags: Microsoft .NET, DirectorySecurity, FileSystemAuditRule, Tony Patton, .NET, FileSystemAccessRule class, access control, access control list, DirectorySecurity class, .NET Newsletter, Security, Directory, Parameter, Auditing, Class, Entry, Rule, Object, FileSystemAccessRule, FileSystemAuditRule Class, AccessControlType Enumeration, FileSystemAuditRule Constructor, Listing C, Listing E

Technical articles 2007-05-08

Put SQL Server's EXISTS construct to good use

The next time you are writing your own queries, remember SQL Server's EXISTS construct. It is typically fast and easy to use, and it can prove very useful in programming situations. One thing I have noticed over the years is how seldom developers use SQL Server's very useful...

Tags: Microsoft SQL Server, Tim Chapman, SalesHistory, Listing C, SalePrice, Databases, server, SQL Server Newsletter, Construct, Enterprise Software, Software, Data Management

Technical articles 2007-04-30

Accessing form data via JavaScript and the DOM

The HTML Document Object Model DOM provides everything necessary to access the contents of an HTML page. Tony Patton examines the various ways to access page elements and describes how to create them. Accessing and manipulating the various elements on a Web page is a common endeavor that...

Tags: Document Object Model, JavaScript, XML, Tony Patton, Web Development Zone Newsletter, Method, Web, HTML, Page, Object, Listing B, getElementById Method, getElementsByName Method, Listing C, Software/Web Development, Web Development

Technical articles 2007-04-16

Audit data using SQL Server 2005's COLUMNS_UPDATED function

DBA Tim Chapman looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names. Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has...

Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, COLUMNS_UPDATED, Databases, Enterprise software, sys.fn_IsBitSetInBitmask, trigger, update statement, audit, SQL Server Newsletter, Function, Auditing, Microsoft SQL Server 2000, Listing B, COLUMNS_UPDATED Function, System Function, Listing C, Software, Data Management

Technical articles 2007-04-16

Developing Bluetooth wireless applications in J2ME

Peter Mikhalenko reviews the principles of Java development for Bluetooth on mobile devices and describes how to write a Java application for Bluetooth communications. A growing number of cellular phones support Java applications, but did you know that many devices can also run Java 2 Micro Edition...

Tags: J2ME, Java, LocalDevice, RemoteDevice, Bluetooth, Wi-Fi, Peter V. Mikhalenko, Programming languages, JSR 82, JSR 82 specification, Java Bluetooth API, specification, Java Tips Newsletter, Device, Server, Wireless Application, Service, Peter Mikhalenko, Bluetooth API, DiscoveryAgent, Listing C, Service Discovery Service Discovery, Listing D, Wireless

Technical articles 2007-03-28

Create custom notifications with SQL Server 2005

DBA Tim Chapman builds a small custom notification system with SQL Server that allows you to send a message to the correct people when a problem occurs. In my article on sending e-mail with Database Mail in SQL Server 2005, I discussed how crucial it is to be...

Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, Databases, Listing C, Database Mail, Service Broker, database, SQL Server Newsletter, Message, Procedure, Enterprise Software, Software, Data Management

Technical articles 2007-03-13

Drill down into data with ASP.NET 2.0's DetailsView control

Working with individual data records required custom development in ASP.NET 1.1, but it is simple and straightforward in 2.0 with the DetailsView control. Tony Patton offers a closer look at this new ASP.NET 2.0 control. The past two weeks I have examined using ASP.NET 2.0's GridView data control to...

Tags: Microsoft ASP.NET, DetailsView, GridView, Middleware, Tony Patton, .NET, ASP.NET 2.0, sample code, data source, DetailsView control, paging, .NET Newsletter, Control, Data, Microsoft ASP.NET 2.0, Fields Element, Listing C, Software Development, Software/Web Development, Enterprise Software, Software

Technical articles 2007-03-13

Easily manipulate data with the GridView control in ASP.NET 2.0

Tony Patton recently introduced ASP.NET 2.0's GridView data control and covered the basics of using it. In part two of this series, he demonstrates how the GridView control makes it easy to view, edit, and delete data. Last week, I introduced ASP.NET 2.0's GridView data control and covered the...

Tags: Microsoft ASP.NET, GridView, Middleware, Tony Patton, .NET, Microsoft development tools, ASP.NET 2.0, server control, HTML Text, TemplateField, .NET Newsletter, Data, Server, Microsoft ASP.NET 2.0, Listing B, SqlDataSource, SqlDataSource Element, Listing C, Listing D, Software Development, Software/Web Development, Enterprise Software, Software

Technical articles 2007-03-06

Control table appearance with CSS

The final installment of the three-part series on styling HTML table elements with CSS concludes with a focus on spacing and table layout. My previous columns covered how to organize data with HTML tables and control style table borders with CSS. This week, I conclude this three-part...

Tags: HTML, Listing B, CSS, Tony Patton, Web Development Zone Newsletter, Property, Cell, Table, Listing C, Scripting Languages, Software/Web Development, Web Development

Technical articles 2007-02-26

Post data to other Web pages with ASP.NET 2.0

ASP.NET 2.0's PostBackUrl attribute allows you to designate where a Web form and its data is sent when submitted. Tony Patton explains how you can make use of this new Web solution. Standard HTML forms allow you to post or send data to another page or application via...

Tags: Web, Microsoft ASP.NET, Middleware, Tony Patton, .NET, ASP.NET 2.0, .NET Newsletter, Page, Data, Property, Microsoft ASP.NET 2.0, Web Page, PreviousPage, Listing C, Listing D, Software Development, Software/Web Development, Enterprise Software, Software

Technical articles 2007-01-30

Enhance your Web application with scriptaculous

In his previous Web Development Zone column, Tony Patton explained what scriptaculous is, described how to use it, and discussed why you should use it. Now he plays up some of the really cool features of this free JavaScript framework. Last week I covered the basics of downloading...

Tags: Tony Patton, Channel management, Web application, Sortable, Web Development Zone Newsletter, Web, Page, List, Listing C, Marketing

Technical articles 2007-01-22

Personalize ASP.NET 2.0 sites with profiles

The ASP.NET 2.0 Profile system allows you to easily store user-specific information. Learn more about setting up and using this new feature in your applications. Personalization is a key component of most Web applications these days. TechRepublic and Amazon are good examples of sites that remember certain...

Tags: Microsoft SQL Server, Microsoft ASP.NET, Middleware, Databases, Tony Patton, .NET, Enterprise software, ASP.NET 2.0 Profile system, tool, personalization, Profile system, server, database, ASP.NET 2.0, .NET Newsletter, Environment, Microsoft ASP.NET 2.0, .NET Framework 2.0, Listing C, Software Development, Software/Web Development, Software, Data Management

Technical articles 2006-12-21

Write PIVOT queries in SQL Server 2005

SQL Server 2005's PIVOT operator allows you to rotate row level data into tabular data without the use of the CASE statement. Tim Chapman describes why this new operator has a place in the TSQL developers' toolbelt. New to SQL Server 2005 is the PIVOT operator, which gives...

Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Tim Chapman, CASE statement, PIVOT operator, statement query, CASE statement query, SQL Server Newsletter, Problem, Data, Statement, Operator, Difference, Listing B, PIVOT, CASE, Listing C, PIVOT Clause, Listing D, Enterprise Software, Software, Data Management

Technical articles 2006-12-18

Easily sort values with the .NET Array class's Sort method

Tony Patton recently examined the basic functionality of .NET arrays; this week, he focuses on the Array class's Sort method, which simplifies sorting the contents of an array. He also explains how you can use other .NET features to institute custom sorting. In a previous column, I discussed...

Tags: Microsoft .NET, Middleware, Tony Patton, .NET, Microsoft development tools, .NET Newsletter, Method, Array, Class, Interface, Person, Array Class, Sort, IComparable, IComparer, Listing C, Listing E, Listing F, .NET Array Class, Application Servers, Software Development, Software/Web Development, Enterprise Software, Software, Development Tools

Technical articles 2006-11-14

Formatting data in columns with ASP.NET's DataList control

ASP.NET provides plenty of data controls to present data in a variety of ways. One common format is displaying a list of items in column format. Learn how to achieve this layout with the DataList control. I was recently talking to a developer about presenting data on a...

Tags: Microsoft ASP.NET, DataList, Middleware, Tony Patton, .NET, Microsoft development tools, .NET Newsletter, Control, Data, SeparatorTemplate, Listing C, DataList Web Form, Listing F, Listing G, Software Development, Software/Web Development, Enterprise Software, Software

Technical articles 2006-08-30

Handle bulk binding exceptions in PL/SQL

The downside to bulk binding in PL/SQL is that if any of the data values result in an invalid UPDATE, the entire set of iterations is rolled back. Bob Watkins explains how you can get around this issue. Bulk binding in PL/SQL is an important technique for efficient...

Tags: Oracle Corp., PL/SQL, SQL%BULK_EXCEPTIONS, Listing C, Databases, Bob Watkins, Programming languages, FORALL, SAVE EXCEPTIONS, Oracle Tips Newsletter, Downside, UPDATE, Listing D, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Technical articles 2006-08-21

Easily integrate PostgreSQL with .NET

The PostgreSQL database server provides a reliable, robust database solution at no cost. Tony Patton walks you through the steps of using PostgreSQL as the backend for .NET applications. The open source software community has had a huge impact on the software industry. The quality and type of...

Tags: Microsoft .NET, PostgreSQL, Npgsql, Databases, Tony Patton, .NET, open source software community, .NET Newsletter, Database, Difference, Listing B, PostgreSQL Database Server, Open-source Software Community, PL/pgSQL, PL/sgSQL, Npgsql Data Provider, Listing C, Listing E, Enterprise Software, Software, Data Management

Technical articles 2006-08-08

Easily integrate JavaScript with ASP.NET pages

While ASP.NET provides a robust development platform, developers should not overlook mature technologies like JavaScript. Tony Patton explains how to integrate JavaScript with ASP.NET controls in this edition of Web Development Zone. While Web development platforms provide flexibility and power, you often want or need to rely on...

Tags: Microsoft ASP.NET, JavaScript, Tony Patton, Scripting languages, .NET, JavaScript confirmSubmit function, Page Class, Web Development Zone Newsletter, Method, Page, JavaScript Function, ASP.NET Programming Paradigm, JavaScript Event, Listing C, Middleware, Software/Web Development, Web Development, Software Development, Enterprise Software, Software

Technical articles 2006-06-19