问题:菜鸟急求vb.net对access数据库操作中取出某列最大值的代码
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db.mdb" Dim con As New OleDb.OleDbConnection(cstring)
Dim sql As String = "select max(字段名) from 表名" con.Open() Dim cmd As New OleDb.OleDbCommand(sql, con) Dim myreader As OleDbDataReader = cmd.ExecuteReader myreader.Read TextBox1.Text = myreader(0) con.Close()
End Sub 如果你对菜鸟急求vb.net对access数据库操作中取出某列最大值的代码这个问题有好的意见或
建议,请留言
|