Insert into query of two table from 1 form

venkimit...

SOLVED CLOSED ACTIVE ANSWERED
User: venkimithu
Posted: on Apr 24, 2012 08:24 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 2972

I want to insert form data to two table at one button click event.

cmd = new SqlCommand("Insert into regis(fname, lname, uname, passwo, repasswo, email, contact, gender, country, pin) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + D1.Text + "','" + TextBox9.Text + "','" + TextBox8.Text + "')", con);

I want to store email and contact to another table named details(fieldname= contact,email)

how i write query for this.when user click submit button record will saved to both tables.please provide solution.

Download FREE API for Word, Excel and PDF in ASP.Net

vinayak

0 3

Reply
ANSWER
User: vinayak
Replied: on Apr 25, 2012 05:09 AM
Report

create following store procedure

CREATE  PROCEDURE [InsertRegistration] @fname VARCHAR(50),@lname VARCHAR(50),
@uname VARCHAR(50),@passwo VARCHAR(50),@repasswo VARCHAR(50),@email VARCHAR(50),
@contact VARCHAR(50),@gender VARCHAR(50)ASBEGIN	INSERT INTO regis 	(		fname ,
		lname ,		uname ,		passwo ,		repasswo,		email,		contact ,		gender ,		email 		)
	VALUES	(		@fname,		@lname,		@uname ,		@passwo ,		@repasswo ,		@email ,
		@contact ,		@gender,		@email 		)		INSERT INTO details	(		contact,		email	)
	VALUES	(		@contact ,		@email	)END

to call Store Procedure refer :http://www.aspsnippets.com/Articles/Calling-Insert-SQL-Server-Stored-Procedures-using-ADO.Net.aspx

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Insert into query of two table from 1 form

Company

Explore

Follow us

Contact Us