vb.net update 方面问题...
Me.conn = New System.Data.SqlClient.SqlConnection
Dim Cm As New SqlClient.SqlCommand
Dim strUpdatename As String = "update yonghu set (id= ' " + Me.TextBox1.Text + " '),(psw= ' " + Me.TextBox3.Text + " ') where (id= ' " + Me.TextBox1.Text + " ') "
If TextBox2.Text = TextBox3.Text Then
Me.conn.ConnectionString = "workstation id= " "EASYSOFT-2CA1DB " ";packet size=4096;integrated security=SSPI;initia " & _
"l catalog=myfirstdb;persist security info=False "
Cm.Connection = conn
Cm.CommandText = strUpdatename
MessageBox.Show( "密码修改成功! ", "student-system ", MessageBoxButtons.OK, MessageBoxIcon.Information)
conn.Close()
Me.Close()
Else
System.Windows.Forms.MessageBox.Show( "密码确认失败！ ", "student-system ", MessageBoxButtons.OK, MessageBoxIcon.Information)
End If
以上这些就是我的代码.为什么老是更新不了数据库里数据.数据库表名为 yonghu
字段就两个 id psw ,窗口为三个输入筐,用户,新密码,确认密码
请高手指点......
[解决办法]
Cm.Connection = conn
if conn.state=Closed then conn.open()
Cm.CommandText = strUpdatename
Cm.ExecuteNonQuery
这样就好了
