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

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"  wrote in message 
news:Owk4GcM5HHA.1212@TK2MSFTNGP05.phx.gbl...

> 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
>
>
>
> 

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

"William Vaughn"  wrote in message 
news:ecow6nN5HHA.4712@TK2MSFTNGP04.phx.gbl...

>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"  wrote in message 
> news:Owk4GcM5HHA.1212@TK2MSFTNGP05.phx.gbl...
>> 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
>>
>>
>>
>>
> 

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


"William Vaughn"  wrote in message 
news:ecow6nN5HHA.4712@TK2MSFTNGP04.phx.gbl...

>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"  wrote in message 
> news:Owk4GcM5HHA.1212@TK2MSFTNGP05.phx.gbl...
>> 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
>>
>>
>>
>>
> 

Nhan wrote:

> 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
> 
> "William Vaughn"  wrote in message 
> news:ecow6nN5HHA.4712@TK2MSFTNGP04.phx.gbl...
>> 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"  wrote in message 
>> news:Owk4GcM5HHA.1212@TK2MSFTNGP05.phx.gbl...
>>> 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
>>>
>>>
>>>
>>>
> 
> 


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

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