If strID <> "" Then
strSQL = "SELECT Title,Author,Source,pid,Content FROM Document Where objectGuid='" + strID + "'"
cn.Open()
Dim MyDataSet As OleDbDataReader
cmd = New OleDbCommand(strSQL, cn)
MyDataSet = cmd.ExecuteReader()
While MyDataSet.Read()
DocTitle.Text = MyDataSet.GetString(0)
Author.Text = MyDataSet.GetString(1)
Company.Text = MyDataSet.GetString(2)
DocGuid.Value = strID
DocContent.Text = MyDataSet.GetString(4)
Dim i As Integer
For i = 0 To SubjectID.Items.Count - 1
If SubjectID.Items(i).Value = MyDataSet.GetValue(3) Then
SubjectID.Items(i).Selected = True
End If
Next
End While
MyDataSet.Close()
cn.Close()
End If
strSQL = "SELECT Title,Author,Source,pid,Content FROM Document Where objectGuid='" + strID + "'"
cn.Open()
Dim MyDataSet As OleDbDataReader
cmd = New OleDbCommand(strSQL, cn)
MyDataSet = cmd.ExecuteReader()
While MyDataSet.Read()
DocTitle.Text = MyDataSet.GetString(0)
Author.Text = MyDataSet.GetString(1)
Company.Text = MyDataSet.GetString(2)
DocGuid.Value = strID
DocContent.Text = MyDataSet.GetString(4)
Dim i As Integer
For i = 0 To SubjectID.Items.Count - 1
If SubjectID.Items(i).Value = MyDataSet.GetValue(3) Then
SubjectID.Items(i).Selected = True
End If
Next
End While
MyDataSet.Close()
cn.Close()
End If
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货