Author: photoshopgrl | Posted on: 12/29/2008 8:28:27 AM | Views : 279

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 ...