Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    11

    Unanswered: ASP.net connection Code Problems

    I am working on Microsoft access that have liked tabled to SQL, I want to develop an ASP page to update and add and evaluate data in the SQL database.
    A sample code of what I use in access is:

    The SQL database name is Ichrdfinance
    The SQL server name is AHMEDLAB\AHMED

    Code:
    Dim db As Database
        Dim rs As Recordset
        Set db = CurrentDb
        Dim ASD As String
        Dim UN As String
        UN = QLName.Value
        ASD = STNamesList.Value
        crit = "SELECT [qlist].* FROM [qlist]"
        Set rs = CurrentDb.OpenRecordset(crit, dbOpenDynaset, dbSeeChanges)
        If rs.RecordCount > 0 Then
        rs.MoveFirst
        End If
        rs.FindFirst "stn = " & ASD
        If rs.NoMatch Then
        Beep
        rs.AddNew
        rs!STN = STNamesList.Value
        rs!Uname = UN
        rs.Update
        rs.Close
    can any one can help me converting this code to ASP.net, I am working on Microsoft visual web developer 2005 express edition.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •