注册 登录
编程论坛 VB.NET论坛

数据库查询问题

smy727 发布于 2013-02-28 12:15, 438 次点击
第一个问题:这个查询代码是按排序方法查找的,能不能输入头一个字母就查找出结果的代码?
比如"D*'就把D开头的所有记录

    Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
        Dim intposition As Integer
        Select Case ComboBox1.SelectedIndex
            Case 0
                objdataview.Sort = "姓名"
            Case 1
                objdataview.Sort = "地址"
            Case 2
                objdataview.Sort = "联系电话"
        End Select
        intposition = objdataview.Find(TextBox1.Text)
        If intposition = -1 Then
            txtrecordposition.Text = "找不到数据"
        Else
            objcurrencymanager.Position = intposition
        End If
        showposition()
    End Sub
第二个问题:查找记录中摸个列(数据类型)的最大值代码怎么写?
5 回复
#2
不说也罢2013-02-28 17:50
第一,用SQL查询语句的"like",看书或百度,例如:select * from aa where nn like 'd%'
第二,MAX 例如,select max(age) from aa"
#3
smy7272013-02-28 23:53
具体怎么写呀?我是这样声明的
Public Class Form1
    Dim objconnection As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\数据库\shujuku.accdb")
    Dim objdataadapter As New OleDbDataAdapter("SELECT  姓名,地址,练习电话 FROM biao ORDER BY 序号", objconnection)
    Dim objdataview As DataView
    Dim objdataset As DataSet
    Dim objcurrencymanager As CurrencyManager
#4
smy7272013-03-01 00:18
是不是重新连接数据库?
#5
不说也罢2013-03-01 11:58
从坛子里找个简单的.net操作数据库的例子啃一啃吧
#6
Audience清风2016-10-20 14:18
select * from 表名 where 列名 like 'd%' ;
1