search and update data

[Nhan]

Hi,
I am beginer in ADO.Net, have such a problem.
I want to search for a row of a table or query then update data of this row.
With which ADO.net classes can I do this? An equivalent to ADO recordset
object!

The System.Data.Dataview can search, delete. Can it also update data?
With DataTable can I access a DataRow and update, but what is with
searching?

Thanks
Nhan

 

[William Vaughn]

I think it would help to start reading about ADO.NET. There are a dozen
books available on the subject. Actually, Visual Studio will do most of the
work for you when working with simple databases. The Data Source code
generator can fetch entire tables, assist in filtering the data using
parameter queries, and permit you to bind to controls to display and update
the data. Again there are a host of books out there that describe how this
is done--even mine.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[Nhan]

Thanks for your advise.

I have read some books about ado.net. Yes.
But in these gut books (also from MSDN) I can find the informations, what I
need.
- I have learn, with DataView I can search records, filter, delete, add new
...., but not about update.
- some things with DataTable, DataRow for updating.

I can with DataView search a record (or filter), and then use an another
DataTable and Datarow for updating, but how can I move the cursor to the the
needed record or how can I get the needed Row?

You can tell me shortly, without code, without details.

Thanks

 

[Nhan]

again,
I can also execute a store procedure or a update query. But I must call the
code for each record.

 

[Petar Atanasov]

Thanks for your advise.

I have read some books about ado.net. Yes.
But in these gut books (also from MSDN) I can find the informations, what I
need.
- I have learn, with DataView I can search records, filter, delete, add new
..., but not about update.
- some things with DataTable, DataRow for updating.

I can with DataView search a record (or filter), and then use an another
DataTable and Datarow for updating, but how can I move the cursor to the the
needed record or how can I get the needed Row?

You can tell me shortly, without code, without details.

Thanks

Nhan,
Check out this link:
http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/UpdateDataFromDB.aspx

Regards,
Petar Atanasov
http://a-wake.net