how to Pass 1st Page (Comp.aspx) PK key value to Fk Key

Question

I have Two tables like

create table Product

(

prodid varchar(50) primary key,

prodname varchar(50),

price int

)

create table Customer

(

custid varchar(50) primary key,

custname varchar(50),

custaddress varchar(50),

prodid varchar(50) foreign key references Product(prodid)

)

I have two pages like ProductDetails.aspx and

CustomerDetails.aspx

So now i want to pass the PK value(Product Table) in Productdetails.aspx to FK Key(Customer)CustomerDetails.aspx,

So please help me how to pass this task.....

Thanks in Advance

Maniteja Vegi · Answer

Go through this procedure and execute it.... Create procedure Storeprocname ( @CName varchar(50) @CLocation varchar(50) @EName varchar(50) @EGen varchar(50) ) as begin Declare @Cid int Set @Cid = 0 insert into tbl_Company (CNameCLocation) values(@CName@CLocation) Select @Cid = @@IDENTITY if (@Cid >0) Begin Insert into tbl_Employee (ENameEGenCid) values(@EName@EGen@Cid) Select @@IDENTITY End end GO

Upendra Pratap Shahi · Answer

Use query string concept for this when you redirect to other page. int Yourvalue = 10; Response.Redirect( productdetails.aspx?id= + Yourvalue); Get on page load using this- string id = Request.QueryString( id ); labeltext.Text = id;

Amitesh Verma · Answer

on button click page 1(productdetails.aspx) string querydata= pk value to send to next page; response.redirect(http://productdetails.aspx?id=querydata) on next page page load event(customerdetails.aspx) string id= Request.QueryString(id); labeltext.text=id; refer to link http://www.w3schools.com/asp/coll_querystring.asp

Manas Mohapatra · Answer

H Priyanka Please describe your question more. Where you want to go to second page and what information you need in second page etc.. Moreover you can use state management(session cookie querystring application) concept in asp.net. In your case if you want only one or two params then you can query string.