system.data.sqlclient

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

ADO.NET database access made easy

ADO.NET and ADO are quite different in many areas, such as connection classes, commands, and data readers. But don't get them confused. This introduction to ADO.NET should help set you off on the right foot.Although ADO.NET and ADO share some common concepts, they are different enough in many areas to...

Tags: .NET, Databases, System.Data, Lamont Adams, Microsoft .NET Framework, System.Data.SqlTypes, System.Data.OleDb, System.Data.SqlClient, Microsoft ADO.NET, connection class, Microsoft SQL Server, OLE-DB data source, SqlClient, OLEDB, database

Technical articles 2002-12-16

Additional Resources

Exploit new data access functionality in SQL Server 2005

Developers who use the SQL server and the .NET framework, regardless of whether they are accessing data from the client, middle tier, or server, use the SqlClient data provider. The latest release of SqlClient, installed with .NET Framework 2.0, includes new functionality to take advantage of innovations in SQL Server...

Tags: Microsoft SQL Server, Data Access, Microsoft SQL Server 2005, Addison-Wesley, Databases, Enterprise Software, Software, Data Management

Book chapters 2006-06-12

MSDN Webcast: SQL Server 2005 Essentials: SqlClient and the New Data Types (Part 12 of 14) (Level 200)

With the advent of new features in Microsoft SQL Server 2005 due to the inclusion of the Common Language Runtime CLR and improved XML support, the client Application Programming Interfaces APIs must be enhanced to make use of the new features. This twelfth webcast of a 14-part series on SQL...

Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Digital Media, Databases, Enterprise Software, Consumer Electronics, Personal Technology, Software, Data Management

Webcasts

How do I capture a row adding event in a datagrid?

I am loading data from an sql database into a grid. I want to be able to add rows to the data and save them back to the database. I am able to do that right now but want I want to do is to have some of the data...

Tags: .NET, Databases, Programming languages, judyv@..., new row, grid

Discussion threads 2007-08-15

MSDN Webcast: ADO.NET 2.0 and MARS (Level 200)

This webcast focuses on using MARS from ADO.NET 2.0 with the SQLClient .NET Data Provider included with version 2.0 of the Microsoft .NET Framework. The webcast shows how to use MARS to execute multiple commands and open multiple data readers on a single connection.

Tags: Microsoft Developer Network, Webcast, Microsoft ADO.NET, .Net, Digital Media, Databases, Software Development, Software/Web Development, Consumer Electronics, Personal Technology, Enterprise Software, Software, Data Management

Webcasts

Open SqlClient connection .NET/ Win CE

I have a program that is written in .NET that is used in a Windows CE Pocket PC. The problem I am having is openening a sql connection to my sql 2000 database. I believe the issue is because the server that is running sql is svr 2003...

Tags: Programming languages, Databases, Walkerxp92, SQL

Discussion threads 2005-10-26

ADO.NET Web App Stops Trying To Reach SQL Database

We have an ASP.NET app on our internet server (IIS 6) that displays data (company news headlines, etc) from a SQL Server behind our firewall, using the SQLClient objects.Several times now we've had a situation where the SQL Server became unavailable for a length of time, once when we upgraded...

Tags: asp.net, database, iis, Microsoft ADO.NET, Microsoft IIS Server, Microsoft SQL Server, programming, server, Underground_In_TN

Discussion threads 2005-11-16

ADO.NET App Stops Trying To Reach SQL DB

We have an ASP.NET app on our internet server (IIS 6) that displays data (company news headlines, etc) from a SQL Server behind our firewall, using the SQLClient objects.Several times now we've had a situation where the SQL Server became unavailable for a length of time, once when we upgraded...

Tags: Microsoft ADO.NET, Microsoft IIS Server, Microsoft SQL Server, programming, server, Underground_In_TN

Q&A 2005-11-17

Implementing SQL Server transactions with ADO.NET

ADO.NET provides everything you need to workwith back-end data, which can be as simple as reading a set of datafrom one table to performing a transaction. A transaction allowsyou to group database operations to ensure that all the operationsare performed because, if one operation fails, the wholetransaction fails. Let's take...

Tags: banking, Microsoft ADO.NET, server, SQL, Tony Patton

Technical articles 2005-06-30

Implementing SQL Server transactions with ADO.NET

A transaction is a group of operations combined into a logical unit of work. Learn how to use transactions within the .NET Framework. ADO.NET provides everything you need to work with back-end data, which can be as simple as reading a set of...

Tags: Microsoft ADO.NET, Databases, Tony Patton, .NET, System.Data.SqlClient namespace, banking, IsolationLevel property, SQL, server, .NET Newsletter, TechRepublic Inc., Transaction, Microsoft SQL Server, IsolationLevel, Storage, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware

Technical articles 2005-06-30

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

Meter Data Management: The Soul of the New Utility

Properly managed meter data enables utilities to predict system load and usage to avoid imbalances and reduce off-network purchases. Data analysis can help pinpoint over- or under-utilized infrastructure, improve system throughput, speed service restoration after outages, and more. This paper will discuss strategies for implementing a centralized meter data management...

Tags: Itron, Data Management, Storage, Databases, Hardware, Enterprise Software, Software

White papers 2004-11-01

Database design: Development and implementation of a master data management system

The key facet of the master data management system MDMS is to have a single system as a point of reference for all commonly used items of data within a company. Each consumer system could then refer to this system for its key data ensuring common and correct data across...

Tags: TechRepublic Inc., Data Management, Storage, Databases, Hardware, Enterprise Software, Software

Download resources 2005-02-03

Implementing Highly Available Data Protection With Veritas NetBackup

The data protection system must be regarded as a 'mission critical' element of any modern data center. The design of any data protection system must, as far as possible, eliminate single points of failure so that data can be recovered to an acceptable state and point in time in the...

Tags: Data Protection, VERITAS Software Corp., VERITAS NetBackup, Data Protection System, Disaster Recovery, Backups, Data Management

White papers 2008-01-01

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

Remote Data Logging System Using GPRS Wireless Link

This paper describes a system to log data, measured remotely with dataTaker data loggers, to a base station computer. This means that while the dataTaker data logger is logging data, the data or a subset can simultaneously be viewed from anywhere in the world. The General Packet Radio Service GPRS...

Tags: GPRS, Cellular Phones, Consumer Electronics, Personal Technology

White papers 2005-06-22

Build a data-bound grid with C# and ADO.NET

Data access is the basis of any application. In thisarticle, I will show you how to access SQL Server-based data using C# andADO.NET, as well as how to display the data in a data-bound grid control. I usea simple C# application as an example.ADO.NET architectureADO.NET allows you to work without...

Tags: C#, data access, data source, grid, Irina Medvinskaya, Microsoft ADO.NET, Microsoft SQL Server, namespace, server

Technical articles 2006-08-30

Connection String for SQL SERVER

System.Data.SqlClient.SqlException: Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.I m getting this error while establish the connection at the back-end.This error occurs because by default SQL 2000 does not support SQL Server authentication and supports only Windows authentication. To overcome this limitation:- Enter...

Tags: Microsoft SQL Server, programming, server, SQL, svkravi@..., YOURDATABASE, YOURSERVER

Q&A 2005-02-08

Architecture, Performance, and Scalability of a Real-Time Global Positioning System Data Grid

This paper describes the architecture of the real time SensorGrid system, which supports the real-time message routing and processing of Global Positioning System data. The current system processes 1 Hz position data from 85 stations in southern and central California. This system is built on a computer network-enabled, topic-based publish/subscribe...

Tags: Performance, Scalability, Grid, Indiana University, GPS, Performance Management, Handhelds, Consumer Electronics, Personal Technology, Human Resources, Workforce Management, Hardware

White papers 2007-02-23

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