存储过程中的Asp.net网格视图 [英] Asp.net grid view in stored procedure

问题描述

使用存储过程在Asp.net Grid View控件中进行插入，选择，编辑，更新和删除.
表格详细信息:
部门:
1.DeptID(PK)
2.部门名称

员工
1.员工编号(PK)
2.部门ID(FK)
3.员工姓名
4.年龄


问题:
1.在Asp.net网格视图中填充员工名称，部门名称，年龄吗?
2.使用Asp.net Grid View事件插入，更新和删除员工吗?
3.使用存储过程插入，更新和删除员工吗?

请尽快帮我

Hi,
Insert,Select,Edit,Update and delete in Asp.net Grid View Control using stored procedure.
Table Details:
Dep:
1.DeptID(PK)
2.Department Name

Employee
1.Employee ID(PK)
2.Dept ID(FK)
3.Employee Name
4.Age


questions:
1.Populate the Employee name,Department Name,Age in Asp.net Grid View?
2.Insert,Update and Delete a employee using Asp.net Grid View Events?
3.Insert,Update and Delete a employee using Stored Procedure?

Pl help me soon

推荐答案

请参阅此线程
如何通过以下方式在gridview中插入，更新，删除，数据存储过程 [ ^ ]

refer this thread
how to insert,update,delete,data in gridview through stored procedure,[^]

尝试以下链接:-

http://msdn.microsoft.com/en-us/library/ms972948.aspx [ ^ ]
http://www.aspdotnet-suresh.com/2012/05/aspnet-gridview-examples-and-samples-in.html [

Try these links :-

http://msdn.microsoft.com/en-us/library/ms972948.aspx[^]
http://www.aspdotnet-suresh.com/2012/05/aspnet-gridview-examples-and-samples-in.html[^]

您已经获得了很多参考链接，我发现了另一篇可能有用的文章.

实际上，我已经创建了这篇文章来帮助所有初学者，

使用ASP插入，更新，搜索和删除(CRUD操作).网络和MySQL [ ^ ]

我已经使用StoredProcedure在数据库上进行操作.尽管我没有使用gridview插入/更新/删除记录，但是本文可能会有所帮助.并且我已经将MySQL用作数据库.

希望这对您有帮助，

谢谢
-Amit Gajjar

Hi,

You already got so many reference link, i found one more article that may be useful.

Actually i have created this article to help all beginner,

Insert, Update, Search and Delete (CRUD operation) using ASP.Net and MySQL[^]

I have used StoredProcedure to operate on database. Although i am not inserting/updating/deleting records using gridview but this article may helpful.And i have used MySQL as database.

Hope this helps you,

Thanks
-Amit Gajjar

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