用vb.net查询有关SQL Server数据库的信息 [英] query about the SQL server database with vb.net

问题描述

你好，
我正在做一个项目，因为我有一些疑问.我的项目是向内和向外系统".在这个系统中，我有2个用户管理员"和用户"，并且当所有用户将自己注册为该系统的成员时，他们提到UserType字段的意思是(Admin/User). > 为此，我有用于注册表单和登录表单的UserMaster表.
现在我有一个查询，在登录表单中我没有提到UserType作为TextBox，但是当我在Sqldatabase中检查用户名和密码时，系统会自动检查谁是他(她)(管理员/用户)，并通过它来检查那里.页面已打开.

Hello,
I m doing a project in that I have some query. My project is Inward and outward System.In this I have a 2 users Admin and user, and when the all the users register self as a member of this system that time they mention the UserType field means (Admin/User).
and for this I have UserMaster Table for both Register Form and Login Form.
Now I have query that, in Login form i m not mention UserType as a TextBox, but when i check the username and password in the Sqldatabase that time it is automatically checked who is he/she (Admin/User) and through this the there Home page is opened.
Plzzzz help me if you not understand then plz tell me.

推荐答案

在登录表单中，您首先需要根据用户登录名和密码获取详细信息(用户类型). br/> 获取详细信息后，请检查用户类型并重定向到特定页面.

In login form first you need to get the details(usertype) based on user login and password.
after getting the details check the usertype and redirect to the specific page.

这篇关于用vb.net查询有关SQL Server数据库的信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！