How Does You Call And Execute A Sp In .net?

1.	How Does You Call And Execute A Sp In .net?
Answer» USING command object we can EXECUTE a SP. INSTEAD of sql query we have to pass the SP NAME. [command.connection =connectionstring command.commandType=commandType.storedProcedure command.commandtext="sp_name" command.executenonquery()] Using command object we can execute a SP. Instead of sql query we have to pass the SP Name. [command.connection =connectionstring command.commandType=commandType.storedProcedure command.commandtext="sp_name" command.executenonquery()]

Answer»

USING command object we can EXECUTE a SP. INSTEAD of sql query we have to pass the SP NAME.
[command.connection =connectionstring
command.commandType=commandType.storedProcedure
command.commandtext="sp_name"
command.executenonquery()]

Using command object we can execute a SP. Instead of sql query we have to pass the SP Name.
[command.connection =connectionstring
command.commandType=commandType.storedProcedure
command.commandtext="sp_name"
command.executenonquery()]

Discussion

No Comment Found

Related InterviewSolutions

How To Create Crystal Report In Vb.net With Coding?
What Are The Objects In Asp.net And Tell The Purpose Of Those Objects?
When We Will Use Console?
In Vb.net How To Connect Crystal Report?
How Would You Implement Inheritance Using Vb.net/c#?
What Is The Difference Between An Xml "fragment" And An Xml "document" ?
Whats The Difference Between Const And Readonly?
Can You Create Enumerated Data Types In C#?
What Happens When You Encounter A Continue Statement Inside The For Loop?
Whats The C# Equivalent Of C++ Catch (...), Which Was A Catch-all Statement For Any Possible Exception?

How Does You Call And Execute A Sp In .net?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment