How can i mapped two columns and store it in temporary table MVC3 app? RSS

• • Reply
  

  ashuthinks

  Member

  87 Points

  76 Posts

  How can i mapped two columns and store it in temporary table MVC3 app?

  Apr 11, 2012 02:47 PM|LINK

  I have created one MVC3 application. In which I'm selecting two Ids from two different tables which i need to map and need to save somewhere temporary and want to display at the end.

  table1

  SELECT PriceID FROM Pricing

  PriceID
  P111
  P222
  P333
  

  table2

  SELECT QueryID FROM QueryTable

  QueryID
  Q565UUU
  Q661YAA
  Q421933
  

  now i'm not getting how can I show them to select one-one Ids from each to map them together any help?

  Mapped dataset or any temptable will have two columns

   PriceID  QueryID
    P111    Q565UUU
  

  I'm newbie in MVC3 what should I take to show single columns ?

  Please help need to create the UI so that one can easily select SecurityID and CUSIP from each table and map to each other..

  what should i use?

  mvc mvc3

  Ashish Fugat
  Mark as Answer if it helped!!! :)
  • Edited by ashuthinks on Apr 11, 2012 02:53 PM
• • Reply
  

  ignatandrei

  All-Star

  134947 Points

  21626 Posts

  Moderator

  MVP

  Re: How can i mapped two columns and store it in temporary table MVC3 app?

  Apr 11, 2012 07:11 PM|LINK

  ashuthinks

  d need to save somewhere temporary and want to display at the end.

  please see http://msprogrammer.serviciipeweb.ro/2010/03/29/asp-net-mvc-orm-and-viewmodels/

  mvc mvc3

  My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools
  • Marked as answer by Young Yang - MSFT on Apr 18, 2012 01:59 AM