detecting column to be updated

Question

0.00/5 (No votes)

See more:

Hi all,

I have this question....
there are many text boxes in a page...if i change the value of only one text box(any text box) to update database, how can i detect which column to update???in short how can i detect that particular text box??or do i have to update all columns with all text boxes everytime i change only one text box value??

Regards and thanks....

Posted 27-Aug-13 21:51pm

planetz

Add a Solution

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)

_Asif_ · Answer 1 · 2013-08-28T00:51:00

This is an application design problem. If you are using a ORMapper tool that most of the tool itself handle this problem. If you are not using any OR mapping tool than you have to implement that level of inteligence at your Data access layer. DAL usually check which columns have been changed (may be a flag at each field) and generate update sql based on the changed field.

Hoping this should given you insight of the problem

Anand Kumar Prajapati · Answer 2 · 2013-08-28T00:34:00

Solution 1

My Friend, you haven't told that which control you are using (like GridView, ListView etc.)

well take a look at FindControl inside Editable GridView[^]

might be helpful :)

Posted 28-Aug-13 0:34am

Anand Kumar Prajapati