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
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.FindFirst "stn = " & ASD
If rs.NoMatch Then
rs!STN = STNamesList.Value
rs!Uname = UN
can any one can help me converting this code to ASP.net, I am working on Microsoft visual web developer 2005 express edition.