writing data in sqlserver 2008 - How to insert data in an existing row

Question

2.00/5 (4 votes)

See more:

C#

How to insert data in an existing row using parameter

Posted 11-May-12 5:12am

Member 8961685

Add a Solution

Comments

Sergey Alexandrovich Kryukov 11-May-12 13:29pm

"Insert" and "existing" are mutually exclusive. You can "modify".
--SA

3 solutions

Solution 3

insert data in an existing row using parameter
Looks like you asked for parameter based data insert/update.

Look here for parameterized query and it's usage:
MSDN: Configuring Parameters and Parameter Data Types (ADO.NET)[^]
MSDN: DataAdapter Parameters (ADO.NET)[^]
MSDN: SqlCommand.Parameters Property [^]

Read about protecting from SQL Injection here: SQL Injection Mitigation: Using Parameterized Queries[^]

Posted 11-May-12 6:42am

Sandeep Mewara

Comments

Maciej Los 11-May-12 12:56pm

Good answer, my 5!

Sandeep Mewara 11-May-12 13:07pm

Thanks.

Wendelius 11-May-12 13:59pm

Very good list!

Sandeep Mewara 12-May-12 2:00am

Thanks Mika.

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)

Wendelius · Accepted Answer · 2012-05-11T05:20:00

Solution 2

Here's one good tutorial you can go through: SQL UPDATE Statement[^]

Addition:

To update the last row based on column DateCol the statement could be something like:

SQL

UPDATE table 
SET ColumnA = @_ColumnA 
WHERE firstname LIKE @_firstname
AND DateCol = (SELECT MAX(DateCol)
               FROM table
               WHERE firstname LIKE @_firstname)

Posted 11-May-12 5:20am

Wendelius

Updated 11-May-12 6:51am

v2

Comments

Maciej Los 11-May-12 11:21am

Good answer and link, my 5!

Wendelius 11-May-12 11:28am

Thanks losmac :)

Member 8961685 11-May-12 12:41pm

Thank you Mika, there is no primary key or unique key on this table , here is the code i am using
cmdScnDesc = new SqlCommand("UPDATE table SET ColumnA = @_ColumnA WHERE firstname LIKE @_firstname ",dbConnection);
but the problem its inserting into all rows but i like to update only the last row

Wendelius 11-May-12 12:49pm

You could define the condition to your statement to update only the last row. For example if you have a date column which defines what is the last row, then use the MAX value of that column (per name).

However, I would strongly advice you to use a primary key, for example uniqueidentifier[^]

Member 8961685 11-May-12 13:17pm

Thank Mila , if i have the uniqueidentifier then how do i update the specific field

Wendelius 11-May-12 13:57pm

You would define the value of the primary key in the where condition. Something like:
UPDATE ...
WHERE KeyColumnName = @keyParameter

Sandeep Mewara 11-May-12 12:43pm

I guess OP was looking for ADO.NET help. See my answer.

Wendelius 11-May-12 13:59pm

Sorry for the late reply, this would have been a possibility also. :)

Sandeep Mewara 11-May-12 12:55pm

My 5 now!

Wendelius 11-May-12 13:59pm

Thanks Sandeep :)

Sergey Alexandrovich Kryukov 11-May-12 13:29pm

My 5.
--SA

Wendelius 11-May-12 13:59pm

Thanks SA :)

sjelen · Accepted Answer · 2012-05-11T05:15:00

Solution 1

Same as inserting new row, just use UPDATE instead of INSERT. Make sure you use primary key to identify the row you want to change.

Posted 11-May-12 5:15am

sjelen