如何用VB实现将SQL中数据在列表框中显示并删除选中的内容

发布网友 发布时间：2022-04-10 02:54

我来回答

共3个回答

懂视网 时间：2022-04-10 07:15

Sub UpdateTask() Dim connStr As String = ConfigurationManager.connectionStrings("TaxSoftwareConnection").ToString() if File.Exists(path) Dim file As FileInfo=New FileInfo(path) Dim sr As StreamReader = file.OpenText() Dim script As String=sr.ReadToEnd() Try Dim conn As SqlConnection=new SqlConnection(connStr) conn.Open() Dim cmd As SqlCommand=conn.CreateCommand() cmd.CommandText=script cmd.ExecuteNonQuery() conn.Close() Catch ex As Exception End Try sr.Close() file.Delete() End If End Sub

 

VB读取sql文并删除

标签：str   rip   exist   task   cmd   man   creat   ons   删除   

热心网友 时间：2022-04-10 04:23

控件绑定数据库吗？？？

或者分两步: 1.通过sql语句 删除数据库中的相应内容
2.再回显到控件中

热心网友 时间：2022-04-10 05:41

Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("userlink.mdb"))
Dim cmd As New OleDbCommand("delete from userform where username='" & Session("username") & "'", conn)
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()

End Sub
End Class
End Sub
End Class