在VB.net中使用用户定义的函数 [英] Using User-defined Functions in VB.net

查看:134
本文介绍了在VB.net中使用用户定义的函数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

每个人身体


多年来我成功使用了访问权限,并用它创建了许多scientefic

数据库


现在我想使用带有访问数据库的VB.net2005环境


我成功加载了我的数据库但是

模块中的所有自定义函数都没有导入


所以我在VB.net中创建了一个模块并将我所有的自定义函数都放到了

公共函数,

但这个也失败了!


我怎样才能让SQL引擎读取

访问中的函数?


提前致谢

解决方案

a)访问MDB是为了延迟


b) SQL Server UDF很棒


c)如果你试图在VB 2005中重用它们,你将不得不重写

它们_AGAIN_

MS不支持代码重用;远离VB;考虑PHP或

一些东西

MS已证明;一次又一次 - 他们可以更少关心

约700万vb6程序员;并且他们宁愿迎合一对夫妇

$ C#_FAGS_


2月13日上午5:22,SemiNoviceProgramer < hgnov3 ... @ gmail.comwrote:


您好每个人


多年来我成功使用了访问权限用它创建了许多scientefic

数据库


现在我想使用VB.net2005 environmment和访问数据库


我成功加载了我的数据库但是

模块中的所有自定义函数都没有被导入


所以我在VB.net中创建了一个模块并把我所有的自定义函数

公共函数,

但这也失败了!


如何使SQL引擎读取函数因为它是在

访问?


提前谢谢



< blockquote>学习SQL或VB你不能没有两个中的任何一个滑冰。我个人说''螺丝dotnet''我一直专注于SQL的

过去5年;我爱它


,更糟糕的是变得更糟;我会转移到mySql或Oracle或者某些东西; MS

已经完全无视程序员,

程序员,程序员


2月13日,上午5:22 ,SemiNoviceProgramer, < hgnov3 ... @ gmail.comwrote:


您好每个人


多年来我成功使用了访问权限用它创建了许多scientefic

数据库


现在我想使用VB.net2005 environmment和访问数据库


我成功加载了我的数据库但是

模块中的所有自定义函数都没有被导入


所以我在VB.net中创建了一个模块并把我所有的自定义函数

公共函数,

但这也失败了!


如何使SQL引擎读取函数因为它是在

访问?


提前谢谢



< blockquote>如果这里没有人帮助你(并且忽略了Larry Linson的家伙;他正在拖钓),

我建议你把它发布到

microsoft.public。 sqlserver.programming newsgroup。


Robin S.

---------------------- ---- -

" SemiNoviceProgramer" < hg ******* @ gmail.comwrote in message

news:11 ********************* @ v33g2000cwv .googlegro ups.com ...


您好每个人


多年来我成功使用了访问权限并创建了许多scientefic

数据库带它


现在我想用VB.net2005环境访问数据库


我成功加载了我的数据库但是

模块中的所有自定义函数都没有被导入


所以我在VB.net中创建了一个模块并将我的所有自定义函数都设置为

公共函数,

但这也失败了!


我能做些什么才能使SQL引擎读取函数在

访问?


提前致谢



Hi Every body

I used access succefully for years and I created many scientefic
databases with it

Now I want to use VB.net2005 environmment with access database

I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported

So I created a module in VB.net and put all my custom functions as
Public Functions,
But this fails too!

What Can I Do to make the SQL engine read functions as it was in
access?

Thanks in advance

解决方案

a) Access MDB is for retards

b) SQL Server UDFs are great

c) if you''re trying to reuse them in VB 2005 you''ll have to rewrite
them _AGAIN_

MS does not support code reuse; move away from VB; consider PHP or
something
MS has demonstrated; time and time again-- that they could care less
about 7 million vb6 programmers; and they''d rather cater to a couple
hundred C# _FAGS_


On Feb 13, 5:22 am, "SemiNoviceProgramer" <hgnov3...@gmail.comwrote:

Hi Every body

I used access succefully for years and I created many scientefic
databases with it

Now I want to use VB.net2005 environmment with access database

I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported

So I created a module in VB.net and put all my custom functions as
Public Functions,
But this fails too!

What Can I Do to make the SQL engine read functions as it was in
access?

Thanks in advance



either learn SQL or VB you can''t skate by without one of the two
I personally said ''screw dotnet'' and i''ve been focused on SQL for the
past 5 years; I love it

and worse comes to worse; i''ll move to mySql or Oracle or someting; MS
has demonstrated a complete and utter disregard for programmers,
programmers, programmers

On Feb 13, 5:22 am, "SemiNoviceProgramer" <hgnov3...@gmail.comwrote:

Hi Every body

I used access succefully for years and I created many scientefic
databases with it

Now I want to use VB.net2005 environmment with access database

I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported

So I created a module in VB.net and put all my custom functions as
Public Functions,
But this fails too!

What Can I Do to make the SQL engine read functions as it was in
access?

Thanks in advance



If nobody here helps you (and ignore the Larry Linson guy; he''s trolling),
I recommend that you post this to the
microsoft.public.sqlserver.programming newsgroup.

Robin S.
---------------------------
"SemiNoviceProgramer" <hg*******@gmail.comwrote in message
news:11*********************@v33g2000cwv.googlegro ups.com...

Hi Every body

I used access succefully for years and I created many scientefic
databases with it

Now I want to use VB.net2005 environmment with access database

I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported

So I created a module in VB.net and put all my custom functions as
Public Functions,
But this fails too!

What Can I Do to make the SQL engine read functions as it was in
access?

Thanks in advance



这篇关于在VB.net中使用用户定义的函数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆