登录界面判断用户名和密码是否正确。。。
Dim mycomm As SqlClient.SqlCommand
mycomm = New SqlClient.SqlCommand("xh", myconn)
mycomm.CommandType = CommandType.StoredProcedure
Dim username As SqlClient.SqlParameter = mycomm.Parameters.Add("@学号", System.Data.SqlDbType.NChar, 10)
Dim pwd As SqlClient.SqlParameter = mycomm.Parameters.Add("@密码", System.Data.SqlDbType.NVarChar, 18)
username.Value = TextBox1.Text
pwd.Value = TextBox2.Text
Dim myreader As SqlClient.SqlDataReader
Try
myconn.Open()
Catch ex As Exception
End Try
myreader = mycomm.ExecuteReader
If myreader.HasRows = False Then
MsgBox("对不起!密码或学号错误,请重新输入!", 16, "提示")
TextBox2.Focus()
请问我的“xh”的存储过程在SQL中怎么写??
存储
sql
ado.net
vb.net
------解决方案--------------------create proc xh(@sno nchar(10),@pass nvarchar(18))
as
select * from users where sno=@sno and password=@pass
--原理是一样的,在于你想怎么做,无非就是创建一个存储过程