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 in to problems using this code, please post in our community forum. Technical support cannot assist with specific coding related issues.

Article ID: 639, Created On: 8/14/2009, Modified: 4/21/2011

Knowledge Base

Forum

Blog

Google +

Twitter

Facebook

Article Rating

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

Comments (0)