Insert Data Into two tables..

Question

0.00/5 (No votes)

See more:

Sir in my application i have 2 tables , Master table & Detail table.. Text box values are insert into master table & grid view data insert into Detail table..
Using store procedure how to insert both data in single procedure . help sir

Posted 9-Feb-14 20:48pm

Ajith.Kerala

Updated 9-Feb-14 20:57pm

King Fisher

v2

Add a Solution

4 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)

Md.Sajidur rahman · Accepted Answer · 2014-02-09T21:04:00

Solution 2

You can write a single procedure

SQL

USE [YourDatabase]
GO
/****** Object:  StoredProcedure [dbo].[SP_Fr_FileUpDate]    Script Date: 02/10/2014 09:00:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create procedure [dbo].[SP_Fr_FileUpDate]
	@param1 varchar(MAX),
	@param2 int,
	@param3 Date
as 
Begin
Insert Query
Insert Query

   END
end

Posted 9-Feb-14 21:04pm

Md.Sajidur rahman

Comments

Ajith.Kerala 10-Feb-14 5:41am

Grid view data is insert into the second table .. how can i pass all the row wise data into this procedure..

Abhinav S · Accepted Answer · 2014-02-09T21:14:00

Solution 3

Crate an SP

SQL

ECLARE @NewID INT

INSERT INTO Table1(A,B,C......) VALUES(a,b,c, .....)

SELECT @NewID = SCOPE_IDENTITY()

INSERT INTO Table2(A,B,C...) VALUES(@NewID, B,..........)

Posted 9-Feb-14 21:14pm

Abhinav S

King Fisher · Accepted Answer · 2014-02-09T21:00:00

Solution 1

SQL

begin transaction


insert query for first table 

insert query for second table
Rollback transaction

Posted 9-Feb-14 21:00pm

King Fisher

OPees · Accepted Answer · 2014-02-09T21:24:00

Solution 4

try like this

SQL

Create PROCEDURE [dbo].[sp_InsertinTwoTables]
   @param1 varchar(MAX),
	@param2 varchar(20),
	@param3 varchar(10)


as
BEGIN
BEGIN TRY --Starts the Try Block..
BEGIN TRANSACTION -- transaction..starts

	Insert into table1 (col1,col2,col3) values (@param1,@param2,@param3)
	
	Insert into table2 (col1,col2,col3) values (@param1,@param2,@param3)

COMMIT TRAN -- Success!
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRAN --RollBack in case of Error
END CATCH
END

Posted 9-Feb-14 21:24pm

OPees

Comments

Ajith.Kerala 10-Feb-14 5:42am

am trying to insert grid view data into table 2.. then can it possible ?

[no name] 10-Feb-14 5:54am

Why not you can do it.

OPees 10-Feb-14 5:49am

yes just comment 1st insert statement