select and update using ADO.NET

ALI-R

I am going to select buch of rows from database and update a field in them
,is there a good way of doing that ?

thanks for your help.
Ali-R

Nov 16 '05 #1

Subscribe Post Reply

1107

Octavio Telis Aynes

Well... Why not to try an Update command

Or if you could be a bit specific... to know well the question.

See you...

Octavio Telis Aynés
www.comunidadpuntonet.org/df/

"ALI-R" <al*@microsoft.com> escribió en el mensaje
news:O8**************@TK2MSFTNGP11.phx.gbl...

I am going to select buch of rows from database and update a field in them
,is there a good way of doing that ?

thanks for your help.
Ali-R

Nov 16 '05 #2

ALI-R

I have a table of alerts which has a column called "Viewed"(default is 0
which means ,row hasn't been viewed) ,I want to show alerts for an specific
user and then update "viewed" column to 1 (which means that alert has been
viewed).

thanks for your help.
Ali-R

"Octavio Telis Aynes" <ot****@NOSPAMtutordes.com> wrote in message
news:e7**************@TK2MSFTNGP14.phx.gbl...

Well... Why not to try an Update command

Or if you could be a bit specific... to know well the question.

See you...

Octavio Telis Aynés
www.comunidadpuntonet.org/df/

"ALI-R" <al*@microsoft.com> escribió en el mensaje
news:O8**************@TK2MSFTNGP11.phx.gbl...
I am going to select buch of rows from database and update a field in them ,is there a good way of doing that ?

thanks for your help.
Ali-R

Nov 16 '05 #3

Similar topics

Select .. for update question

by: jayson_13 | last post by:

Hi, I need to implement a counter and i face problem of locking so hope that u guys can help me. I try to do test like this : 1st connection SELECT * FROM nextkey WHERE tblname = 'PLCN'...

MySQL Database

SELECT works but UPDATE fails. ?

by: kalamos | last post by:

This statement fails update ded_temp a set a.balance = (select sum(b.ln_amt) from ded_temp b where a.cust_no = b.cust_no and a.ded_type_cd = b.ded_type_cd and a.chk_no = b.chk_no group by...

Microsoft SQL Server

Deadlock. Referential Integrity checks select for update?

by: Grant McLean | last post by:

Hi First a simple question ... I have a table "access_log" that has foreign keys "app_id" and "app_user_id" that reference the "application_type" and "app_user" tables. When I insert into...

PostgreSQL Database

ASP Type mismatch error with SELECT...FOR UPDATE statement

by: Steve | last post by:

ASP error number 13 - Type mismatch with SELECT...FOR UPDATE statement I got ASP error number 13 when I use the SELECT...FOR UPDATE statement as below. However, if I use SELECT statement without...

ASP / Active Server Pages

Regarding Update/select Query

by: parwal.sandeep | last post by:

Hello grp! i'm using INNODB tables which are using frequently . if i fire a SELECT query which fetch major part of table it usually take 10-20 seconds to complete. in mean time if any UPDATE...

MySQL Database

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp