無代碼無真相!

站在用戶的角度思考問題,與客戶深入溝通,找到白山網(wǎng)站設(shè)計(jì)與白山網(wǎng)站推廣的解決方案,憑借多年的經(jīng)驗(yàn),讓設(shè)計(jì)與互聯(lián)網(wǎng)技術(shù)結(jié)合,創(chuàng)造個(gè)性化、用戶體驗(yàn)好的作品,建站類型包括:成都網(wǎng)站制作、成都網(wǎng)站設(shè)計(jì)、企業(yè)官網(wǎng)、英文網(wǎng)站、手機(jī)端網(wǎng)站、網(wǎng)站推廣、域名注冊(cè)、網(wǎng)站空間、企業(yè)郵箱。業(yè)務(wù)覆蓋白山地區(qū)。
話說,應(yīng)該看你這個(gè)實(shí)例a是作用域的變量,如果僅僅是在函數(shù)A中定義的局部變量,那么應(yīng)該會(huì)在函數(shù)運(yùn)行完成的時(shí)候自動(dòng)銷毀的。這個(gè)應(yīng)該是變量的生存期問題。
但是,根據(jù)你所提供的描述來看,你的這個(gè)a類應(yīng)該定義的至少是一個(gè)是模塊級(jí)別的變量,不然,你在函數(shù)B中,用另一個(gè)b類來引用a實(shí)例是無法實(shí)現(xiàn)的。因此,我感覺函數(shù)A運(yùn)行完了之后,你的a實(shí)例應(yīng)該并沒有銷毀,只有等到整個(gè)模塊被結(jié)束的時(shí)候才能銷毀。
(PS: VB.net沒有用過,以上僅僅是基于vb6.0的類模塊使用方法所提出的一點(diǎn)參考建議!)
'批量刪除信息
Dim flag As Boolean = False '標(biāo)識(shí)是否刪除成功
For index = 0 To DataGridView1.Rows.Count - 1
If dgDataGridView1tem("控件名稱", index).Value=true Then
Dim orderId As Integer = Integer.Parse(DataGridView1.Item("列名", index).Value)
'調(diào)用刪除方法
If 類.方法名() Then
flag=True
End If
End If
Next
if flag=true then
messagebox.show("刪除成功!")
else
messagebox.show("刪除失敗!")
當(dāng)然:類.方法名() 這個(gè)方法返回一個(gè)布爾值,呵呵,也可以是其它類型,到時(shí)候可要變哦
方法有多種。
可以dataAdapter.Fill到數(shù)據(jù)表應(yīng)該,設(shè)置幾個(gè)command,再通過dataAdapter.Update就可以更新數(shù)據(jù)了。不過表要有一個(gè)關(guān)鍵的key吧。
另外一種直觀一點(diǎn):
也需要表有個(gè)關(guān)鍵key有就是關(guān)鍵字段。
你datagridview.reomveAt(index)同時(shí)執(zhí)行sqlcommand("delete * From table where keyFild='" key "'")就可以。
參考一個(gè)實(shí)例,如下:
Private Sub bitDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bitDelete.Click
Dim oraConn As New OracleConnection()
oraConn.ConnectionString = " data source=數(shù)據(jù)庫(kù)名字;user id=賬號(hào);password=密碼"
oraConn.Open()
Dim id As String = DataGridView1.CurrentRow.Cells(0).Value.ToString().Trim()
Dim queryString = "delete from t where id ='" id號(hào) "'"
Dim adapter As OracleDataAdapter = New OracleDataAdapter(queryString,oraConn)
Dim mark As DataSet = New DataSet
adapter.Fill(mark, "Mark")
MessageBox.Show("刪除數(shù)據(jù)成功!")
Dim adapter As OracleDataAdapter = New OracleDataAdapter("select * from t ORDER BY id", oraConn)
Dim score As DataSet = New DataSet()
adapter.Fill(score , "Score ")
DataGridView1.DataSource = score
DataGridView1.DataMember = score .Tables(0).ToString
oraConn.Close()
End Sub
Imports System.Data.OleDb
'Imports System.Data.OracleClient
Imports System.Data.SqlClient
'鏈接Oracle
'cn = New SqlConnection(""Data Source=TNS名稱;Persist Security Info=True;User ID=用戶名;Password=密碼;" ")
'Imports System.Data.OracleClient
'Dim oOracleConn As OracleConnection = New OracleConnection()
'oOracleConn.ConnectionString = ""Data Source=MyOracleDB; User Id=username; Password=passwd; Integrated Security=no; "
'oOracleConn.Open()
'鏈接SQL Server
'cn = New SqlConnection("Data Source=.;Initial Catalog=Sales;Integrated Security=False;User ID=sa;Password=;")
'鏈接Access
'cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" db_path ";Persist Security Info=False")
Public Class Fun_DataBase
Dim cn As OleDbConnection
Dim cm As OleDbCommand
Dim da As OleDbDataAdapter
Dim ds As DataSet
Dim db_path As String = "D:\Documents\Visual Studio 2013\Projects\VBnet1\VBnet1\Resources\Database1.mdb"
Function Fun_sql1(Str_sql As String, V_調(diào)用來源 As String) '按指定sql,反饋1個(gè)查詢值
Try
'Dim cn As New OleDbConnection("Data Source=.;Initial Catalog=Sales;Integrated Security=False;User ID=sa;Password=123456;")
'鏈接Access
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" db_path ";Persist Security Info=False")
cn.Open() 'sql語句執(zhí)行前,必須打開連接
cm = New OleDbCommand(Str_sql, cn)
cm.ExecuteNonQuery()
Dim strValue As String = cm.ExecuteScalar.ToString
'MessageBox.Show(strValue)
Fun_sql1 = strValue
cn.Close()
Fun_sql1 = True
Catch ex As Exception
MessageBox.Show(V_調(diào)用來源 ":執(zhí)行sql語句失敗!" Str_sql)
Fun_sql1 = False
End Try
End Function
Function Fun_sqln(Str_sql As String, V_調(diào)用來源 As String) '按指定sql,反饋1行n列查詢值
Try
'鏈接Access
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" db_path ";Persist Security Info=False")
cn.Open() 'sql語句執(zhí)行前,必須打開連接
Dim cmd As New OleDbCommand("select * from grade", cn)
'Dim dr As SqlDataReader
Dim dr As OleDbDataReader
dr = cmd.ExecuteReader()
Dim strDisplay As String = ""
While dr.Read()
Fun_sqln = dr(0).ToString "|"
End While
cn.Close()
Fun_sqln = True
Catch ex As Exception
MessageBox.Show(V_調(diào)用來源 ":執(zhí)行sql語句失敗!" Str_sql)
Fun_sqln = False
End Try
'Dim s = Split(F.Fun_sqln("ef"), "|")
'Dim i As Integer
'i = UBound(s)
'For i = 0 To UBound(s)
' MessageBox.Show(s(i))
'Next
End Function
Public Function Fun_sql_exec(Str_sql As String, V_調(diào)用來源 As String) '執(zhí)行指定sql,反饋T|F
Try
'鏈接Access
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" db_path ";Persist Security Info=False")
cn.Open() 'sql語句執(zhí)行前,必須打開連接
cm = New OleDbCommand(Str_sql, cn)
cm.ExecuteNonQuery()
cn.Close()
Fun_sql_exec = True
Catch ex As Exception
MessageBox.Show(V_調(diào)用來源 ":執(zhí)行sql語句失敗!" Str_sql)
Fun_sql_exec = False
End Try
End Function
這不是廢話嗎,DeleteSubKey只能刪除調(diào)用實(shí)例的子項(xiàng),并不能直接刪除子子項(xiàng)。
文章題目:關(guān)于vb.net刪除實(shí)例的信息
分享路徑:http://chinadenli.net/article31/dsgjhpd.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供全網(wǎng)營(yíng)銷推廣、品牌網(wǎng)站建設(shè)、網(wǎng)站策劃、Google、網(wǎng)站排名、響應(yīng)式網(wǎng)站
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)