Easy ADO.net question

  • Thread starter Thread starter Jonathan Miller
  • Start date Start date
J

Jonathan Miller

I'm a bit new to ADO.net, so here's my setup. I'm programming in vb.net I have a strongly typed dataset with sqlserver data in it. I want to edit a row in a table by referring to it by its' primary key. How the heck do I do that? dataset.strongtablename.item(primary key) = somedata This is how I think it should work, but it doesn't, the item collection does'nt care about the primary key and its read only! This seems like such a simple task, any help would be greatly appreciated!
 
Jonathan,

You can use the Find method to locate the row.

HTH,

--
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com

Jonathan Miller said:
I'm a bit new to ADO.net, so here's my setup. I'm programming in vb.net
Click to expand...
I have a strongly typed dataset with sqlserver data in it. I want to edit a
row in a table by referring to it by its' primary key. How the heck do I do
that? dataset.strongtablename.item(primary key) = somedata This is how I
think it should work, but it doesn't, the item collection does'nt care about
the primary key and its read only! This seems like such a simple task, any
help would be greatly appreciated!
 
Back
Top