ASP.NET

how to use UDF's with asp.net RSS

9 replies

Last post Mar 15, 2012 11:21 AM by Uddhav Garkal

‹ Previous Thread|Next Thread ›

- Reply
elifer25

Member

15 Points

3 Posts

how to use UDF's with asp.net

Aug 21, 2003 03:45 PM|LINK
Hi there, i have a user defined function in my sql server so i can use from different pages. the question is, how do i call it from asp.net? can some one show me some code? and if u can, can u show me how to use it with data grid? thanks.
- Reply
tmorton

All-Star

56441 Points

9720 Posts

ASPInsiders
Moderator

Re: how to use UDF's with asp.net

Aug 21, 2003 04:20 PM|LINK
What does your UDF do? Does it return a Table value? You would treat the resultset the same way you would with any other table/stored procedure resultset. I think more information is needed here. Terri

Terri Morton
ASP.NET/IIS.NET Website Manager, Neudesic
- Reply
douglas.reil...

All-Star

23315 Points

4647 Posts

Re: how to use UDF's with asp.net

Aug 21, 2003 05:15 PM|LINK
I am not aware that you can call a UDF from ADO.NET directly. You can call a stored procedure, and so perhaps you will need to wrap your UDF call in a stored procedure. More information about what the UDF does (and what it is returning) will help.

Starting with ASP.NET 2.0? Look at:
Programming Microsoft Web Forms
My Blog
- Reply
elifer25

Member

15 Points

3 Posts

Re: how to use UDF's with asp.net

Aug 21, 2003 05:35 PM|LINK
my UDF returns a table, i have been reading some tutorials and books, and they say that "one of the advantages of using UDF is that it is possible to use it from many applications." however, i have been going nuts trying to find some help on how to code this. if i cant use UDF, can i use stored procedures to retrive a table? i read that you can only update data with stored procedures, and that u get tables with UDF's.... thanks for your help guys.
- Reply
douglas.reil...

All-Star

23315 Points

4647 Posts

Re: how to use UDF's with asp.net

Aug 21, 2003 05:44 PM|LINK
You can absolutely return tables from a stored procedure, and you can certainly call a stored procedure from ADO.NET on an ASP.NET page. This link should help explain how to do it.

Starting with ASP.NET 2.0? Look at:
Programming Microsoft Web Forms
My Blog
- Reply
elifer25

Member

15 Points

3 Posts

Re: how to use UDF's with asp.net

Aug 21, 2003 06:03 PM|LINK
thanks!
- Reply
tmorton

All-Star

56441 Points

9720 Posts

ASPInsiders
Moderator
Re: how to use UDF's with asp.net

Aug 21, 2003 06:16 PM|LINK
And you can absolutely also call UDFs from ADO.NET on an ASP.NET page.
```
SELECT * FROM dbo.fnMyFunctionThatReturnsATable
```
But personally I wouldn't call the UDF directly. I'd make a stored procedure which calls the UDF. Terri
Terri Morton
ASP.NET/IIS.NET Website Manager, Neudesic
- Reply
douglas.reil...

All-Star

23315 Points

4647 Posts

Re: how to use UDF's with asp.net

Aug 21, 2003 07:18 PM|LINK
True, true. I have never used UDF's that way, but no reason you cannot. There is just not a CommandType.UserDefinedFunction... Thanks!

Starting with ASP.NET 2.0? Look at:
Programming Microsoft Web Forms
My Blog
- Reply
Phuoc

Participant

1150 Points

230 Posts

Re: how to use UDF's with asp.net

Aug 21, 2003 07:53 PM|LINK
Hi All, 1. Here is an example of ASP.NET calling UDF returns a TABLE http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=265546 Re: Calling a SQL 2k UDF from .aspx page -- See Posted: 07-02-2003 02:11 AM 2. As for using it, you make a judgement call. 3. You can use sp to wrap your UDF: There is an example -CREATE FUNCTION dbo.udf_Txt_SplitTAB -CREATE PROCEDURE sp_SELECT_IN to wrap UDF. -private void ASP_NET_SELECT_IN (string IN_List_Values) to call sp. http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=280390

Where there is a will, there is a way.

and where there is a team, there is more than one way.
- Reply
Uddhav Gark...

Member

14 Points

6 Posts

Re: how to use UDF's with asp.net

Mar 15, 2012 11:21 AM|LINK

Your link is not available.

please make it availabe.

Thanks in advance.

Enjoy coding..... :)