StrSQL="Delete from table where aaa='"& text.text &"'"
解决方案 »
- Memcache缓存问题:linux系统用服务器,windows server端(asp.net)可以操作不?
- 怎么 把 日期放入 table
- 求救,IIS7.0下报脚本错误!
- 如何在web里面做出像应用程序里面tabcontrol控件那样的效果?
- The requested resource is in use.大家有没有看到这种错误
- 使用FreeTextBox出了问题
- 请问大家工作时做一个这样的page 要几多时间啊?我们这里是作坊式的开发,觉得自己是一个井底之蛙啊
- 新手还是老手,写代码有点美感,好不好 ??????
- 高手帮忙?版本问题,版权问题
- 【谢谢】原网站中有多个二级域名,现在网站更换了新域名,该怎么做 301 ?
- 如何动态生成Enum的内容?
- 有关winxp的问题
Imports System.Data
Imports System.Data.OleDb
定义区:
Dim StrCon As String = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" _
& Server.Mappath("EcwayMed.Mdb")
Dim Conn As New OleDbConnection(StrCon)删除代码区:
If Conn.State = ConnectionState.Closed Then
Conn.Open()
End If
Dim deleteCmd As New OleDbCommand("Delete From [letters] Where title='" & e.Item.Cells(3).Text.Trim() & "'", Conn)
deleteCmd.ExecuteNonQuery()//成功
BindGd()//数据绑定
Private Sub dgCustomers_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles dgCustomers.DeleteCommand
Dim strID As String = e.Item.Cells(3).Text
Dim RowFilter As String = "DepartID='" & strID & "'"
Dim tempTable As DataTable = dv.Table
Dim cRow As DataRow = tempTable.Select(RowFilter)(0)
cRow.Delete()
Me.SqlDa.Update(dv.Table.Select(Nothing, Nothing, DataViewRowState.Deleted)) BindGrid()
End Sub
不需要from