calling user defined function in c# RSS

• • Reply
  

  mojde

  Member

  19 Points

  57 Posts

  calling user defined function in c#

  Sep 03, 2008 06:21 AM|LINK

  hi,

   i have one user defined function in sql2000, i'm going to call it via query in c# but i don't know,how !

  please help me with sample code...

  thanks

  • Moved by jimmy q on Sep 03, 2008 07:21 AM
• • Reply
  

  kamrul3d

  Contributor

  2297 Points

  392 Posts

  Re: calling user defined function in c#

  Sep 03, 2008 07:39 AM|LINK

  your sql will be "Select dbo.YourDataBaseFunction(@Parm1, @Parm2, @Parm3)"

  here i'm using parametrized(@Param1,@....) query and most of the code r same (like selecting data's from a  table)
  

   

   

  Thanks,
  Kamrul Hassan
  
  please mark as answer if it helps u.
• • Reply
  

  bhadelia.imr...

  Contributor

  3191 Points

  533 Posts

  Re: calling user defined function in c#

  Sep 03, 2008 07:40 AM|LINK

  You cannt directly call function in C#, what you can do is.

  stored procedure which call this and give you result bakc, or in commandtext write the select statement which calls the UDF

  Hope this helps you.

  Imran
  [MCTS]
  Born to fly High
  http://knowledgebaseworld.blogspot.com/
• • Reply
  

  kamrul3d

  Contributor

  2297 Points

  392 Posts

  Re: calling user defined function in c#

  Sep 03, 2008 08:07 AM|LINK

  bhadelia.imran

  You cannt directly call function in C#, what you can do is.

  stored procedure which call this and give you result bakc, or in commandtext write the select statement which calls the UDF

  Hope this helps you.

  @bhadelia:
  

  here is a sample how to call database function
  

   

  String ssss = ConnectionManager.Instance.GetFunctionData("test");

   
   public String GetFunctionData(String showFunctionData)
      {
          queryString = "select dbo.fn_checkFunction('"+showFunctionData+"')";
          commandSql = new SqlCommand(queryString, connectionSql);
          connectionSql.Open();
          dataReaderSql = commandSql.ExecuteReader();
          string retu = "";
          while (dataReaderSql.Read())
          {
              retu= dataReaderSql[0].ToString();
              break;
          }
          dataReaderSql.Close();
          connectionSql.Dispose();
          connectionSql.Close();
          return retu;
      }
     
  CREATE        function dbo.fn_checkFunction(@id nvarchar(4000))
  returns nvarchar(4000)
  as
  begin
  return @id
  end
  
   

    
  
  Thanks,
  Kamrul Hassan
  
  please mark as answer if it helps u.
  • Edited by kamrul3d on Sep 03, 2008 08:18 AM
  • Marked as answer by mojde on Sep 06, 2008 03:48 AM
• • Reply
  

  jain1607

  Member

  2 Points

  1 Post

  Re: calling user defined function in c#

  Nov 11, 2010 12:17 PM|LINK

  please first give the detail of functions and its parameter like; what the function is and what are its passing & returning parameters.

  functionns