我们选择日期时从表中检索数据 [英] retrieve data from table when we select a date

问题描述

从表中检索数据，按钮上的

retrieve data from table when we select a date,

推荐答案

点击



选择* from table where date ='+ txtdate.text +';

on Button Click

"Select * from table where date = '" + txtdate.text + "'";

将一个新的datetimepicker控件拖到表单!!!允许你选择日期时间



示例：

drag a new datetimepicker control to form!!! allow you to pick a datetime

Example:

dim connection as new sqlconnection=""
dim selectme as string="SELECT * FROM table WHERE myDate ='"& datetimepicker1.text &"'" 
dim cmdme as new sqlcommand(selectme,connection)
Dim sqladpt As New OleDbDataAdapter
        Dim tbl As New DataTable
        With cmdme
            .CommandText = selectme
            .Connection = connection
        End With
        With sqladpt
            .SelectCommand = cmdme
            .Fill(tbl)
        End With
        DataGridView1.Rows.Clear()
        For i = 0 To tbl.Rows.Count - 1
            With DataGridView1
                .Rows.Add(tbl.Rows(i)("fieldname"), tbl.Rows(i)("fieldname"))
            End With
        Next
        connection.Close()

只需更改datetimepicker1.value或文本以匹配表的当前数据类型

just change the datetimepicker1.value or text to match your table's current datatype

参考： read-data-from-sql-database-using-datetime-picker [ ^ ]

这篇关于我们选择日期时从表中检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！