删除记录后无法刷新问题?
删除记录后,DATAGRID中的数据还显示在里面,但实际已经被删除了,刷新页面也不成,通过查找后才能发现数据已经不见了,想实现在记录真正被删除的同时,DATAGRID表中也不显示这条数据了.这是我写的代码,帮忙给改改.
Private Sub DataGrid1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataGrid1.SelectedIndexChanged
Dim index As Int16
Dim key As String
index = DataGrid1.SelectedIndex
key = DataGrid1.DataKeys(index).ToString()
Response.Write("<script> window.open('telecom_del_confirm.aspx" + "?id=" + key + "', 'newwindow', 'height=120, width=220, top=0,left=0, toolbar=no, menubar=no, scrollbars=no, resizable=no,location=no,status = no ') </script>")
问题点数：5、回复次数：3Top
1 楼wlhd3000（点点滴滴）回复于 2006-03-20 09:04:39 得分 1
删除完数据DataGrid重新绑定一次数据就可以了Top
2 楼canon3（神山）回复于 2006-03-20 09:30:41 得分 0
能帮着写详细些吗？Top
3 楼xiazhexuedehai（王静）回复于 2006-03-22 12:45:43 得分 4
Dim strQ As String
Dim s As Boolean
strQ = "确定删除 用户信息" + Me.TextBox1.Text.Trim() + "的信息"
If MsgBox(strQ, MsgBoxStyle.YesNo + MsgBoxStyle.Question, "提示信息") = MsgBoxResult.No Then
Exit Sub
End If
strQ = "Delete From 用户信息 Where 用户名='" & Trim(Me.TextBox1.Text) & "'"
dbcon.dbSqlWork(strQ)
Try
s = True
MsgBox("数据删除完毕")
strQ = "select * from 用户信息"
Me.DataGrid1.DataSource = dbcon.dbcon_View(strQ)
ClearData() '删除完毕后清除数据
Catch
MsgBox("数据删除失败")
End Try
这是我写的你侃侃,你没从新帮定数据就无法刷新Top
