如何为网格视图编写存储过程 [英] how to write stored procedures for grid view

问题描述

如何在asp中编写用于网格视图控制的存储过程dot net

how to write stored procedure for grid view control in asp dot net

推荐答案

这是一个完全没有意义的单词序列。 存储过程是您数据库中的内容，在您的情况下，网格视图位于某个网页上。存储过程和数据库本身与控件，ASP.NET，UI等完全无关。

-SA

This is a sequence of words which makes no sense at all. "Stored procedure" is something in you database, and "grid view" is on some Web page, in your case. Stored procedures and the database itself are totally agnostic to controls, ASP.NET, UI and the like.

—SA

如何为网格视图编写存储过程

我会说无效的问题。



存储过程和网格没有直接关系。存储过程是一组预编译查询，用于从数据库中检索数据。 Grid是用于显示数据的服务器控件。



现在，为网格或任何其他控制或原因编写SP没有区别。 SP是检索数据，只需编写SP并获取数据。使用检索的数据作为网格源。



以下将帮助您：

MSDN：如何：使用Visual C＃.NET在ASP.NET中调用SQL Server存储过程 [ ^ ]

MSDN ：HOW TO：使用ADO.NET和Visual C＃.NET调用参数化存储过程 [ ^ ]

ADO.NET：使用存储过程 [ ^ ]

MSDN：CREATE PROCEDURE（Transact-SQL） [ ^ ]

how to write stored procedure for grid view
Invalid question I would say.

Stored Procedures and grid are not directly related. Stored Procedure are set of pre-compiled queries that are used to retrieve data from database. Grid is a server control to show data.

Now, there is no difference in writing a SP for a grid or any other control or reason. SP is to retrieve data, just write an SP and get the data. Use the data retrieved as a source for grid.

Following will help you:
MSDN: HOW TO: Call SQL Server Stored Procedures in ASP.NET by Using Visual C# .NET[^]
MSDN: HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET[^]
ADO.NET : Using Stored Procedures[^]
MSDN: CREATE PROCEDURE (Transact-SQL)[^]

这篇关于如何为网格视图编写存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！