How to search SQL dattime data with dattime picker

Question

SQL Server database has a table column, datatype -datetime. I want to search the Datagridview via vb.net but it is not working.
I would have benefited if an experienced person had wasted his precious time and cooperated in the solution. Thanks
Thanks in advance to the experienced collaborators.

Private Function getdata() As Loginout

    Dim cmd As New SqlCommand("  

Select User_Name,User_Type,Time,LoginHistory from tbl_LoginHistory ", con)

    Dim sda As New SqlDataAdapter(cmd)  
    cmd.Parameters.Add("@d1", SqlDbType.Date).Value = Format(Me.DateTimePicker1.Value, "yyyy-MM-dd HH:mm:ss.fff")  

    cmd.Parameters.Add("@d2", SqlDbType.Date).Value = Format(Me.DateTimePicker2.Value, "yyyy-MM-dd HH:mm:ss.fff")  
    Dim dscust As New Loginout  
    sda.Fill(dscust, "DataTable1")  
    Return dscust  

End Function

Answer 1

Hi @jewel ,
Change the parameterized query statement to the following code.

Dim cmd As New SqlCommand("Select User_Name,User_Type,Time,LoginHistory from tbl_LoginHistory WHERE Time BETWEEN '@d1' and '@d2'", con)  

Best Regards.
Jiachen Li

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.