Retrive stored date and time from database

Your question is way too vague. It all depends on what kind of database and how your database is setup. You haven't even told us if you are trying to access this from a windows forms project or a web project.

It sounds like you need to do some research. Try google[^] for some basic tutorials. Or you can read some of the articles[^] here on CodeProject. When you run into a more specific problem, then come back here and post the code you are working with and any error messages you get and we can help you.

Hello

One of the solution is creating a stored procedure in your database (SQL Server)

For example:
Create

Procedure   SelectDateTime
(
    @FileName   as  NVarChar(128),
    @FilePath   As  NVarChar(256)
)
As
Begin
        Select  *   From    MyTable
                        Where   MyTable.FileName = @FileName    And
                                    MyTable.FilePath =  @FilePath
End

Then you execute call your Stored Procedure from VB.Net

Dim sqlConnection1 As SqlConnection = New SqlConnection("The Connection String")
Dim cmd As SqlCommand = New SqlCommand
Dim reader As SqlDataReader
cmd.CommandText = "SelectDateTime"
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection = sqlConnection1
cmd.Parameters.Add(New SqlParameter("@FileName", fileName))
cmd.Parameters.Add(New SqlParameter("@FilePath", filePath))
Try 
     sqlConnection1.Open
     reader = cmd.ExecuteReader
Catch ex As Exception
     
Finally
     sqlConnection1.Close
End Try

One of the other solutions is using ADO.Net Entity Framework.
Look at these

http://msdn.microsoft.com/en-us/data/ee712907[^]

http://msdn.microsoft.com/en-us/data/aa937723[^]