C#_ADO.NET验证用户登录

模拟论坛登录账号

要求用户输入账号和密码 从数据库中查找是否有此账号 密码和账号匹配则显示登录成功 否则
提示登录失败

SQL 建库代码

use master
go

if exists(select * from sysdatabases where name='LoginTest')
drop database LoginTest
go

create database LoginTest
on primary
(
	Name='LoginTest_Data',
	FileName='D:\LoginTest.mdf',
	Size=5mb,
	Maxsize=10mb,
	FileGrowth=1mb
)

Log on
(
	Name='LoginTest_Log',
	FileName='D:\LoginTest.ldf',
	size=5mb,
	Maxsize=10mb,
	FileGrowth=1mb
)
go

use LoginTest
go

if exists(select * from sysobjects where name='LoginTable')
drop table LoginTable
go

create table LoginTable
(
	ID int IDENTITY PRIMARY KEY not null,
	UserId varchar(20) not null,
	Pwd	varchar(20) not null	
)
go

insert into LoginTable(UserId,Pwd) values ('amd','123')
go

C# 代码