Question

ExecuteNonQuery: CommandText 属性尚未初始化。怎样进行初始化呢？部分代码如下，期待您的回答。

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As New SqlConnection
Dim cmd As New SqlCommand
Dim CommandText As New SqlString
conn.ConnectionString = "Data Source=localhost;Initial Catalog=学生选课系统;Integrated Security=SSPI;Packet Size=4096;User ID=ab;Password=''"
conn.Open()
cmd.Connection = conn
If pwd1.Text = Session("pwda") Then
If pwd2.Text = pwd3.Text Then
cmd.CommandText = "UPDATE AdministorInfo SET AdministorPwd='" & pwd2.Text + "' where AdministorName='" & Session("namea") + "'"
Label1.Text = "修改成功"
Else
Label1.Text = "密码不一致"

End If
Else
Label1.Text = "旧密码不正确"
End If
cmd.ExecuteNonQuery()
conn.Close()
End Sub

Answer 1

一般出现那种情况就是程序运行到CommandText的地方执行SQL语句的时候，sql语句不能执

行通过就会报介样的错误...

Answer 2

你的判断语句的问题， if pwd1.Text=Session("pwda") Then这句要是不符合，那么就直接跳到Else
Lable1.Text="密码不一致“那里去了，不会往下执行的