insert data in foreign key RSS

• • Reply
  

  akverma

  Member

  49 Points

  64 Posts

  insert data in foreign key

  Oct 05, 2010 04:00 PM|LINK

  I've two table 

  a). Country

    1.CountryId  -PK

   2. Country Name

  b)City

  1.CityId---PK

  2.CityName

  3.CountryId --FK to Country table

  and my code is 

  <div style="position: absolute; left: -10000px; top: 25px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">FWUDataContextDataContext CityContext = new FWUDataContextDataContext();</div> <div style="position: absolute; left: -10000px; top: 25px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">        tblCity objCity = new tblCity();</div> <div style="position: absolute; left: -10000px; top: 25px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">        objCity.City = City.City;</div> <div style="position: absolute; left: -10000px; top: 25px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">        objCity.CountryId= int.Parse(City.CountryId);</div> <div style="position: absolute; left: -10000px; top: 25px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">        CityContext.tblCities.InsertOnSubmit(objCity);</div>

  DataContextDataContext CityContext = new ataContextDataContext();
          tblCity objCity = new tblCity();
          objCity.City = "London";
          objCity.CountryId= 1;
          CityContext.tblCities.InsertOnSubmit(objCity);

  
  it doesn't insert any thing in data base, whereas I've similar code for Country table that works fine.

  
  

  
  

  
  

  
  

  
  

  Free Hosting-Comparison | NCR
• • Reply
  

  hareshambali...

  Participant

  1623 Points

  260 Posts

  Re: insert data in foreign key

  Oct 05, 2010 06:15 PM|LINK

  Hi,

  you haven't write

  CityContext.SubmitChanges(); method as last statement of your code.
  

  Regards,
  Haresh Ambaliya
  Linq Technologies
  Please remember to mark as "answers" if they help
  .
  • Marked as answer by akverma on Oct 07, 2010 01:44 PM
• • Reply
  

  akverma

  Member

  49 Points

  64 Posts

  Re: insert data in foreign key

  Oct 06, 2010 08:10 AM|LINK

  Well spotted! and TVM

  hareshambaliya

  Hi,

  you haven't write

  CityContext.SubmitChanges(); method as last statement of your code.
  

   

  Free Hosting-Comparison | NCR
  • Marked as answer by akverma on Oct 06, 2010 08:10 AM
• • Reply
  

  hareshambali...

  Participant

  1623 Points

  260 Posts

  Re: insert data in foreign key

  Oct 06, 2010 10:48 AM|LINK

  Thanks

  Regards,
  Haresh Ambaliya
  Linq Technologies
  Please remember to mark as "answers" if they help
  .
  • Edited by hareshambaliya on Oct 07, 2010 08:42 PM