Sql Data Base function

Question

Hi Friends How i can call sql data base function from my ASP.NET front end?

Pravin More · Answer

Hi Akshay you can call it same way like query. here is code to call it.... suppose fTestFunction() is your function name...... SqlDataReader dr; SqlCommand spcmd; SqlConnection spcon=new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[commonconnection].ToString()) spcon.Open(); spcmd = new SqlCommand(select * from fTestFunction()  spcon); dr = spcmd.ExecuteReader(); if your function have any parameter then you can pass it in bracket. Thanks Pravin.

Akshay Teotia · Answer

Thanks pravin great one for me .