求帮忙!!TextBox1的数据修改不了的问题
代码是这样的
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If TextBox1.Text = "" Or TextBox2.Text = "" Then
MsgBox("错误，请检查", MsgBoxStyle.Information)
Else
Try
Dim number As Integer = gys.ListView1.Items.IndexOf(gys.ListView1.FocusedItem)
Dim str As String = gys.ListView1.Items(number).SubItems(0).Text
Dim objconn As New SqlClient.SqlConnection()
Dim objcomm As New SqlClient.SqlCommand()
Dim objda As New SqlClient.SqlDataAdapter()
Dim objds As New DataSet()
objconn.ConnectionString = "Data Source=GZ-20121123HHXY\MSSQLSERVER07;Initial Catalog=CangKuGuanLi;Integrated Security=True"
objconn.Open()
Dim comstr As String = "update GongYingShang set 编号='" + TextBox1.Text + "',名称='" + TextBox2.Text + "',地址='" + TextBox3.Text + "',联系人='" + TextBox4.Text + "',电话='" + TextBox5.Text + "',传真='" + TextBox6.Text + "',Email='" + TextBox7.Text + "',公司网址='" + TextBox8.Text + "'where 编号='" + TextBox1.Text + "'"
objcomm.CommandText = comstr
objcomm.Connection = objconn
objda.SelectCommand = objcomm
objcomm.ExecuteNonQuery()
objconn.Close()
MsgBox("修改成功")
Me.Close()
……
运行的时候从“名称”开始以后的都可以修改内容，但是“编号”修改了以后就是不变，还是原来添加的
我是菜鸟 求各位帮忙看下应该怎么解决？
[解决办法]
你的编号可能是数据表的主KEY，唯一的。
你已经在WHERE那里用编号做条件了，为什么还要去更新它呢？
[解决办法]
问题where 编号='" + TextBox1.Text 。当条件为真时，即在数据库中找到TextBox1.Text编号时，Update成功，当你更改了TextBox1.Text，即在数据库中找不到TextBox1.Text编号是没有数据更新的.