<%@ 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 our community forum.
Technical support is unable to assist with specific coding issues.
Article ID: 372, Created On: 11/24/2008, Modified: 4/13/2010