Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnMinValue", or the name is ambiguous

Question

Hi!

I've created a UDF to find the min of two integer values as

CREATE FUNCTION dbo.fnMinValue
               (@ColumnA MONEY,
                @ColumnB MONEY)
RETURNS MONEY
AS
  BEGIN
    RETURN (0.5 * ((@ColumnA + @ColumnB) - abs(@ColumnA - @ColumnB)))
  END

and I'm calling this UDF in folloeing format

SELECT cast(dbo.fnMinValue ( @lcount,@Rcount) as int)

when i execute this in server it gives the following error

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnMinValue", or the name is ambiguous.

Plz help me out..

Answer 1

refer This Link

http://www.codeproject.com/Articles/24043/Simple-Movie-Database-in-C-using-Microsoft-Access

Answer 2

Thanks,
Can you tell me how to use this command with a textbox

regionTableAdapter.Insert(5, "NorthWestern");

can i write textbox1.text, textbox2.text instead of 5 and Northwestern. I tried it but it gave me error( I was explicitly converting the textboxes to int32)

????

Answer 3

Hi Waqas,

Please refer the below links

http://www.c-sharpcorner.com/uploadfile/mimrantaj/connect-to-access-database-in-C-Sharp-and-ado-net/

http://msdn.microsoft.com/en-us/library/aa288452%28v=vs.71%29.aspx

http://www.codeproject.com/Articles/24043/Simple-Movie-Database-in-C-using-Microsoft-Access

Thanks