Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to make code for below requirement? Expand / Collapse
Author
Message
Posted Wednesday, July 24, 2013 4:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:33 PM
Points: 172, Visits: 427
Hai Friends,

I m currently making one web application in that i wanna display details from data base into asp page on grid view.

create table onward_journey

(
onwrd_id int identity,
request_id int foreign key refernces request(reqst_id),
from_place varchar(10),
to_place varchar(10),
trvael_mode varchar(10),
no_of_days varchar(10)
)

insert into onward_journey ('11','chennai','chenai','car','2')


i wanna display display my page on gridview


select
from_place,to_place,travel_mode, no_of_days from travel_request where request_id=IDENT_CURRENT ('request')
when i made new request also its showing old once? how to that and how to show current request_id value?
Post #1476963
Posted Wednesday, July 24, 2013 4:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:20 AM
Points: 2,107, Visits: 5,405
This was already answered in a different thread that you opened - http://www.sqlservercentral.com/Forums/Topic1476962-1292-1.aspx?Update=1. Pleas open one post per question.

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1476966
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse