ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Use direct SQL to insert data to database in VB
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

  Sub Page_Load(Sender As Object, E As EventArgs)
    Dim objConnection As OleDbConnection
    Dim objCmd        As OleDbCommand
    Dim strConnection As String
    Dim strSQL        As String
    
    strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                    "Data Source="+MapPath("EmployeeDatabase.mdb")
  
    objConnection = New OleDbConnection(strConnection)
    objConnection.Open()
    
    strSQL = "INSERT INTO Employee(FirstName,LastName)" & _
                      " VALUES ( 'Beth' , 'Hart' )"
    objCmd = New OleDbCommand(strSQL, objConnection)
    
    objCmd.ExecuteNonQuery()
    lblStatus.Text = "Command run"
  End Sub


  
    

Using SQL directly


    
  

           
       
EmployeeDatabase.zip( 10 k)