System.Data.SqlClient.SqlConnection Class
Information   Base Types   Related Resources

Represents an open connection to a SQL Server database. This class cannot be inherited.

  • Namespace: System.Data.SqlClient
  • First seen in: .NET v1.0.3705
  • Last seen in: .NET v1.1.4322
  • Last changed in: .NET v1.1.4322
  • Assembly: System.Data.dll

  • System.ComponentModel.Component
  • View this type on MSDN
  • View this type on WinFX 247
    Articles (367)Discussions (3061)MembersRotorChanges
    Articles

    Page: 123456789101112131415
    "Can't create a child list" error message when you open a form in Visual Studio .NET
    Microsoft Support
    (816799) - When you delete the table that is bound to a control form of the DataSet Schema and then save the project in Microsoft Visual Studio .NET, you may receive the following error message when you open the form in Design view: Can't create a child list for...
    "Can't create a child list" error message when you open a form in Visual Studio .NET
    Microsoft Support
    (816799) - When you delete the table that is bound to a control form of the DataSet Schema and then save the project in Microsoft Visual Studio .NET, you may receive the following error message when you open the form in Design view: Can't create a child list for...
    "Can't create a child list" error message when you open a form in Visual Studio .NET
    http://www.kbalertz.com/
    (816799) - When you delete the table that is bound to a control form of the DataSet Schema and then save the project in Microsoft Visual Studio .NET, you may receive the following error message when you open the form in Design view: Can't create a child list for...
    .NET Anatomy - ADO.NET in Beta2 : Part 1
    DotNetJunkies
    This article reviews the ADO.NET object model found in Microsoft’s .NET Framework Beta2. The information presented here will be useful both to programmers who worked with Beta1 and also, to those just starting with the framework.
    .NET Anatomy - ADO.NET in Beta2 : Part 2
    DotNetJunkies
    In my last article I reviewed the ADO.NET object model as it is presented in the .NET framework Beta2. To put this information to practical use, this article will provide a walkthrough of how to use Microsoft's newest set of developer tools, found in Visual Studio.NET to create a working Web Application that accesses an SQL database.
    .NET Anatomy - Data Concurrency in ADO.NET, Part II
    DotNetJunkies
    This is the second article in a series covering the subject of Concurrency in ADO .NET. Concurrency is the method by which many users are able access and change the same data simultaneously without being concerned that they are overwriting each others work.
    .NET Anatomy - Data Concurrency in ADO.NET, Part II
    DotNetJunkies
    This is the second article in a series covering the subject of Concurrency in ADO .NET. Concurrency is the method by which many users are able access and change the same data simultaneously without being concerned that they are overwriting each others work. The architects of the .NET Framework made a design decision that the DataSet object assumes that Optimistic Concurrency as the default method of concurrency.
    .NET Anatomy - Data Concurrency in ADO.NET, Part III
    DotNetJunkies
    In the two previous articles on this subject we have looked at how the ADO.NET DataSet object contains built-in support for concurrency operations. This functionality helps the developer to build applications that keep users from overwriting each other’s data accidentally. The implementation is open and flexible and so what I will be showing you here can be tailored to your own requirements
    .NET Distributed Transactions on Enterprise Services: a demo
    The Code Project
    This demo shows you how to develop .NET components capable of participating in distributed transactions coordinated by .NET Enterprise Services
    .NET Remoting ( A Simple Approach)
    C# Help
    .NET Remoting provides a powerful and high performance way of working with remote objects. Architecturally, .NET Remote objects are a perfect fit for accessing resources across the network without the overhead posed by SOAP based WebServices. .NET Remoting is easier to use than Java's RMI, but definately more difficult than creating a WebService. In this article, we will create a remote object that will return rows from a database table. For the sake of simplicity i have used the NorthWind database that is packed with the installation of the Microsoft SQL Server.
    .NET Remoting - The Interface Approach
    C# Help
    In this article, we will create a remote object, and access this object using an interface. This method is important when creating a physical separation between business tier and consumer code. In traditional Remoting approaches, to access a remote object, you need a copy of that object on the client machine. With this approach, the metadata is split into a separate library that can be copied to the client machine.
    A First Look at ObjectSpaces in Visual Studio "Whidbey"
    MSDN
    An interesting new feature in Visual Studio "Whidbey" is ObjectSpaces, an Object/Relational mapping tool fully integrated with ADO.NET. You design application features using objects, and ObjectSpaces reads and writes to data sources using SQL statements.
    A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 3
    The Code Project
    The purpose of this document is to provide a practical guide to using Microsoft’s .NET DataTables, DataSets and DataGrid
    A Remedy for DataGrid Vertigo
    DotNetJunkies
    The AlternatingItemStyle can be a wonderful thing. But in many cases I found that I would start to get a feeling like vertigo if I scrolled the page up or down. So I thought back to my days in Manhattan in the financial industry and remembered how I used to prepare reports to be viewed on screen. I alternated the colors of the rows, but I did it every three or five rows (depending on the width of the report, the content of the report, or my own aesthetic taste).
    A Reusable, Flexible Error Reporting Framework
    The Code Project
    Using configuration classes and simple implementation, this library allows your applications a flexible method of reporting errors that happen. Included is a Windows XP-like WinForms UI that allows users the ability of opting for error reporting in WinForms applications.
    Abstracting ADO .NET
    MSDN
    With the release of Microsoft® .NET just around the corner, developers are gearing up to take advantage ot the many features, increased interoperability, and better data integration that the new framework promotes. While COM and Visual Basic® 6.0 are still widely used and will likely live on for years to come, I've met many developers who are anxious to get moving with the .NET components. Some of the questions I am asked most often regarding .NET are how developing with ActiveX Data Objects (ADO) 2.x will change under ADO .NET and how can you still abstract ADO into a data service component. So, in this month's Data Points column, I'll try to tackle these issues.
    Accessing Data From SQL Server
    C# Help
    Among the many things that are changing with .NET is data access. Under the .NET Framework, data access is handled by a set of classes called ADO.NET which are essentially an augmentation of the existing ActiveX Data Objects (ADO).
    Accessing Web Services from Windows Client
    C#Today
    Over the last several years, we have seen the Internet evolve from delivering static and simple HTML pages, into using dynamic, programmable and reusable web components. Microsoft's .NET framework introduces Web Services and SOAP that take the Internet a step further, by allowing the web applications to be more distributable, reusable and resourceful. In this article, Ravi Venkatarajalu look at how to combine the features of Web Services, SOAP and the .NET framework with Microsoft Excel 2000. We will also see how to serialize a Dataset and send it as part of a HTTP Request to a Web Service.
    Adding a "Totals" Field in a DataGrid
    DotNetJunkies
    Lately one of the questions that has been popping up a lot is, "How do I show column totals in a DataGrid?" Personally I have provided sample code for this question more than a few times, so I thought it would only be appropriate that we here at DotNetJunkies HQ get a tutorial up on the topic.
    Adding a Blank Row to a DataGrid (Used to INSERT rather than UPDATE)
    DotNetJunkies
    In this article we will be illustrating one way to add a blank row to a DataGrid. Why would you want to do this? Who knows, maybe to enable a user to add a new record. This article will show you how to add a new row to a DataGrid by manipulating its DataSource - in this example a DataTable. Note that we will be simulating saving the new item back to the database.
    Adding a Default ListItem in a Databound Listbox in ASP.NET
    4Guys from Rolla
    In a previous article I showed how to use databinding to automagically populate an ASP.NET's listbox Web control with just a few lines of code. (If you've not already read the past article, be sure to do so now.) I've received a couple of feedback emails from folks since publishing the article asking how to add a default option to the listbox. That is, they want to add a listitem to the listbox, like: -- Please Choose an Option Below--. In this brief article we'll tackle this topic and more!
    Adding a Totals Field in a DataGrid
    DotNetJunkies
    In this tutorial Doug shows you how to programmatically sum the values of a column in a DataGrid, and display that total in the footer of the DataGrid.
    ADO.NET 101: SQL Connection
    The Code Project
    A tutorial on connecting to SQL 2000 Server
    ADO.NET 2.0 Feature Matrix
    MSDN
    ADO.NET 2.0 includes a new base-class provider model, features for all providers, and changes to System.Data.SqlClient. Get an overview of these new features, examples of their use, and a chart of which features are provider-neutral and SqlClient-specific.
    ADO.NET DataSet vs. ADO RecordSet Speed Tests
    Egg Head Cafe
    Comparitive performance tests between "old school" ADO RecordSets and new ADO.NET DataSets.
    Ad
    MBR BootFX
    Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT
     
     Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
    Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com