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
a web application needs to be created to accept the product name and quantity of a toy from a customer. After the customer has entered the product name the application needs to display the discounted price of the product to the customer (company is offering 35% discount on all products). The application should allow the customer to select the product name from a list box. and also while i'm data binding to a label with custom data binding with some declarations : "The Discounted Price is "+((System.Convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)) - ((System.convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)*0.35)). Where i need to give this declaration in asp.net 2.0.
Explain what is the procedure to create the environment for asp.net? : asp.net mvc
Explain the difference between the web config and machine config.
Which class is used to send an email message from an ASP.NET Web page?
Why is global asax is used?
Explain transparent caching with aop?
How do you do Client-side validation in .Net?
Define managed code and managed data in .net?
Can you explain how ASP.NET application life cycle and page life cycle events fire?
What is the basic difference between asp and asp.net?
Define repository pattern in asp.net mvc? : asp.net mvc
What is distributed system in asp.net?
How would you get asp.net running in apache web servers? Explain it's limitations.
Can I have a unique key as foreign key?
Explain the difference between overriding and overloading?