i need to insert into stock table and if exists means update it

Question

1.00/5 (1 vote)

See more:

C#

i need to insert into stock table a new data and if exists means update it in sql server

Posted 19-May-13 18:54pm

Sharon 2

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)

erogaki · Answer 1 · 2013-05-19T19:04:00

Solution 1

keep an identity column in your stock table...fro eg. stock_id
so you can insert/update as

SQL

if exists(select * from stock where stock_id = @stock_id)
Begin
     Update stock
     set (........)
     where stock_id = @stock_id
End

ELse
Begin

    insert into stock
     (....)
End

Posted 19-May-13 19:04pm

erogaki

Comments

Sharon 2 20-May-13 1:15am

for first insert how can i give the value of @stock_id from front end as parameter value

Sunny_Kumar_ 20-May-13 1:20am

what primary key column you have in your stock table?

Sharon 2 20-May-13 1:21am

stock-id itself

Sunny_Kumar_ 20-May-13 1:36am

then you must have some constraint to distinguish the uniqueness of data at a given level in order to achieve this purpose, otherwise I'm afraid you can do this. As far I can see, this stock_id PK gives you the power to read unique rows only not the unique data.

Sharon 2 20-May-13 1:37am

i have purid means id that come from purchase table,can you please show an example with this type stock_id

bunzitop · Answer 2 · 2013-05-19T22:25:00

if you want to check whether the product exists or not before you update it then you can use sqlDataAdapter.

C#

DataTable dt = new DataTable();
string check = "SELECT * FROM TABLENAME WHERE product = '"+textBox1.Text+"';
sqlcommand cmd = new sqlcommand("check");
sqlDataAdapter adap = new sqlDataAdapter("cmd", yourdatabaseconnection);
try
{
adap.Fill(dt)
}
catch(exception ex)
{
throw ex;
}
if(dt.Rows.Count>0)
{
//here goes your code for update
}
else
{
// here goes code for new insertion 
}

I have demonstrated using concat. Its best idea to use Stored Procedure. Plz use stored procedure while implementing..
Hope i met ur requirement!