Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Passion for collaboration...
- Passion for collaboration...blog rootSharePointIs not a great collaboration tool, from Microsoft?Custom List: Microsoft OfficeMicrosoft OfficeAccess 2000 Macros: Access 2000 MacrosAccess Errors: Access ErrorsProgramming MS Access: Programming MS AccessRecursos para MS Access: Recursos para MS AccessTroubleshooting Microsoft Access: Troubleshooting Microsoft AccessUsing Macros With Access: Using Macros With AccessAccess 2003 Convertion Analyze...
- Tags: Databases, luis.dusolier@..., collaboration, Microsoft Access, Microsoft Corp., Microsoft Office
- Discussion threads 2005-09-14
- 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
- Which dataset should you choose?
- The choice between untyped and typed datasets rests in the hands of the developer. Examine the differences between the two. I've recently noticed some confusion among coworkers and clients regarding dataset options. This confusion stems from the fact that a dataset may or may not...
- Tags: Tony Patton, .NET, Programming languages, cntString, strSQL, dataset, Console.WriteLine, SqlConnection, Nothing, developer, .NET Newsletter, Microsoft Visual Studio, TechRepublic Inc., Database, Microsoft Visual Studio.Net, XML Schema, Class, Column, Dataset1, Microsoft Development Tools, XML, Development Tools, Software Development, Software/Web Development, Web Development
- Technical articles 2005-06-28
- what is the best driver for SQL
- For a VB front end and a SQL 7 back end what driver is best for the connection string..there are so many OLE DB choices.The SQL Server books say use:Provider= SQLOLEDB orProvider = MSDASQLI'm confused and the text is overwhelming. Can someone break it down for me. I used to...
- Tags: ADO, ma407@..., MSDASQL, ODBC, programming, server, SQL, SQLOLEDB
- Q&A 2005-03-21
- Methods for deploying data to disconnected .NET applications
- By Tim LandgraveOne of the most common questions asked during .NET architecture presentations involves the need for persisting data locally in a distributed application. Such questions usually focus on using data sets as a local persistence mechanism and Web services as the downloading and synchronization mechanism. I caution architects to...
- Tags: Databases, Enterprise software, Storage, e Advantage, Microsoft .NET, Microsoft Corp., Microsoft SQL Server, database, Microsoft Data Engine, Microsoft SQL Server 2000, server
- Technical articles 2003-04-02
- Easily create custom Web services with .NET
- The .NET platform greatly simplifies theprocess of creating and using custom Web services. In thisarticle, I'll show you how to develop your own service thatreturns data from a backend data source. The components The System.Web.Services namespace provides thenecessary classes for creating custom Web services....
- Tags: database, Web, Web service, Tony Patton, Microsoft .NET
- Technical articles 2005-07-12
- Storing database connection settings in .NET
- .NET database providers make it necessary to specify database connection information, but it's the developer's discretion to decide where to store this information. Tony Patton explores the various factors that may influence your decision. One of the best aspects of the .NET...
- Tags: Microsoft .NET, XML, Storage, Databases, Tony Patton, .NET, Programming languages, sConn, SqlConnection, database, .NET Newsletter, Registry, TechRepublic Inc., Problem, Server, Microsoft.Win32, regKey, ToString, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2005-07-13
- Dive into .NET with Web Matrix
- ASP.NET Web Matrix is a free download that lets you create ASP.NET Web applications, services, etc. Here's an overview of Web Matrix, as well as the steps you need to take to create a .NET Web solution using Web Matrix. Microsoft is tipping the scales in...
- Tags: Microsoft .NET, Microsoft Corp., Phillip Perkins, .NET, C#, Microsoft development tools, Programming languages, Middleware, wizard, Web-Matrix, MyDataClass, Web Development Zone Newsletter, Method, Web, Microsoft .NET Framework, Database, Microsoft ASP.NET, Web Service, Class, Microsoft IIS Server, ASP.NET Web Matrix, SELECT, Channel Management, Marketing, Software Development, Software/Web Development
- Technical articles 2005-08-04
- << Previous
- page 1 of 1
- Next >>
