comparing textbox values with database values

Question

3.00/5 (4 votes)

See more:

i am using the following method to compare my forms textbox values with database values id they are same or not before updating.If they are not same i have to perform certain operations.But i have many many fields in table and i dont want to write the following code for every field.its getting very lengthy.I want to compare them using a very short code using looping..using a function etc..
Please help me..

C#

if (!String.Equals(txtMobile.Text.Trim(), objdatarow["MobileNo"].ToString().Trim(), StringComparison.Ordinal))
               {
                   mailstr.Add("MobileNo:-" + txtAddress.Text.Trim());
                   NewString.Add(txtMobile.Text.Trim());
                   old.Add(objdatarow["MobileNo"].ToString().Trim());
               }

Posted 15-Mar-14 0:52am

pwavell

Add a Solution

Comments

OriginalGriff 15-Mar-14 7:02am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
I can't see anything there that could be looped - so probably you need to provide a better example?
Use the "Improve question" widget to edit your question and provide better information.

OriginalGriff 15-Mar-14 7:10am

Down vote compensated...

2 solutions

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)

ZurdoDev · Answer 1 · 2014-03-15T02:50:00

If you named your textboxes the same as the names of your database fields you can do a foreach on Form.Controls and check the ID or even use FindControl.

However, I would not recommend this method. It may be a pain to do them individually but I still think you are better off doing them individually. It will be easier to find bugs if a particular field does not work and if you later have to add some specific logic for a field it would be more readable.

Maciej Los · Answer 2 · 2014-03-15T03:12:00

Do not comapre values on client side. Do it on server side, using stored procedure[^] (SP).

SQL

CREATE PROCEDURE UpdateWhenDiffer
    @MobileNo VARCHAR(30),
    @MyKey INT
AS
BEGIN
    UPDATE MyTable SET MobileNo = @MobileNo
    WHERE ID = @MyKey AND MobileNo<>@MobileNo

END

For further information, please see:
Modifying Data with Stored Procedures[^]
How to: Execute a Stored Procedure that Returns a Single Value[^]

The reason i suggest you to use SP is SQL Injection[^].
How To: Protect From SQL Injection in ASP.NET[^]
Stop SQL Injection Attacks Before They Stop You[^]
SQL Injection and how to avoid it[^]

comparing textbox values with database values

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0