I'm having a problem figuring this out. I'm
trying to convert from days, hours, minutes to just minutes to input
into SQL then query back to display on the form back to days, hours,
minutes and I'm getting the syntax wrong. Can someone assist? Thanks!!
Protected Sub Load_values()
Dim cn As SqlConnection
Dim cmd As SqlCommand
Dim str As String
Dim connStr As String = ConfigurationManager.ConnectionStrings("D01PMAINTPLANConnectionString").ConnectionString
cn = New SqlConnection(connStr)
str = "SELECT * FROM dbo.OPMD_Add_Budget WHERE pkey = " &
Int(Session("PKey")) & " AND ID in(select max(id) from
dbo.OPMD_Add_Budget where schedule <> '')"
cmd = New SqlCommand(str, cn)
cn.Open()
Dim rdr As SqlDataReader = cmd.ExecuteReader()
Dim da ...
Go to the complete details ...