.net q

• sherm

  hopefully someone can help...
  should be common. if data to be inserted into a db table is there, then update the row... if it is not there, then insert it.

  i need a basic asp.net 2 code block for that.

  sherm

  Flag

• sherm0

  wrong place?

  sherm 0Permalink

  UpvoteDownvote

  Dogear

  Flag

  • maybe.studderine

  Show [[ numHiddenNotes ]] more notesAdd Note

  SaveCancel

• bliznutty0

  your question is kinda broad (yet simple)

  bliznutty 0Permalink

  UpvoteDownvote

  Dogear

  Flag

  Show [[ numHiddenNotes ]] more notesAdd Note

  SaveCancel

• 3030

  sounds simple, but it is quite tricky;

  if you have loads of rows, you have to iterate through every row and compare values;

  can be done using .net or can be done i t-sql (if MS SQL is used)

  more columns in table, more values to compare...

  303 0Permalink

  UpvoteDownvote

  Dogear

  Flag

  Show [[ numHiddenNotes ]] more notesAdd Note

  SaveCancel

• Machuse0

  this shuold be handled all at the database
  select id where data = newdata
  if id is valid
  update
  else
  insert into database

  Machuse 0Permalink

  UpvoteDownvote

  Dogear

  Flag

  Show [[ numHiddenNotes ]] more notesAdd Note

  SaveCancel