新手菜鸟。鄙视着表进!!怎么提交注册信息?
毕业了,做毕业设计。但平时没怎么认真学。好多都不会。所以来这里问问。一下是代码。
Public Class register
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles UserNameText.TextChanged
If UserNameText.Text = "" Then '判断用户名是否为空
ErrorProvider1.SetError(UserNameText, "必须输入用户名!")
UserNameText.Focus()
End If
Exit Sub
End Sub
Private Sub PasswordText_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PasswordText.TextChanged
If PasswordText.Text = "" Then '判断密码是否为空
ErrorProvider1.SetError(PasswordText, "必须输入密码")
PasswordText.Focus()
Exit Sub
End If
End Sub
Private Sub PasswordText2_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PasswordText2.TextChanged
If PasswordText2.Text <> PasswordText.Text Then
ErrorProvider1.SetError(PasswordText2, "两次密码不一致!")
PasswordText2.Focus()
Exit Sub
End If
End Sub
Private Sub EMileText_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles EMileText.TextChanged
If EMileText.Text = "" Then
ErrorProvider1.SetError(EMileText, "请输入邮箱!")
EMileText.Focus()
Exit Sub
End If
End Sub
Private Sub registration_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles registration.Click
'这里的代码怎么写?新手,什么都不懂。
End Sub
Private Sub AnswerText_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AnswerText.TextChanged
End Sub
End Class
要问的是registration.Click 这个注册控件被点击后,怎么把
UserNameText.Text、PasswordText.Text 、EMileText.Text、这三个内容保存到数据库表regTab的对应项UserNamedb、Passworddb、EMiledb中。
------解决方案--------------------
SqlConnection conn = new SQLConnection("connection string");
SqlCommand cmd = new SqlCommand("insert into 表名(字段..) Values(值)"
cmd.Ex...();
就这样。