如何创建一个过程以显示表中的详细信息 [英] How to create a procedure to display details from a table

问题描述

.NET是我的新手.我已经创建了一个表.现在我想显示我插入到其中的表的详细信息.请提供一个简单的代码，以便我可以轻松地站立在

I am new to .NET . I have created an table.Now i want to display the details of a table that i have inserted into it.Please provide a simple code so that i can easily under stand

推荐答案

//这是存储过程:

//this is the stored procedure:

ALTER PROCEDURE [dbo].[LogInProcedure]
	@username nvarchar (50),
	@password nvarchar (50),
	@groupnum nvarchar (50)
AS
	SET NOCOUNT ON;
SELECT	* FROM users 
WHERE	user_username=@username AND user_password=@password

//这是从中检索信息的代码:

//this is the code for retrieving info from it:

public bool doLogIn(string username, string password)
        {
            con.Open();

            SqlCommand cmd = new SqlCommand("LogInProcedure", con);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddWithValue("@username", username);
            cmd.Parameters.AddWithValue("@password", password);

            SqlDataReader read = cmd.ExecuteReader();

            if (read.HasRows)
                return true;
            else
                return false;
        }

您可以参考以下链接，这些链接是 gridview [^ ]
面向初学者的GridView事件 [初学者教程或使用GRIDVIEW控件的指南 [ CodeProject常见问题系列1:ASP.NET GridView [ ^ ]

You can refer the below links which are beginner articles on gridview [^]
GridView Events For Beginners[^]
beginners tutorial or guide on using GRIDVIEW control[^]
CodeProject Frequently Asked Questions Series 1: The ASP.NET GridView[^]

这篇关于如何创建一个过程以显示表中的详细信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！