DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone >

Using Rows.Find In ADO.NET

Rob Lang user avatar by
Rob Lang
·
Mar. 19, 07 · · Code Snippet
Like (0)
Save
Tweet
666 Views

Join the DZone community and get the full member experience.

Join For Free
When using a DataTable in ADO.NET, you may want to search your table given a key. The Find method requires the index of the primary key to find the row that you're looking for. However, before you do this you must set the primary key of the Datatable. Setting the primary key in your database is not enough. To set the primary key, create a new column and then set the primary key field on the Datatable like so:



// Create the DataColumn list for holding the columns of the primary keys. In this case, we are using only one primary key
DataColumn[] primaryKeyColumns = new DataColumn[1];

// Set the first primary key to the column 'id' in the datatable
primaryKeyColumns[0] = myDataTable.Columns["id"];

// Now apply the primary key to the datatable
myDataTable.PrimaryKey = primaryKeyColumns;
ADO.NET

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Is Java Still Relevant?
  • 10 Steps to Become an Outstanding Java Developer
  • 6 Things Startups Can Do to Avoid Tech Debt
  • How to Submit a Post to DZone

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo