Click here to Skip to main content
15,916,527 members
Home / Discussions / C#
   

C#

 
GeneralRe: Help to a new user please Pin
sridhar88729-Jan-09 18:15
sridhar88729-Jan-09 18:15 
AnswerRe: Help to a new user please Pin
musefan29-Jan-09 5:31
musefan29-Jan-09 5:31 
GeneralRe: Help to a new user please Pin
J4amieC29-Jan-09 5:49
J4amieC29-Jan-09 5:49 
GeneralRe: Help to a new user please Pin
musefan29-Jan-09 6:04
musefan29-Jan-09 6:04 
GeneralRe: Help to a new user please Pin
sridhar88729-Jan-09 18:18
sridhar88729-Jan-09 18:18 
QuestionNew values and Old Values Pin
ziwez029-Jan-09 4:12
ziwez029-Jan-09 4:12 
AnswerRe: New values and Old Values Pin
musefan29-Jan-09 4:22
musefan29-Jan-09 4:22 
AnswerRe: New values and Old Values Pin
Rob Philpott29-Jan-09 5:11
Rob Philpott29-Jan-09 5:11 
What sort of database are you using here? I'd recommend putting some of that function into stored procs if you can.

If you update a phone number and log the previous one, you really want that operation to be atomic, which means it should run in a transaction. You could do this in code, but I'd argue a stored proc which replaces the phone number and logs the old one is they way to go.

Personally, I don't care for raw sql commands in code at all. It's ugly, fussy, not as secure, don't get exec plans and you increase the scope of transactions which could slow the system down.

Regards,
Rob Philpott.

AnswerRe: New values and Old Values Pin
N a v a n e e t h29-Jan-09 5:25
N a v a n e e t h29-Jan-09 5:25 
GeneralRe: New values and Old Values Pin
ziwez029-Jan-09 7:36
ziwez029-Jan-09 7:36 
QuestionA problem with DataBinding. [modified] Pin
AxiliuM29-Jan-09 4:09
AxiliuM29-Jan-09 4:09 
AnswerRe: A problem with DataBinding. Pin
MadArtSoft29-Jan-09 23:27
MadArtSoft29-Jan-09 23:27 
GeneralRe: A problem with DataBinding. Pin
AxiliuM30-Jan-09 20:03
AxiliuM30-Jan-09 20:03 
QuestionSend e-mail with .mht body from program Pin
collapo29-Jan-09 3:47
collapo29-Jan-09 3:47 
AnswerRe: Send e-mail with .mht body from program Pin
vaghelabhavesh29-Jan-09 13:36
vaghelabhavesh29-Jan-09 13:36 
GeneralRe: Send e-mail with .mht body from program Pin
collapo29-Jan-09 22:02
collapo29-Jan-09 22:02 
Questionaccessing database in SQL server 2005 through C# Pin
Deepali Khalkar29-Jan-09 2:35
Deepali Khalkar29-Jan-09 2:35 
AnswerRe: accessing database in SQL server 2005 through C# Pin
musefan29-Jan-09 2:45
musefan29-Jan-09 2:45 
AnswerRe: accessing database in SQL server 2005 through C# Pin
vaghelabhavesh29-Jan-09 13:28
vaghelabhavesh29-Jan-09 13:28 
QuestionDynamically Creating Treeview Nodes Question Pin
Rafone29-Jan-09 2:30
Rafone29-Jan-09 2:30 
AnswerRe: Dynamically Creating Treeview Nodes Question Pin
musefan29-Jan-09 2:44
musefan29-Jan-09 2:44 
GeneralRe: Dynamically Creating Treeview Nodes Question Pin
Rafone29-Jan-09 3:17
Rafone29-Jan-09 3:17 
AnswerRe: Dynamically Creating Treeview Nodes Question Pin
musefan29-Jan-09 3:32
musefan29-Jan-09 3:32 
GeneralRe: Dynamically Creating Treeview Nodes Question Pin
Rafone29-Jan-09 11:42
Rafone29-Jan-09 11:42 
Questionmemory allocated on heap in method Pin
devvvy29-Jan-09 2:14
devvvy29-Jan-09 2:14 

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.