Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(ConfigurationSettings.AppSettings("LawConnStr"))
Dim sql As String = "Update pic set pic" & CStr(Request("no")) & "='" & TextBox1.Text & "',txt" & CStr(Request("no")) & "='" & TextBox2.Text & "',lei" & CStr(Request("no")) & "='" & TextBox3.Text & "',prono" & CStr(Request("no")) & "='" & TextBox4.Text & "',yang" & CStr(Request("no")) & "='" & TextBox5.Text & "',pro" & CStr(Request("no")) & "='" & TextBox6.Text & "' where id=" & CInt(Request("id"))
Dim Cmd As New System.Data.OleDb.OleDbCommand(sql, conn)
conn.Open()
Cmd.ExecuteNonQuery()
conn.Close()
End Sub
textbox改变时.更新语句里的textbox始终没变,所以总是更新不了,请高手帮我看看啊!!!
Dim conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(ConfigurationSettings.AppSettings("LawConnStr"))
Dim sql As String = "Update pic set pic" & CStr(Request("no")) & "='" & TextBox1.Text & "',txt" & CStr(Request("no")) & "='" & TextBox2.Text & "',lei" & CStr(Request("no")) & "='" & TextBox3.Text & "',prono" & CStr(Request("no")) & "='" & TextBox4.Text & "',yang" & CStr(Request("no")) & "='" & TextBox5.Text & "',pro" & CStr(Request("no")) & "='" & TextBox6.Text & "' where id=" & CInt(Request("id"))
Dim Cmd As New System.Data.OleDb.OleDbCommand(sql, conn)
conn.Open()
Cmd.ExecuteNonQuery()
conn.Close()
End Sub
textbox改变时.更新语句里的textbox始终没变,所以总是更新不了,请高手帮我看看啊!!!
if not ispostback then
''拌定数据
end if加个if not ispostback就可以了。不然你每次都重新拌定。。所以更新不了
把你对textBox的初始化赋值放在这儿
End If
End Sub
''拌定数据
end if里面的绑定数据应该怎么写啊? 谢谢!!
''数据绑定
end if
If Not IsPost Back
'绑定代码
End If
里.
数据绑定
end if
if not ispostback then
xx()
end if
end sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
xx()
End Sub Sub xx()
Dim conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(ConfigurationSettings.AppSettings("LawConnStr"))
Dim sql As String = "Update pic set pic" & CStr(Request("no")) & "='" & TextBox1.Text & "',txt" & CStr(Request("no")) & "='" & TextBox2.Text & "',lei" & CStr(Request("no")) & "='" & TextBox3.Text & "',prono" & CStr(Request("no")) & "='" & TextBox4.Text & "',yang" & CStr(Request("no")) & "='" & TextBox5.Text & "',pro" & CStr(Request("no")) & "='" & TextBox6.Text & "' where id=" & CInt(Request("id"))
Dim Cmd As New System.Data.OleDb.OleDbCommand(sql, conn)
conn.Open()
Cmd.ExecuteNonQuery()
conn.Close()
End Sub我是这样写的,还有什么问题吗??
不知道楼主为什么要这样写代码呢?CStr(Request("no")) 是什么意思?有什么意义?
不要把简单问题复杂化了.
Dim conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(ConfigurationSettings.AppSettings("LawConnStr"))
Dim sql As String = "Update pic set pic" & CStr(Request("no")) & "=@pic,txt" & CStr(Request("no")) & "=@txt,lei" & CStr(Request("no")) & "=@lei,prono" & CStr(Request("no")) & "=@prono,yang" & CStr(Request("no")) & "=@yang,pro" & CStr(Request("no")) & "=@pro where id=" & CInt(Request("id"))
Dim Cmd As New System.Data.OleDb.OleDbCommand(sql, conn)
Cmd.Parameters.Add(New System.Data.OleDb.OleDbParameter("@pic", System.Data.OleDb.OleDbType.VarChar, 100))
Cmd.Parameters.Add(New System.Data.OleDb.OleDbParameter("@txt", System.Data.OleDb.OleDbType.VarChar, 100))
Cmd.Parameters.Add(New System.Data.OleDb.OleDbParameter("@lei", System.Data.OleDb.OleDbType.VarChar, 100))
Cmd.Parameters.Add(New System.Data.OleDb.OleDbParameter("@prono", System.Data.OleDb.OleDbType.VarChar, 100))
Cmd.Parameters.Add(New System.Data.OleDb.OleDbParameter("@yang", System.Data.OleDb.OleDbType.VarChar, 100))
Cmd.Parameters.Add(New System.Data.OleDb.OleDbParameter("@pro", System.Data.OleDb.OleDbType.VarChar, 100))
Cmd.Parameters("@pic").Value = TextBox1.Text
Cmd.Parameters("@txt").Value = TextBox2.Text
Cmd.Parameters("@lei").Value = TextBox3.Text
Cmd.Parameters("@prono").Value = TextBox4.Text
Cmd.Parameters("@yang").Value = TextBox5.Text
Cmd.Parameters("@pro").Value = TextBox6.Text
conn.Open()
Cmd.ExecuteNonQuery()
conn.Close()
End Sub谢谢啊! 是这样吗!!