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 the data controls available in asp.net?
Can you clarified A Web service can only be written in .NET or not?
How can you assign styles to webforms?
Differentiate session and cookie
What is the advantage of mvc over asp.net? : Asp.Net MVC
How can you pass multiple complex types in Web API?
What is manifest in .net framework?
What is the difference between a thread and a process?
what is view state?
What are the different types of caching ?
What is smpte vc-1?
Define the term Web Garden?
0 Answers Sans Pareil IT Services,
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)