可能我的意思 表达的不清楚,

老师要我们做个课件,用VB做通讯录. 在开始界面上 有个 输入用户名密码的功能,但是 小弟现在只有把密码写在代码中的 能力.

请问怎么通过数据库的结合能够完成,注册用户,更改密码这些功能.

最好能有 现成的 我参考一下咯!. 谢谢了!

呵呵，这个很简单的，自己试试吧

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click dim SearchSQL as string SearchSQL = "SELECT * FROM " & Trim(textbox1.text) '构造查询 Module1.ExecuteSQL(SearchSQL, tablename) '调用查询函数 Dim newrow As DataRow newrow = Module1.mytable.NewRow newrow.Item(0) = Trim(TxtUserName.Text) '给第一个字段赋值 newrow.Item(1) = Trim(TxtUserPassword.Text) '给第二个字段赋值 mytable.Rows.Add(newrow) '添加新用户 Module1.cmd = New OleDbCommandBuilder(Module1.ADOcmd) '使用自动生成的SQL语句 Module1.ADOcmd.Update(Module1.ds, tablename) '对数据库进行更新 MsgBox("添加用户成功！", vbOKOnly + vbExclamation, "信息框") End Sub

'Imports System.Data.OleDb '引入ADO.NET操作命名空间 Public Class FrmLogin Inherits System.Windows.Forms.Form

#Region " Windows 窗体设计器生成的代码 "

Public Sub New() MyBase.New()

'该调用是 Windows 窗体设计器所必需的。 InitializeComponent()

'在 InitializeComponent() 调用之后添加任何初始化

End Sub

'窗体重写处置以清理组件列表。 Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub

'Windows 窗体设计器所必需的 Private components As System.ComponentModel.IContainer

'注意：以下过程是 Windows 窗体设计器所必需的 '可以使用 Windows 窗体设计器修改此过程。 '不要使用代码编辑器修改它。 Friend WithEvents Label1 As System.Windows.Forms.Label Friend WithEvents Label2 As System.Windows.Forms.Label Friend WithEvents Label3 As System.Windows.Forms.Label Friend WithEvents Button1 As System.Windows.Forms.Button Friend WithEvents Button2 As System.Windows.Forms.Button Friend WithEvents TxtUserName As System.Windows.Forms.TextBox Friend WithEvents TxtUserPassword As System.Windows.Forms.TextBox Friend WithEvents ErrorProvider1 As System.Windows.Forms.ErrorProvider <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.Label1 = New System.Windows.Forms.Label() Me.Label2 = New System.Windows.Forms.Label() Me.Label3 = New System.Windows.Forms.Label() Me.TxtUserName = New System.Windows.Forms.TextBox() Me.TxtUserPassword = New System.Windows.Forms.TextBox() Me.Button1 = New System.Windows.Forms.Button() Me.Button2 = New System.Windows.Forms.Button() Me.ErrorProvider1 = New System.Windows.Forms.ErrorProvider() Me.SuspendLayout() ' 'Label1 ' Me.Label1.AutoSize = True Me.Label1.Font = New System.Drawing.Font("华文彩云", 26.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(134, Byte)) Me.Label1.ForeColor = System.Drawing.SystemColors.Desktop Me.Label1.Location = New System.Drawing.Point(34, 33) Me.Label1.Name = "Label1" Me.Label1.Size = New System.Drawing.Size(288, 46) Me.Label1.TabIndex = 0 Me.Label1.Text = "教务信息系统" ' 'Label2 ' Me.Label2.AutoSize = True Me.Label2.Font = New System.Drawing.Font("宋体", 10.5!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(134, Byte)) Me.Label2.Location = New System.Drawing.Point(45, 98) Me.Label2.Name = "Label2" Me.Label2.Size = New System.Drawing.Size(61, 20) Me.Label2.TabIndex = 1 Me.Label2.Text = "用户名" ' 'Label3 ' Me.Label3.AutoSize = True Me.Label3.Font = New System.Drawing.Font("宋体", 10.5!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(134, Byte)) Me.Label3.Location = New System.Drawing.Point(45, 142) Me.Label3.Name = "Label3" Me.Label3.Size = New System.Drawing.Size(42, 20) Me.Label3.TabIndex = 2 Me.Label3.Text = "密码" ' 'TxtUserName ' Me.TxtUserName.Location = New System.Drawing.Point(158, 98) Me.TxtUserName.Name = "TxtUserName" Me.TxtUserName.Size = New System.Drawing.Size(142, 25) Me.TxtUserName.TabIndex = 3 Me.TxtUserName.Text = "" ' 'TxtUserPassword ' Me.TxtUserPassword.Location = New System.Drawing.Point(158, 142) Me.TxtUserPassword.Name = "TxtUserPassword" Me.TxtUserPassword.PasswordChar = Microsoft.VisualBasic.ChrW(42) Me.TxtUserPassword.Size = New System.Drawing.Size(142, 25) Me.TxtUserPassword.TabIndex = 4 Me.TxtUserPassword.Text = "" ' 'Button1 ' Me.Button1.Font = New System.Drawing.Font("宋体", 10.5!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(134, Byte)) Me.Button1.Location = New System.Drawing.Point(215, 197) Me.Button1.Name = "Button1" Me.Button1.Size = New System.Drawing.Size(106, 43) Me.Button1.TabIndex = 5 Me.Button1.Text = "取消" ' 'Button2 ' Me.Button2.Font = New System.Drawing.Font("宋体", 10.5!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(134, Byte)) Me.Button2.Location = New System.Drawing.Point(45, 197) Me.Button2.Name = "Button2" Me.Button2.Size = New System.Drawing.Size(106, 43) Me.Button2.TabIndex = 6 Me.Button2.Text = "确定" ' 'ErrorProvider1 ' Me.ErrorProvider1.DataMember = Nothing ' 'FrmLogin ' Me.AutoScaleBaseSize = New System.Drawing.Size(8, 18) Me.ClientSize = New System.Drawing.Size(384, 272) Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.Button2, Me.Button1, Me.TxtUserPassword, Me.TxtUserName, Me.Label3, Me.Label2, Me.Label1}) Me.Name = "FrmLogin" Me.Text = "登录" Me.ResumeLayout(False)

End Sub

#End Region Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Me.Dispose() End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim tablename As String tablename = "userID" '表的名称 SearchSQL = "SELECT 用户名, 密码 FROM userID WHERE (用户名 = '" & TxtUserName.Text & " ') " Try Module1.ExecuteSQL(SearchSQL, tablename) '查询函数

If Module1.myrow.Item(1) = TxtUserPassword.Text Then '比较输入密码和数据库的密码 Dim newFrmmain As New FrmMain() newFrmmain.Show() Me.Hide() Else Exit Sub End If Catch MsgBox("没有该用户", vbOKOnly + vbExclamation, "警告") End Try End Sub Private Sub TxtUserName_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles TxtUserName.Validating If TxtUserName.Text = "" Then ErrorProvider1.SetError(TxtUserName, "用户名不能为空") Else ErrorProvider1.SetError(TxtUserName, "") End If End Sub

Private Sub TxtUserPassword_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles TxtUserPassword.Validating If TxtUserPassword.Text = "" Then ErrorProvider1.SetError(TxtUserPassword, "密码不能为空") Else ErrorProvider1.SetError(TxtUserPassword, "") End If End Sub

End Class