Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two Questions - Get @@identity and pass to new page
Message
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00876853
Message ID:
00876875
Views:
14
This message has been marked as a message which has helped to the initial question of the thread.
Hi Kirk!

Here's some code I'm using.
Dim oConn as SqlClient.SqlConnection = New SqlClient.SqlConnection("server=(local),database=test,user=sa,password=sa")
Dim oDA As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter("select * from table1 where field1='1'", oConn)
Dim ds As New DataSet
oDA.Fill(ds, "table1")
If ds.Tables("table1").Rows(0).Item("field2").Value="2"
  RetValue = True
Else
  RetValue = False
End If
HTH
robert.oh.
Previous
Reply
Map
View

Click here to load this message in the networking platform