日期:2014-05-17 浏览次数:20550 次
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
If Not IsPostBack Then
BindData()'首次加载时绑定数据
End If
End Sub
Private Sub BindData()’绑定BookList对象的方法
Dim obj As DBController = New DBController
obj.BindListBox("select * from BookInfo order by BookID asc", BookList)
obj.Close()
End Sub
Private Sub BookList_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles BookList.SelectedIndexChanged
Dim BookID As String = BookList.SelectedValue.ToString.Trim'取选中项的值
Dim sqlstr As String = "select * from BookInfo where BookID =" + BookID'根据取值拼结sql字符串
Dim obj As DBController = New DBController
obj.Open()
Dim myreader As SqlDataReader = obj.ExecReaderSql(sqlstr)
If myreader.Read Then'取出记录集,若存在,则对下面的一系列控件赋值
txtBookName.Text = myreader("BookName")
txtPubName.Text = myreader("PubName")
txtBookAuthor.Text = myreader("BookAuthor")
DpStyle.SelectedValue = myreader("BookStyle")
txtUploadDate.Text = myreader("UploadDate")
txtPubDate.Text = myreader("PubDate")
txtSeries.Text = myreader("Series")
txtSubject.Text = myreader("Subject")
DpLanguage.SelectedValue = myreader("Language")
txtISBN.Text = myreader("ISBN")
txtSearchNO.Text = myreader("SearchNO")
DpBookState.SelectedValue = myreader("BookState")
txtPrice.Text = myreader("Price")
txtBarCode.Text = myreader("BarCode")
End If
obj.Close()'关闭数据库对象