Access和.Net女士？ [英] Ms Access and .Net?

问题描述

我的一位教授提出了这样的最终问题


如何使用.Net enivronment中的Access数据库来跟踪数据？


我不知道它是什么，因为他从未在

讲座中教过.NET。

有谁知道答案？

解决方案

2005年5月18日03:10:15 -0700， ma ***** @ hotmail.com 写道：


您的驾驶教练从未让您开过那个特别的

街道在球场附近。然而，在你获得执照后，你来到那条街上，你知道如何导航它。


-Tom。

我的一位教授提出了这样的最终问题

如何在.Net环境中使用Access数据库来跟踪数据？

我不知道它是什么，因为他从未在
讲座中讲过.NET。
有谁知道答案？

Tom van Stiphout写道：

2005年5月18日03:10:15 -0700， ma ***** @ hotmail.com 写道：

您的驾驶教练从未让您开车穿过球场附近的特定街道。然而，在你拿到执照后，你来到那条街上，你知道如何导航它。

-Tom。


嗨汤姆，


电影里的每一个方式都松散，任何你可以的方式，Philo

Beddoe（克林特·伊斯特伍德）被一群堕落的堕落者骚扰;

黑寡妇摩托车俱乐部......在陆地上知道并担心。

In有一个例子，当成员策划他们对Philo的报复时，该组织的领导人意识到他周围都是玩偶和惊呼哦

主啊，为什么你给了我这个负担！？！？"


这让我想起了昨天。我的朋友在他的办公室有人，并且b
$正在展示我们的计划。这个人一直在与另一家公司合作，他们的程序是用FoxPro编写的，目前正在移植到.Net环境中。
。当这个人发现我们的

程序是用Access编写的时候，这个人表现出一些担心，它是用Access写的.b
。我不确定关注的是什么......也许那个人认为Access是一个弱的数据库管理程序并且不是一个
..Net应用程序。 .Net是否会被Access开发人员所熟知和担心，或者是我的朋友演示给我们带来负担的计划吗？


我问，因为反应让我感到惊讶。这个人被展示了一个非常强大而灵活的程序。在这一点上，我想我的朋友应该告诉这个人，这个用VB写的只是为了平息

神经而不是Access。我认为使用什么语言

来生成一个应用程序无关紧要，这对用户来说应用程序是多么有用

。作为一名开发人员，我可能对用于创建应用程序的环境感兴趣

，但除此之外还不多。 IOW，如果一个应用程序是用C ++创建的
和另一个用VB创建的，它们都执行了我想要的功能，我真的不在乎使用哪种环境创建应用程序。


由于这些原因，我真的不会在这个人的问题上投入太多股票。对于

公司来说，我们的计划不是针对的，而且绝不会是这样的。它的目标是购买
20人或以下的小公司。


所以...我错了吗？我应该关注Access应用程序与.Net

应用程序吗？如果是这样，为什么？

我的一位教授给出了这样的最终问题

如何使用Access数据库在.Net enivronment中跟踪数据？

我不知道它是什么，因为他从未在
讲座中教过.NET。
有谁知道答案？

您可以使用ADO.Net从.Net应用程序与Access进行交互，与

与Sql Server连接。对于Access，您使用OLEDB数据对象。

对于Sql Server，您使用Sql数据对象。您还可以使用Com Automation与Access接口

- 引用Access

库（对于您的Access版本）并使用CreateObject，GetObject。


我在VB.Net和C＃中有几个.Net应用程序，它们与Access和

Sql Server很好地连接。对于精炼的数据集（小于50,000

记录），Access

提供处理数据的易用性没有替代品。比在Sql Server中编写花哨的存储过程以通过.Net应用程序调用更容易。您可以使用OLEDBdataAdapter和来自.Net应用程序的
数据集从Access检索查询结果，将其读入Dataview对象，显示
$ b数据网格中的$ b数据。您可以从Access表单获得的数据网格获得相同的灵活性。

。那么为什么甚至打扰.Net呢？如果

你必须同时运行多个程序 - 多线程 -

这就是.Net规则。就像你必须同时从几个Access数据库（或Sql Server DB）检索来自

的数据一样，你可以通过多线程来实现这一点。访问是机器中的另一个组件（重要的

组件）。


Rich


***通过开发人员指南 http://www.developersdex.com ***

One of the my professor gave final question like this

"How to use Access database in .Net enivronment to keep track of data?"

I have no idea what it is about since he never taught about .NET in the
lecture.
Does anyone know the answer?

解决方案

On 18 May 2005 03:10:15 -0700, ma*****@hotmail.com wrote:

Your driving instructor never had you drive through that particular
street near the ballpark. Yet after you got your license, and you came
upon that street, you knew how to navigate it.

-Tom.

One of the my professor gave final question like this

"How to use Access database in .Net enivronment to keep track of data?"

I have no idea what it is about since he never taught about .NET in the
lecture.
Does anyone know the answer?

Tom van Stiphout wrote:

On 18 May 2005 03:10:15 -0700, ma*****@hotmail.com wrote:

Your driving instructor never had you drive through that particular
street near the ballpark. Yet after you got your license, and you came
upon that street, you knew how to navigate it.

-Tom.
Hi Tom,

In the movies Every Which Way But Loose and Any Which Way You Can, Philo
Beddoe (Clint Eastwood) is harrassed by a degenerate group of losers;
the Black Widows Motorcycle club..."known and feared across the land".
In one instance, as the members plot their revenge against Philo, the
leader of the group realizes he is surrounded by dolts and exclaims "Oh
Lord, why have you given me this burden!?!?"

Which reminds me of yesterday. My friend had someone at his office and
was demonstrating our program. This person has been working with
another company and their program is written in FoxPro and is currently
being ported to the .Net environment. When the person discovered our
program was written in Access, the person exhibited some concern that it
was written in Access. I''m not sure what the concern was...perhaps that
the person considers Access is a weak database mgt program and is not a
..Net app. Is .Net to be known and feared by Access developers or is the
person my friend demo''d the program to a dolt that gives us burdens?

I ask since the reaction surprised me. This person was shown a very
powerful and flexible program. At this point, I think my friend should
have told the person intitially it was written in VB simply to calm the
nerves instead of Access. I view it irrelevant regarding what language
was used to produce an application, it is how useful the application is
to the user. As a developer, I might be interested in the environment
used to create an app but not much more beyond that. IOW, if an app was
created in C++ and another in VB and they both performed the functions I
wanted, I really wouldn''t care which environment was used to create the app.

For these reasons, I really don''t don''t put much stock in the person''s
concerns. Our program is not targetted, and never will be, for
companies where 100s of users will be accessing it. It is targetted for
small companies of 20 persons or less.

So...am I wrong? Should I be concerned about an Access app vs a .Net
app? If so, why?

One of the my professor gave final question like this

"How to use Access database in .Net enivronment to keep track of data?"

I have no idea what it is about since he never taught about .NET in the
lecture.
Does anyone know the answer?

You can interface with Access from a .Net app using ADO.Net the same as
interfacing with Sql Server. For Access you use the OLEDB data objects.
For Sql Server you use the Sql data objects. You can also interface
with Access using Com Automation - make the reference to the Access
library (for your version of Access) and use CreateObject, GetObject.

I have several .Net apps in VB.Net and C# that interface with Access and
Sql Server very nicely. For refined datasets (smaller than 50,000
records) there is just no substition for the ease of use that Access
provides for processing data. Much easier than having to write fancy
stored procedures in Sql Server to invoke through your .Net app. You
can retrieve the query results from Access using an OLEDBdataAdapter and
dataset from the .Net app, read that into a Dataview Object, display the
data in a datagrid. You get the same flexibility with the datagrid that
you would get from an Access form. So why even bother with .Net? If
you have to run multiple procedures at the same time - multi-threading -
this is where .Net rules. Like if you have to retrieve data from
several Access databases at the same time (or Sql Server DB''s), you can
achieve this with multi-threading. Access is another component (vital
component) in the machinery.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

这篇关于Access和.Net女士？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！