如何用SQL VB.NET制作确认页面 [英] How to make confirmation page with SQL VB.NET
问题描述
早上好，所有代码项目专家。我的软件项目需要一些帮助。
我正在为确认页面寻找一些想法和代码。
我的应用程序正在对表单进行注册并将数据发送到SQL Server。但是我需要在他们进入实际数据库之前确认这些注册。
假设我正在对我的应用程序进行注册，但需要在管理员确认之前转到主数据库。
应用程序有三种类型的用户。
1.管理员（所有访问权限）
2.学院（部分访问）
3.学生（部分访问）
我尝试过：
尝试制作一个临时数据库，其中数据库保存用于临时目的。
确认页面链接到绑定的临时数据库和datagriview。
如果通过确认按钮接受，则它们被移动到主数据库。
Good morning to all codeproject experts. I need some help for my software project.
Well I'm looking for some ideas and code too for A confirmation page.
My application is making registration over form and sending data to SQL server. But I need to confirm those registration before they took place to actual database.
Let say I'm doing registration over my application but that need to confirmed by administrators before it goes to main database.
Application has three type of users.
1. Admin ( All access )
2. Faculty ( Partial access )
3. Student ( Partial access )
What I have tried:
Tried making a temporary database where database save for temporary purpose.
Confirmation page is linked to that temporary database and a datagriview binded.
If accepted by confirmation button then they were moved to main database.
推荐答案
你应该避免一个临时数据库，虽然我怀疑你的意思是一个表而不是整个数据库。这是一个选项 - 一个升级表，但可能变得难以管理
或
查看来自@A_Griffin的评论 - 一个标志，说明记录是否已确认
或
状态字段，从New移动到Confirmed，可能打开到Cancelled等
或
A 确认者或确认日期字段，以便您可以跟踪/审核确认。
我过去多次使用的是一个组合status，status_date和status_changed_by
You should avoid having a temporary database, although I suspect that you meant a table not an entire database. It is one option - a "staging" table, but can become difficult to manage
OR
See the comment from @A_Griffin - a flag that says whether the records is "confirmed"
OR
A status field which moves from New to Confirmed and possibly on to Cancelled etc
OR
A "Confirmed By" or a "Confirmed Date" field so you can track/audit the confirmations.
One I've used several times in the past is a combination of status, status_date and status_changed_by
这篇关于如何用SQL VB.NET制作确认页面的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
