日期:2014-05-20  浏览次数:20757 次

新手菜鸟。鄙视着表进!!怎么提交注册信息?
毕业了,做毕业设计。但平时没怎么认真学。好多都不会。所以来这里问问。一下是代码。
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...();

就这样。