How can you execute stored procedure from windows application?
Answer / jigneshsanghvi
Stored proc. can be executed using command object by
ExecuteNonQuery method.
Sample Code :
Dim cnn as new sqlconnection
cnn.connectionstring=constr
cnn.open()
Dim cmd as new sqlcommand
cmd.connection=cnn
cmd.commandtext = "ProcName" & parameter list separated by comma
cmd.ExecuteNonQuery()
Is This Answer Correct ? | 0 Yes | 0 No |
To load your generated dataset with data which method do you invoke?
What is a 1x1 pixel?
what is the auto option in XML ?
please can any describe 'Master Page' in ASP.Net 2.0
What is a Windows Service and how does its life cycle differ from a standard EXE?
can we edit records from repeater control
can u debug application programatically? if yes how?
How many classes can a single .NET DLL contain?
If we add a textbox and give the required field validator,and i add two radio buttons 1 is yes another one is No.And i add another one server control button ,if i click the button ,if the radio button Yes is checked the validation control is fired ,if no the validation control is not fired.So what you used to solve this problem.
Suppose You Want A Certain Asp.net Function Executed On Mouseover For A Certain Button. Where Do You Add An Event Handler?
Explain global assembly cache.
What are the steps to follow to host a web application on a web server?