Click here to Skip to main content
15,913,773 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionhow to populate values in a cascadingdropdownlist Pin
ajithes19-Jul-07 20:09
ajithes19-Jul-07 20:09 
AnswerRe: how to populate values in a cascadingdropdownlist Pin
Imran Khan Pathan19-Jul-07 20:27
Imran Khan Pathan19-Jul-07 20:27 
GeneralRe: how to populate values in a cascadingdropdownlist Pin
ajithes19-Jul-07 21:08
ajithes19-Jul-07 21:08 
Questionhow to update login information in config file Pin
Piyush Vardhan Singh19-Jul-07 20:07
Piyush Vardhan Singh19-Jul-07 20:07 
AnswerRe: how to update login information in config file Pin
N a v a n e e t h19-Jul-07 20:33
N a v a n e e t h19-Jul-07 20:33 
GeneralRe: how to update login information in config file Pin
Piyush Vardhan Singh19-Jul-07 21:57
Piyush Vardhan Singh19-Jul-07 21:57 
Questionimage uploading in asp.net Pin
Milind Panchal19-Jul-07 20:06
Milind Panchal19-Jul-07 20:06 
QuestionWhich one is the smart coding? Pin
Mic Mathi19-Jul-07 19:48
Mic Mathi19-Jul-07 19:48 
Hi,

What is the differents between calling a Stored Procedure like an ordinary sql using 'EXEC' command and by specifying the command type is StoredProcedure? Which one is the faster?

//Example of calling stored procedure like an ordinary sql statment
Dim Cn As New SqlConnection("server=.;database=sample;uid=sa;password=;")
Dim cmd As New SqlCommand("EXEC SP_EXAMPLE", Cn)
cmd.ExecuteNonQuery()

//Example of calling stored procedure with command type is StoredProcedure
Dim Cn As New SqlConnection("server=.;database=sample;uid=sa;password=;")
Dim cmd As New SqlCommand("SP_EXAMPLE", Cn)
cmd.CommandType = CommandType.StoredProcedure
cmd.ExecuteNonQuery()

Thanks and Regards,

Ken,Mexico(Guanajuato)

AnswerRe: Which one is the smart coding? Pin
Sandeep Kumar19-Jul-07 19:57
Sandeep Kumar19-Jul-07 19:57 
GeneralRe: Which one is the smart coding? Pin
N a v a n e e t h19-Jul-07 20:31
N a v a n e e t h19-Jul-07 20:31 
GeneralRe: Which one is the smart coding? Pin
Mic Mathi19-Jul-07 20:54
Mic Mathi19-Jul-07 20:54 
AnswerRe: Which one is the smart coding? Pin
N a v a n e e t h19-Jul-07 20:28
N a v a n e e t h19-Jul-07 20:28 
GeneralRe: Which one is the smart coding? Pin
Mic Mathi19-Jul-07 20:56
Mic Mathi19-Jul-07 20:56 
AnswerRe: Which one is the smart coding? Pin
Vasudevan Deepak Kumar19-Jul-07 20:39
Vasudevan Deepak Kumar19-Jul-07 20:39 
GeneralRe: Which one is the smart coding? Pin
N a v a n e e t h19-Jul-07 20:43
N a v a n e e t h19-Jul-07 20:43 
GeneralRe: Which one is the smart coding? Pin
Mic Mathi19-Jul-07 20:57
Mic Mathi19-Jul-07 20:57 
GeneralRe: Which one is the smart coding? Pin
Sathesh Sakthivel19-Jul-07 21:05
Sathesh Sakthivel19-Jul-07 21:05 
QuestionWebServer Error Pin
Khan.Bangash19-Jul-07 19:46
Khan.Bangash19-Jul-07 19:46 
QuestionAccordion Pane not working after Gridview is displayed... Pin
codingrocks19-Jul-07 19:00
codingrocks19-Jul-07 19:00 
AnswerRe: Accordion Pane not working after Gridview is displayed... Pin
Vasudevan Deepak Kumar19-Jul-07 20:37
Vasudevan Deepak Kumar19-Jul-07 20:37 
Questioncrystal report desin page reduced. Pin
Sonia Gupta19-Jul-07 18:54
Sonia Gupta19-Jul-07 18:54 
Questionhow to create controls based on checkboxlist selection Pin
imranafsari19-Jul-07 18:47
imranafsari19-Jul-07 18:47 
Questiondsn for sql server. Pin
Sonia Gupta19-Jul-07 18:30
Sonia Gupta19-Jul-07 18:30 
AnswerRe: dsn for sql server. Pin
Vasudevan Deepak Kumar19-Jul-07 18:34
Vasudevan Deepak Kumar19-Jul-07 18:34 
QuestionRe: dsn for sql server. Pin
Sonia Gupta19-Jul-07 19:36
Sonia Gupta19-Jul-07 19:36 

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.