Teadmistebaas

Insert data into a MS SQL database with .NET SQL Data Provider in ASP.NET

                                                         1 
 2 
 3 <%@ import namespace="system.data.sqlclient" %>
 4 <Script runat="server">
 5 Sub page_load
 6             Dim dbconn as sqlconnection
 7             Dim dbCMD as sqlCommand
 8             dbConn = New SQLConnection ("Data Source=DBSERVERNAME;Initial Catalog=YOURDBNAME;User ID=YOURUSERID;Password=YOURPASSWORD")
 9             dbConn.open()
10             dbCMD = new sqlcommand ("insert into tblTest values ('test')",dbconn)
11             dbCMD.executenonquery()
12             dbConn.close()
13 End Sub
14 Script>
15 Record Inserted
16 
17 
18