
	Home > Microsoft .Net Development Tips > .NET Developer > Basic ADO.NET operations

Win Development Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

.NET DEVELOPER

Basic ADO.NET operations

Yateen Thakkar
11.27.2002
Rating: -4.29- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

Let other users know how useful this tip is by rating it below. Got a tip or code of your own you'd like to share? Submit it here!

Let's see how we can perform the common database tasks like Insert, Update and Delete with ADO.NET. We'll be using the ADO.NET Data Adapter to perform the following tasks. Let's see how it is done.

The Database table has two fields, ID and Name.

Insert a new row

For the Update and t...

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	.NET Developer
	How to speed up Visual Studio 2008's slow WPF designer
	How to list fonts in WPF using markup extensions and data templates
	How to convince management to buy Microsoft Visual Studio 2008
	Microsoft webcast series previews new Visual Studio 2010 features
	New features in Windows 7 bring new UI considerations for developers
	User Account Control (UAC): How to develop code for standard users
	Introduction to Vista's user account control (UAC) for developers
	Visual Studio 2008 code metrics tools will help keep code clean
	Downloadable MSDN library released for VS 2008 SP 1
	Widgetbox provides good example of how to use Facebook Developer Toolkit

ADO.NET development

Using the Visual Studio 2005 DataSet Designer to build a data access layer

The fallacy of the data layer -- or, a new architectural model for software designs

ADO.NET Entity Framework Beta 3 ships; ups LINQ-to-SQL performance

Book excerpt: ADO.NET and SQL Server 2005

SearchVB.com's Podcast Page

Podcast: An introduction to Microsoft Astoria

Microsoft Project Astoria brings data services to Web API battle

Book excerpt: Data sources and datasets in ADO.NET 2.0

Book excerpt: An introduction to ADO.NET 2.0

What's ahead for ADO.NET in Visual Studio Orcas

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

he Delete operations to work, the database table you are working with requires a Primary Key to be present.

Update a row

Delete a row

There you go. I needed to do this for a particular project I was working on, and I couldn't find a single working code on the Internet. My colleagues and I had to spend a few hours to do this. I hope this will save your time. Happy coding!

Source: DotNetExtreme.com

Rate this Tip
To rate tips, you must be a member of SearchWinDevelopment.com. Register now to start rating these tips. Log in if you are already a member.
Submit a Tip

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Database Programming Solutions - .NET XML, Visual Studio LINQ, ORM .NET

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2000 - 2009, TechTarget \| Read our Privacy Policy