1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How do I migrate these lines from ASP to ASP.Net?

Discussion in 'C#' started by vidamia_lana, Jun 30, 2010.

0
  1. #1
    If Not objRS.EOF Then
    If objRS.RecordCount > 0 Then
    nMyPage = CInt(mypage)
    nRecStart = (nMyPage - 1) * maxrecs
    iCount = 0

    Do Until objRS.eof Or howmanyrecs >= maxrecs
    nRecStart = nRecStart + 1
    i = nRecStart
    iCount = iCount + 1

    SQL02 = "SELECT DISTINCT GDAccessCatCd FROM tbledbusunit WHERE GDAccessCatCd = '" & Trim(objrs.fields(0).value) & "'"
    SQL03 = "SELECT DISTINCT GDAccessCatCd FROM GDAccessCatInfoDetInfoCatRel WHERE GDAccessCatCd = '" & Trim(objrs.fields(0).value) & "'"
    SQL04 = SQL02 & " UNION " & SQL03

    RecSet = ObjHRMISDACom.SQLSelectRS(SQL04, strFILEDSN)
    If IsConnOK(RecSet) Then strDisabled = " DISABLED " Else strDisabled = ""
    RecSet.Close()

    If Trim(objrs.fields(0).value) = "01" Then
    strDisabled = " disabled "
    Else
    strDisabled = ""
    End If
     
    vidamia_lana, Jun 30, 2010 IP
  2. bitstream

    bitstream Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    http://forums.digitalpoint.com/showthread.php?t=1855498
     
    bitstream, Jul 4, 2010 IP