How to make code for below requirement?

• raghuldrag

  Hall of Fame

  Points: 3160

  More actions

  July 24, 2013 at 4:13 am

  #280714

  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?

• Adi Cohn-120898

  SSC-Dedicated

  Points: 33944

  More actions

  July 24, 2013 at 4:27 am

  #1635278

  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/