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

priyanka dodda

11y1k

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Maniteja Vegi11y ago
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 (CName,CLocation) values(@CName,@CLocation) Select @Cid = @@IDENTITY if (@Cid >0) Begin Insert into tbl_Employee (EName,EGen,Cid) values(@EName,@EGen,@Cid) Select @@IDENTITY End end GO
0
Upendra Pratap Shahi11y ago
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;

0
Amitesh Verma11y ago
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
0
Manas Mohapatra11y ago
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.
0