Userdefine function

• sampathsoft

  SSC Eights!

  Points: 855

  More actions

  December 13, 2007 at 6:04 am

  #62755

  Hi all,

  im new to userdefine function. I have to make some userdefine function to my some purpose. I read some artical to make those.

  But still i dont know how i call to this user define function to my c# code.Normaly i used storedprocedure to do everything in my sql2000 database.

  Can anybody help me to solve this problem. How to call my userdefine function through my c# (asp.net) page.

  or send me to related articals to understand it.

  Thank you all

  Sampath

  (beginner to Userdefine Function)

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  December 13, 2007 at 8:06 am

  #759845

  You call it like you would a stored procedure. It returns values to your datareader.

  http://support.microsoft.com/kb/329497

• SQL_ABD

  SSCertifiable

  Points: 5832

  More actions

  December 13, 2007 at 6:43 pm

  #760065

  Hi,

  Check the following link http://www.codeproject.com/KB/database/TableValuedFnsAsArrays.aspx

  For me this web site is a reference for .net coding.

  Regards,

  Ahmed