How can we call UDF(User Define Function) using C# code in
ASP.net ?

Answer Posted / reventh

yes you can call a function.
sqlcommand cmd=new sqlcommand("select function
(parametter)");
sqldatareader rdr=cmd.excutereader();
while(rdr.read()
{
do something here;

}

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define compound operators?

529


define and explain the differences between clustered and non-clustered indexes.

593


What is subreport?

96


What are different type of Collation Sensitivity?

549


How optimize sql query with multiple joins in sql server?

413






Difference between Sql server reporting services and Crystal reports?

124


Explain what role entity and relationship play in an ER diagram.

569


What are the different types of lock modes in sql server 2000?

485


Define constraints and give an example of their use?

557


What is data source document?

542


What is sub-query in sql server?

661


How to drop an existing user defined function in ms sql server?

558


What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

515


Explain the properties of a relational table?

555


How to delete exactly duplicate records from a table?

597