How Do I Read Each Row From A Table And Compare With Another Table In Asp.Net(Csharp)

Question

1.00/5 (1 vote)

See more:

Read one row of table emplyee_table with company_table

matching(similar)
EmpID, Name , Amount_ID and year

check the "amount" of each row having same matching EmpID, Name , Amount_ID and year doesn't exceed with company_table "amount"

C#

if the amount of employee_table exceed company_table.. (if e.amt>c.amt)
{
    validatiion- that row will not update
}
else if the amount of employee_table is same  company_table (if e.amt=c.amt)
{
    update that particular row into (company_details_table)
}
else if the amount of employee_table is same  company_table (if e.amt<c.amt)
{
    update that particular row into (company_details_table)
}

Posted 12-Sep-14 19:31pm

10923679

Updated 13-Sep-14 0:40am

George Jonsson

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Sep-14 1:53am

What is the issue here?

10923679 13-Sep-14 1:57am

how to read each row from one table to another ?
and after getting matching fields..
if the amount of employee_table is more then it wont update .
if the amount of employee_table is same of less from amount of company_table
then that particular row will update .

i have update bulk.. but dont how how to update each row...
can you help me with this

George Jonsson 13-Sep-14 6:41am

Is your problem the SQL syntax that should be used to update a row>

10923679 13-Sep-14 7:04am

Yeah i want to know ..

How to read each row and compare with matching Fields with another table

OriginalGriff 13-Sep-14 7:01am

And?
Where are you stuck?
What have you tried?
What help do you need?

10923679 13-Sep-14 7:05am

And i want help here is that..
How to read each row and compare with matching fields with another table..

OriginalGriff 13-Sep-14 7:10am

Yes, I kinda guessed that from the title...
But what have you done so far? There are an enormous number of different ways you could be trying to do this. Are we talking about SQL tables, DataTable, GridView tables, DataGridView Tables, ... the list goes on.

Remember, we can't see your screen, access your HDD, or read your mind - so just repeating what you have told us already doesn't help anybody much!

10923679 13-Sep-14 7:33am

Yeah and i am sorry for that ..

I am using asp.net and sql server .

I want to update fields which has common matching fields with table2 .
If the amount is exceding then it wont update . if same or equal it will update.
I havent done anything yet.
But i want to know how should i do it.
How to read each row of table1 n table2 matchingfields. And update only those fields which has matching fields and amount is less or equal from table2 amount.

I know to update . but it update in bulk using sql server.

But i want to know how to update each row when it find the amount is less or equal from table2

OriginalGriff 13-Sep-14 7:39am

And how do you want to do it?
C#? SQL?

10923679 13-Sep-14 7:55am

Yeah in C#.

OriginalGriff 13-Sep-14 8:36am

So...where is the data? DataReader? DataAdapter? DataTable? DataSet? GridView? DataGridView? Other?

10923679 13-Sep-14 8:46am

In sql server. Database.

Dataset

OriginalGriff 13-Sep-14 8:49am

So why do it in C#?
It's quicker, easier and a lot more efficient to do it in SQL directly - that way the data doesn't have to leave SQL Server. All you need is an UPDATE with a JOIN and a WHILE clause

10923679 13-Sep-14 9:41am

Okay.. But m doing my working in asp.net(csharp)and backend is sql. So i need to write code inside visual studio to do this operation.
It will be in web. Not manually in sq

OriginalGriff 13-Sep-14 10:10am

I think you need to rethink a touch:
There are three parts to this:
HTML / Javascript which runs on the client
C# which runs on the server (sometimes known as the "codebehind")
SQL which runs on a separate server.

If you are coding a new web based app, you want to distribute the processing to the most efficient location: and in this case that's definitely SQL. If you do this in C# then you will be transferring a lot of data around unnecessarily unless you are talking about a single row or two.

I'd set up a stored procedure and do it with that.

10923679 13-Sep-14 10:18am

Alright.
I am working in a web based.. In a LAN it will be..
It will read each row one by one.. There will be many data.. In table1 n table2. Once it find the matching field and check the amount that amout of table1 is not exceeding amount of table 2 then it will update those rows only which has not exceeded the amount.
And it wi update in a another table 3 that column name as verified. That amount is correctly updated to those employee.

10923679 13-Sep-14 7:36am

Sorry for that.. I just want to know how to read each row from table1 finding matching fields from table2 .
If amount is less or equal then update..

I want to know how to update that each row individual.

2 solutions

Solution 1

If SQL commands is your problem you can start here: SQL Tutorial[^]
Update command specifically: SQL UPDATE Statement[^]

For the c# part you should look up MSDN for SqlConnection[^] and SqlCommand[^]

You will find some examples there.

There are plenty of other sources too: C# SqlCommand[^]

Posted 13-Sep-14 2:23am

George Jonsson

Updated 13-Sep-14 2:33am

v2

Comments

10923679 13-Sep-14 8:30am

Thank you. I will go through it.

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)

OriginalGriff · Accepted Answer · 2014-09-13T04:50:00

Alright.
I am working in a web based.. In a LAN it will be..
It will read each row one by one.. There will be many data.. In table1 n table2. Once it find the matching field and check the amount that amout of table1 is not exceeding amount of table 2 then it will update those rows only which has not exceeded the amount.
And it wi update in a another table 3 that column name as verified. That amount is correctly updated to those employee.
Ok, that will be slow. Horribly slow.
Each row fetch involves a lan conversation, processing on the SQL side, data back to C#, processing there, and another conversation back to the SQL server again. If you are doing many rows, that's pretty damn slow.
Do it in SQL.
Set up a transaction, and do two update commands inside it.

Assuming you have three tables:
Table1
id, amt, updates
Table2
id, t1Id, amt
Table3
id, t1Id, verified
Then the two updates are pretty trivial:

SQL

UPDATE t1
SET t1.updates = t1.updates + 1
FROM Table1 t1
JOIN Table2 t2 ON t1.id = t2.t1Id
JOIN Table3 t3 ON t1.id = t3.t1Id
WHERE t1.amt < t2.amt

And

SQL

UPDATE t3
SET t3.verified = 'Yes'
FROM Table1 t1
JOIN Table2 t2 ON t1.id = t2.t1Id
JOIN Table3 t3 ON t1.id = t3.t1Id
WHERE t1.amt < t2.amt

Will let SQL work out the most efficient way to do that - and it's pretty good at it!

I'd set up an SP, containing those two inside a transaction (so if it fails there is nothing changed) and just execute that from the C#.
Nothing leaves SQL, and the processing is done by the software that's best at it.