Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

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.

1867


Explain what is the procedure to create the environment for asp.net? : asp.net mvc

1074


Explain the difference between the web config and machine config.

1085


Which class is used to send an email message from an ASP.NET Web page?

1073


Why is global asax is used?

1071


Explain transparent caching with aop?

1006


How do you do Client-side validation in .Net?

1133


Define managed code and managed data in .net?

1006


Can you explain how ASP.NET application life cycle and page life cycle events fire?

1071


What is the basic difference between asp and asp.net?

1074


Define repository pattern in asp.net mvc? : asp.net mvc

1047


What is distributed system in asp.net?

1073


How would you get asp.net running in apache web servers? Explain it's limitations.

1038


Can I have a unique key as foreign key?

1008


Explain the difference between overriding and overloading?

1052