ASP.net connection Code Problems

ahmed_zedan · #1 (**permalink**) 01-21-06, 21:09

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.