Dim strQRY As String = "Select Max(id) From DESIGNATION"
Dim conTemp As New SqlConnection
conTemp.ConnectionString = CONNECTIONSTRING
conTemp.Open()
Dim command As New SqlCommand(strQRY, conTemp)
Dim reader As SqlDataReader = command.ExecuteReader()
Return reader(0)
when i query the same thing i'm getting result in sqlserver but above code giving pbm
Dim conTemp As New SqlConnection
conTemp.ConnectionString = CONNECTIONSTRING
conTemp.Open()
Dim command As New SqlCommand(strQRY, conTemp)
Dim reader As SqlDataReader = command.ExecuteReader()
Return reader(0)
when i query the same thing i'm getting result in sqlserver but above code giving pbm