How to insert data into an MS SQL database with .NET SQL Data Provider in ASP.NET

<%@ 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.