如果没有参数，我们如何使用存储过程来检索值.两个表合并成一个. [英] how can we retrieve values using stored procedure in case there no parameters..two tables are merged vid one.

问题描述

CREATE PROCEDURE usp_Join
SELECT JoinOne.Name,JoinTwo.FathersName,JoinThree.Address
from JoinOne,JoinTwo,JoinThree
Where JoinOne.ID=JoinTwo.ID and JoinOne.ID=JoinThree.ID

使用c#在asp.net中给出的命令来检索此过程是什么...我想将此值放在数据列表中.任何人都可以帮助我吗?

whats the command to be give in asp.net using c# for retrieving this procedure...and i want to place this values in datalist..any one will help me??

推荐答案

以sql命令的形式调用该过程的执行，并将结果放入数据集中.之后，您将进行所需的操作.

call the execution of this procedure as sql command and put this result into a dataset.after that do wahterver you want.

ADO.NET的教程:
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx [ ^ ]

LINQ的教程:
http://www.programmersheaven.com/2/CSharp3-4 [

Tutorial for ADO.NET:
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx[^]

Tutorial for LINQ:
http://www.programmersheaven.com/2/CSharp3-4[^]

Regards,
Eduard

这篇关于如果没有参数，我们如何使用存储过程来检索值.两个表合并成一个.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！