具有存储过程的DataGridView [英] DataGridView with Stored Procedures

问题描述

亲爱的每个人

我正在按照n层方法使用SQL Express构建VB.Net应用程序.我已经使用VB.Net前端完成了BLL和DAL.我已经为CRUD创建了所有必需的SQL SP.因为我是VS.Net的新手，所以我不知道如何将DataGridView与存储过程一起使用来进行显示，插入，更新和更新.通过编码删除数据.

我们将为您提供帮助.

Dear Everyone

I am building a VB.Net application with SQL Express following n-tier approach. I have completed the BLL and DAL with VB.Net front-end. I have created all the required SQL SP''s for CRUD. Since, I am new to VS.Net, I dont know how to use the DataGridView with Stored procedures to Display, INSERT, UPDATE & Delete data through Coding.

Your help will be appreciated.

推荐答案

如果您已完成DAL，则问题何在? ，因为您要询问的所有内容都应该已经在DAL中了?您不要在DataGridView中使用存储过程.您将其绑定到数据库源，例如DataSet，DataTable等，您已经编写了一些自定义集合.

If you''ve completed the DAL, what''s with the question, since everything you''re asking should be already be in the DAL?? You don''t use stored procedures with the DataGridView. You bind it to a database source, such a a DataSet, DataTable, ..., some custom collection you''ve written.

这篇关于具有存储过程的DataGridView的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！