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

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

Insert Data Into two tables..

4 solutions

Solution 2

Solution 3

Solution 1

Solution 4

Add your solution here

Preview 0

Insert Data Into two tables..

4 solutions

Solution 2

Solution 3

Solution 1

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us