ASP.NET Letter sending application to different users.

Question

1.00/5 (2 votes)

See more:

I am developing an asp.net application which send letters to different users.

I have created one sql table in which letters is stored(letter can be sent to more than one users at the same time) .

i have implemented but the the problem is when i m storing letter in DB i set its status "Unread".

when user open his profile unread letters for particular user is shown but when he mark the status as "READ" then the status updated to all users AS "READ" in DB.... and others cannot view their letters...

kindly propse a solution for that problem
THANKS in advance!

Posted 29-May-15 3:37am

Member 10426884

Updated 29-May-15 3:52am

Andy Lanng

v2

Add a Solution

Comments

[no name] 29-May-15 9:44am

You need to add a where clause to your query.

Prasad Avunoori 29-May-15 9:46am

Hi,
check your SQL Update statement. I think you missed to write WHEREcondition.

Muhammad Maaz 29-May-15 10:39am

Users should be able to view their letters in any case Read or Unread and secondly you have to narrow down your update statement for a particular user so that it may not effect other users' letters.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2015-05-29T04:31:00

Solution 1

So, it seems like when you are updating, you forgot to add the condition for the particular user.

You need to form the query like below.

SQL

UPDATE Letter
SET Status = 'READ'
WHERE UserId = @UserId

Here @UserId is the parameter. You should provide the current UserId value to it.

Posted 29-May-15 4:31am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Sergey Alexandrovich Kryukov 29-May-15 10:45am

May be your answer is correct, but I'm looking at it in amazement: how do you know what the inquirer wrote? Nothing is shown in the question.
—SA

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 29-May-15 23:40pm

Haha. We have faced this kind of issues many times. I have seen one instance, when one of colleagues updated all phrase translation records instead of one due to no "where" condition. :)