datatable update query

Hi all,
Is it possible to update a selected row of a datatable ?
I do not want to update the whole table just one maybe two at a time.
Thank You.

[Andrew Kirillov]

Hello

So, what is the problem ? You don't know how to make it in .NET (C#) or you
are not familiar with SQL ?

UPDATE tbMyTable SET fname='....', sname='...' WHERE id=9
will update only records with id equal to 9.

--
With best regards,
Andrew

http://www.codeproject.com/script/pr...asp?id=1181072
<Co**********@al.com> wrote in message
news:Vs****************@newsfe3-gui.ntli.net...

Hi all,
Is it possible to update a selected row of a datatable ?
I do not want to update the whole table just one maybe two at a time.
Thank You.

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

just explain further, it's not clear what you want.
You have access to each row using DataTable.Rows[0]["Column1"]

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
<Co**********@al.com> wrote in message
news:Vs****************@newsfe3-gui.ntli.net...

Hi all,
Is it possible to update a selected row of a datatable ?
I do not want to update the whole table just one maybe two at a time.
Thank You.