|
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)
|
|
|
|
|
Ken.Hamilton wrote: Which one is the faster?
calling stored procedure like an ordinary sql statement will work faster than the other because in the ordinary method it executes directly the command specified in the sqlCommand() where as in the second case it need to check for the CommandType has it is Stored Procedure so it needs to create a command to execute stored procedure with the specified stored procedure name.
Regards,
Sandeep Kumar.V
|
|
|
|
|
Sandeep Kumar Vuppala wrote: so it needs to create a command to execute stored procedure with the specified stored procedure name.
 By specifying new SqlCommand, it already created SQlCommand object. I think there won't be much difference for these two methods. What I feel second method is smarter, because it gives a clear picture to the person who is seeing the code that we are using stored procedures.
|
|
|
|
|
Thank you so much sandeep. I think it is almost same. Isn't it?
Ken,Mexico(Guanajuato)
|
|
|
|
|
Ken.Hamilton wrote: Which one is the faster?
There won't be much performance difference. But I think second one is the smarter way.
|
|
|
|
|
Yes you are correct. It is the standard way.
Ken,Mexico(Guanajuato)
|
|
|
|
|
The latter. It is standard, universally adopted practice. There is a proverb "Be Roman while in Rome right?"
|
|
|
|
|
Vasudevan Deepak Kumar wrote: There is a proverb "Be Roman while in Rome right?"
Great..
|
|
|
|
|
You said it. 
Ken,Mexico(Guanajuato)
|
|
|
|
|
Vasudevan Deepak Kumar wrote: "Be Roman while in Rome right?"
True.
SSK.
|
|
|
|
|
Hi All
I m using Windows XP and VS 2005.My projects were working properly. But when I open VS today this error occures and I m not able to run my project
Error is: WebDev.WebServer.exe has encountered a problem and needs to close. We are sorry for the inconvenience.
This error comes in a dialoge box.
Can any one tell me what is the reason of this error and what is the solution for this error.
I have'nt installed IIS. Just run my project from VS.
Thanks in Advance.
|
|
|
|
|
I am doing an application in which i hav implemented 5 accordion panes...all are working fine except one...
i hav a gridview in accordion pane 4 and when it is displayed the 5th accordion doesnt work..
when not clicking the 4th accordion pane the 5th one works fine....
SAJAN A PILLAI
C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE
|
|
|
|
|
Flooding from Bangalore
Today's News Headlines was telling that all rivers in Karnataka are overflowing and flooding into Tamil Nadu.
I guess, keeping up the spirit, you are flooding the messageboards with the same query.
It is water there and query here.
Bottomline: Please avoid cross-posting and duplicate posting across multiple unrelated forums and intimidate users.
|
|
|
|
|
my crystal reports design page has got shrink.I mean , all the sections are reduced to few centi meters.Is there any way out to restore/increase it's design sie.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Dear All,
I am using asp.net2.0, C#, sql2005 using Visual studio 2005
Let me explain the scenario. I am making search interface where 18 field(all are master field) are there . which I populate these field in Checkboxlist. based on selection I need to generate that much label control and dropwonlist control and which then after all dropdownlist need to populate with their respective master.
Please guide me in doing so or give me some useful link.
Thanks
imaran khan
|
|
|
|
|
is it necessary to create a dsn to create the crystal reports using sql server 2000.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
|
unlike SQL-Server ms-access provide the database selection for crystal reports.So Is it possible to select the sql server database there in crystal reports ?
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Sonia Gupta wrote: is it necessary to create a dsn to create the crystal reports using sql server 2000.
I think not necessary
|
|
|
|
|
unlike SQL-Server ms-access provide the database selection for crystal reports.So Is it possible to select the sql server database there in crystal reports ?
-- modified at 0:56 Friday 20th July, 2007
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Sonia Gupta wrote: is it necessary to create a dsn to create the crystal reports using sql server 2000.
No it is not necessary to create dsn....
You can create new connection with OLE DB(ADO) and select Microsoft Driver for SQL Server after that you can select the required databse.
Regards,
Sandeep Kumar.V
|
|
|
|
|
Thanks...
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Hi friends & RESPECTED sir,
i know abt crytal report how to make it.
but i want to know crystal report in brief.
plz hepl me.
plz send me all information regarding Crystal report on my id.:ajay58886@gmail.com
thnking you.
Imagine the I.T
|
|
|
|
|
|
why does only asp labels get displayed in browser but asp textboxes, buttons, dropdownlists dont
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
