如何创建要在asp.net中显示的存储过程 [英] how to create Stored procedure to display in asp.net

问题描述

@ID int，
@UserId int，
@FirstName nvarchar(50)，
@MiddleName nvarchar(50)，
@LastName nvarchar(50)，
@DateOfBirth nvarchar(50)，
@性别varchar(50)，
@电子邮件nv​​archar(50)，
@职业nvarchar(50)，
@State nvarchar(50)，
@City nvarchar(50)，
@Nationality nvarchar(50)


有人可以帮助我为此创建存储过程来检索asp.net页中的所有详细信息吗.使用c#??

@ID int,
@UserId int,
@FirstName nvarchar(50),
@MiddleName nvarchar(50),
@LastName nvarchar(50),
@DateOfBirth nvarchar(50),
@Gender varchar(50),
@Email nvarchar(50),
@Occupation nvarchar(50),
@State nvarchar(50),
@City nvarchar(50),
@Nationality nvarchar(50)


hi can any one help me to create stored procedure for this to retrieve all details in asp.net page..using c#??

推荐答案

所有解决方案都不错，但是观看此视频，
http://www.asp.net/web-forms/videos/sql-2005/creating-and-using-stored-procedures [

All solutions are good, but see this video,
http://www.asp.net/web-forms/videos/sql-2005/creating-and-using-stored-procedures[^].Stored Procedure is best explained here.

请参阅此CP文章以获取一些信息.想法，
通过存储过程插入和检索数据 [

Refer to this CP article to get some idea,
Insert and retrieve data through stored procedure[^]

尝试
http://dbtutorials.com/advanced/using-stored-procedures-cs.aspx [ ^ ]
http://www.macronimous.com/resources/calling_stored_procedures_from_ASP.NET_and_VB.NET.asp [ ^ ]
http://www.macronimous.com/resources/stored_procedures_for_ASP_and_VB_Programmers.asp [ http://msdn.microsoft.com/en-us/library/k10148y1％28v = vs.80％29.aspx [ ^ ]
http://support.microsoft.com/kb/306574 [

Try
http://dbtutorials.com/advanced/using-stored-procedures-cs.aspx[^]
http://www.macronimous.com/resources/calling_stored_procedures_from_ASP.NET_and_VB.NET.asp[^]
http://www.macronimous.com/resources/stored_procedures_for_ASP_and_VB_Programmers.asp[^]
http://msdn.microsoft.com/en-us/library/k10148y1%28v=vs.80%29.aspx[^]
http://support.microsoft.com/kb/306574[^]

这篇关于如何创建要在asp.net中显示的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！