<%@ import namespace="system.data.sqlclient" %>
<Script runat="server">
Sub page_load
Dim dbconn as sqlconnection
Dim dbCMD as sqlCommand
dbConn = New SQLConnection ("Data Source=DBSERVERNAME;Initial Catalog=YOURDBNAME;User ID=YOURUSERID;Password=YOURPASSWORD")
dbConn.open()
dbCMD = new sqlcommand ("insert into tblTest values ('test')",dbconn)
dbCMD.executenonquery()
dbConn.close()
End Sub
</Script>
Record Inserted
If you run into problems when using this code, please post in the DiscountASP.NET or Everleap community forum. Technical support is unable to assist with specific coding issues.
Article ID: 372, Created: 11/24/2008 at 4:55 PM, Modified: 9/19/2016 at 3:39 PM