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 |
What are resource file and how do we generate resource file?
Is asp.net different from asp? If yes, explain how?
What is cross page posting? How is it done?
About Postback ?
In a page I have gridview with options of select and delete using hyperlink when I am selecting any one of then it has to open another page how can it?
In ViewState How much lifespan items stored?
Describe the .net base class library.
Suggest 3 best practices in detail for for Developing High Performance Web and Enterprise Applications
Why we are using mvc instead of asp.net? : Asp.Net MVC
Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?
What property must you set, and what method must you call in your code, in order to bind the data from a data source to the Repeater control?
What are the advantages of asp.net?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)