登录界面判断用户名和密码是否正确。。。
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

--原理是一样的，在于你想怎么做，无非就是创建一个存储过程