how to insert value in tabel

Question

0.00/5 (No votes)

See more:

hi,
i m working on one asp.net application..
i m facing one problem while working with ms sql
i want to insert the values in one table as i insert the values in another tabel..

like i have one tabel Test1 which contain field UID,fname,Lname
and another tabel Test2 which contain field UID ..
i want UID values in Test2 get incremented as i insert in records in Test1..

Posted 3-Mar-10 22:26pm

amitindurkar

Updated 3-Mar-10 22:33pm

v3

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)

Sandeep Mewara · Answer 1 · 2010-03-03T22:54:00

You need triggers...

Read:
MSDN: Trigger[^]

Alternatively, if you need to add something else (you need some manual work) then you can use a stored procedure where you can have both inserts.
OR
have a transaction and commit once both the tables are updated.

Reading Good SQL book will be of great help.

DX Roster · Answer 2 · 2010-03-04T01:47:00

try following two query

For table1

String str=Insert into test values('"+txtbox1.text+"','"+txtbox1.text+"'....);
sqlcommand com=new sqlcommand(str,connection);
com.executenonquery();

For table 2

first retrive the value of Uid

String str1="Select Max(UID) from table2";
sqlcommand com1=new sqlcommand(str1,connection);
int i=(convert.toint32(com.executeScaler().tostring()));
i=i+1;

then execute insert query;

how to insert value in tabel

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0