How can you execute stored procedure from windows application?
Answer Posted / 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 |
Post New Answer View All Answers
What are the three parts of an http response?
Should I delete cookies?
Where session variables are stored?
What is the purpose of master page?
How can you pass multiple complex types in Web API?
explain code with multi inhertance
What are the cookies types in asp.net?
What is caching? What are different ways of caching in asp.net?
Explain about ASP.NET?
Explain a program using razor view engine to create a simple application? : asp.net mvc
What is difference cookie and session?
I’m having some trouble with cas. How can I diagnose my problem?
Hi this is the coding for adding data in to an xml table
i want the coding for update and delete
Try
Dim emp_xml_doc As New XmlDocument
If
System.IO.File.Exists(Server.MapPath("emp.xml")) Then
emp_xml_doc.Load(Server.MapPath("emp.xml"))
Dim myrow_element As XmlElement
myrow_element =
emp_xml_doc.CreateElement("EmpDetails")
Dim str As String
str = "
Define a static class?
Why do we need master page in asp.net?