帮助创建一个调用sql storedprocedure的函数

时间:2022-05-18 01:55:47

I tried to search forum topics to find a tutorial that will guide me on how to achieve this however seem like most of the tutorials i were finding were confusing me more.With that being said here is what i have,

我试图搜索论坛主题,找到一个教程,指导我如何实现这一点,但似乎我发现的大部分教程让我更加困惑。这里说的就是我所拥有的,

Here is what I am trying to do http://www.asp.net/data-access/tutorials/displaying-data-with-the-objectdatasource-vb

以下是我要做的事情http://www.asp.net/data-access/tutorials/displaying-data-with-the-objectdatasource-vb

that tutorial is exactly what I am trying to achieve however I do not understand what the supplierstableadpater, northwindtableadapters are. I can only assume that I am not doing exactly the same thing as that tutorial.

那个教程正是我想要实现的,但是我不明白所有的供应商都是如此。我只能假设我没有做与该教程完全相同的事情。

What I have is a simple sql storedprocedure that selects all employeedetails.And also another sql stored procedure that selects just a few columns from the employees table. On my frist page I am going to list all the employee names in a gridview and when they click the employee name it should take them to another page and show that employee's details. Seems like you have to use an object datasource to achieve this but is there an easier way to achieve creating a class that calls the 2 stored procedures that I have that i would be able to then link them with an objectdatsource?

我所拥有的是一个简单的sql storedprocedure,它选择所有employeedetails。还有另一个sql存储过程,它只从employees表中选择几列。在我的第一页上,我将列出gridview中的所有员工姓名,当他们点击员工姓名时,应该将他们带到另一个页面并显示该员工的详细信息。好像你必须使用一个对象数据源来实现这一点,但是有一种更简单的方法来实现创建一个调用我拥有的2个存储过程的类,然后我可以将它们与objectdatsource链接起来吗?

I dont expect you to write code for me as I want to learn how to do this myself just hoping someone had some info on where I could go to read up on how to get this done.

我不希望你为我编写代码,因为我想学习如何自己这样做,只是希望有人知道我可以去哪里阅读如何完成这项工作。

Thanks

1 个解决方案

#1


2  

Read the previous articles:

阅读以前的文章:

http://www.asp.net/data-access/tutorials/creating-a-data-access-layer-vb
and
http://www.asp.net/data-access/tutorials/creating-a-business-logic-layer-vb

http://www.asp.net/data-access/tutorials/creating-a-data-access-layer-vb和http://www.asp.net/data-access/tutorials/creating-a-business-逻辑层-VB

They will provide the background you need.

他们将提供您需要的背景。

#1


2  

Read the previous articles:

阅读以前的文章:

http://www.asp.net/data-access/tutorials/creating-a-data-access-layer-vb
and
http://www.asp.net/data-access/tutorials/creating-a-business-logic-layer-vb

http://www.asp.net/data-access/tutorials/creating-a-data-access-layer-vb和http://www.asp.net/data-access/tutorials/creating-a-business-逻辑层-VB

They will provide the background you need.

他们将提供您需要的背景。