Click here to Skip to main content
15,867,704 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionIncome/expenditure report Pin
billcodes15-Apr-09 23:44
billcodes15-Apr-09 23:44 
AnswerRe: Income/expenditure report Pin
Abhijit Jana16-Apr-09 0:00
professionalAbhijit Jana16-Apr-09 0:00 
AnswerRe: Income/expenditure report Pin
David Mujica16-Apr-09 3:12
David Mujica16-Apr-09 3:12 
QuestionButton Click event not working inside AJAX popupcontrol and UpdatePanel Pin
Gaurav Mahajan15-Apr-09 23:41
Gaurav Mahajan15-Apr-09 23:41 
AnswerRe: Button Click event not working inside AJAX popupcontrol and UpdatePanel Pin
N a v a n e e t h16-Apr-09 0:05
N a v a n e e t h16-Apr-09 0:05 
GeneralRe: Button Click event not working inside AJAX popupcontrol and UpdatePanel Pin
Gaurav Mahajan16-Apr-09 0:55
Gaurav Mahajan16-Apr-09 0:55 
GeneralRe: Button Click event not working inside AJAX popupcontrol and UpdatePanel Pin
Armandt__16-Apr-09 1:51
Armandt__16-Apr-09 1:51 
Questionloop a 100 time or let SQL server deal with it Pin
ONeil Tomlinson15-Apr-09 23:09
ONeil Tomlinson15-Apr-09 23:09 
Hi guys
I have an application that does something. It generates an XML document with 100-200 items. For each item there is an ID. I need to check if this ID exist in a table in a database. At the end of checking these ID a second XML document must be created with all the ID that was not present in the Database. There are two ways of doing this ( l prefer option 2 but my senior prefers option 1) What do you thing is the best approach.

Option 1:
Loop through each record in the XML and with each loop make a call to SQL server to check if this ID exist. If the ID does not exist build a list of the non existing ID in some form of collection whcih will later be used for creating the second XML document

Option 2:
Pass the XML document to SQL server, let SQL server do the checking against all the ID and then return an XML message of the ID that does not exist

Thanks
Neil
AnswerRe: loop a 100 time or let SQL server deal with it Pin
N a v a n e e t h15-Apr-09 23:50
N a v a n e e t h15-Apr-09 23:50 
AnswerRe: loop a 100 time or let SQL server deal with it Pin
Gaurav Mahajan16-Apr-09 1:02
Gaurav Mahajan16-Apr-09 1:02 
AnswerRe: loop a 100 time or let SQL server deal with it Pin
ToddHileHoffer16-Apr-09 6:01
ToddHileHoffer16-Apr-09 6:01 
Questionaceessing controls having same name in server side Pin
rahuluni15-Apr-09 23:08
rahuluni15-Apr-09 23:08 
AnswerRe: aceessing controls having same name in server side Pin
ToddHileHoffer16-Apr-09 6:16
ToddHileHoffer16-Apr-09 6:16 
Questionhow to run source code Pin
anujchetan15-Apr-09 23:06
anujchetan15-Apr-09 23:06 
AnswerRe: how to run source code Pin
Baran M15-Apr-09 23:53
Baran M15-Apr-09 23:53 
AnswerRe: how to run source code Pin
N a v a n e e t h15-Apr-09 23:53
N a v a n e e t h15-Apr-09 23:53 
AnswerRe: how to run source code Pin
Abhijit Jana15-Apr-09 23:56
professionalAbhijit Jana15-Apr-09 23:56 
QuestionWeb service Pin
anandhakrishnan15-Apr-09 23:05
anandhakrishnan15-Apr-09 23:05 
AnswerRe: Web service Pin
Abhijit Jana15-Apr-09 23:49
professionalAbhijit Jana15-Apr-09 23:49 
Questionhow do i put assembly in to gac Pin
nikhil123415-Apr-09 22:38
nikhil123415-Apr-09 22:38 
AnswerRe: how do i put assembly in to gac Pin
Abhijit Jana15-Apr-09 22:48
professionalAbhijit Jana15-Apr-09 22:48 
QuestionRedirect to or from HTTPS Pin
Sarfaraj Ahmed15-Apr-09 21:25
Sarfaraj Ahmed15-Apr-09 21:25 
QuestionModalUpdateProgress - An UpdateProgress Control in Modal Popup Style Proble Pin
Niungareamit15-Apr-09 21:00
Niungareamit15-Apr-09 21:00 
AnswerRe: ModalUpdateProgress - An UpdateProgress Control in Modal Popup Style Proble Pin
Abhijit Jana15-Apr-09 21:18
professionalAbhijit Jana15-Apr-09 21:18 
AnswerRe: ModalUpdateProgress - An UpdateProgress Control in Modal Popup Style Proble Pin
Niungareamit15-Apr-09 21:20
Niungareamit15-Apr-09 21:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.