Add OleDbCommand Parameter : OleDbCommand Parameter  « Database ADO.net « VB.Net

Home
VB.Net
1.2D
2.Application
3.Class
4.Data Structure
5.Data Types
6.Database ADO.net
7.Date Time
8.Development
9.Event
10.File Directory
11.Generics
12.GUI
13.Internationalization I18N
14.Language Basics
15.LINQ
16.Network Remote
17.Reflection
18.Security
19.Thread
20.Windows Presentation Foundation
21.Windows System
22.XML
23.XML LINQ
VB.Net » Database ADO.net » OleDbCommand Parameter Screenshots 
Add OleDbCommand Parameter
Add OleDbCommand Parameter

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Collections
Imports System.Windows.Forms
Imports System.Resources

Public Class MainClass
    Shared Dim OleDbConnection As System.Data.OleDb.OleDbConnection
    Shared Dim AddressBookDataAdapter As System.Data.OleDb.OleDbDataAdapter

    Shared Sub Main()
       Connect()
       Display()
       
       Dim ID As String = "1"


       Dim OleDbUpdateCommand As System.Data.OleDb.OleDbCommand
       OleDbUpdateCommand = new System.Data.OleDb.OleDbCommand
       
       OleDbUpdateCommand.CommandText = _
               "Delete from Employee WHERE id= ? ;  "

       OleDbUpdateCommand.Parameters.Add_
           New System.Data.OleDb.OleDbParameter("id",  _
           System.Data.OleDb.OleDbType.Numeric,  _
           0,  _
           System.Data.ParameterDirection.Input,  _
           False,  _
           CType(10, Byte),  _
           CType(0, Byte),  _
           "id",  _
           System.Data.DataRowVersion.Original,  _
           1))
               
       OleDbUpdateCommand.Connection = OleDbConnection

       AddressBookDataAdapter.UpdateCommand = OleDbUpdateCommand


       AddressBookDataAdapter.UpdateCommand.ExecuteNonQuery()


       Display()
       Disconnect()
    End Sub

    Shared Sub Display()
       Dim OleDbSelectCommand As System.Data.OleDb.OleDbCommand
       OleDbSelectCommand = New System.Data.OleDb.OleDbCommand()

       OleDbSelectCommand.CommandText = "SELECT ID, FirstName, LastName,Salary FROM Employee"
       OleDbSelectCommand.Connection = OleDbConnection

       AddressBookDataAdapter = New System.Data.OleDb.OleDbDataAdapter()

       AddressBookDataAdapter.SelectCommand = OleDbSelectCommand


       Dim AddressBookDataSet As System.Data.DataSet
       AddressBookDataSet = New System.Data.DataSet()
       CType(AddressBookDataSet, System.ComponentModel.ISupportInitialize).BeginInit()

       AddressBookDataAdapter.Fill(AddressBookDataSet)


         Dim dataTable As DataTable = AddressBookDataSet.Tables(0)

         ' ensure dataTable not empty
         If dataTable.Rows.Count <> Then
            Dim recordNumber As Integer = Convert.ToInt32(dataTable.Rows(0)(0))

            Console.WriterecordNumber.ToString & "  ")
            Console.WriteConvert.ToString(dataTable.Rows(0)(1)) "  ")
            Console.WriteConvert.ToString(dataTable.Rows(0)(2)) "  ")
            Console.WriteConvert.ToString(dataTable.Rows(0)(3)) "  ")

            ' display not-found message
         Else
            Console.WriteLine"No record found" )
         End If
         Console.WriteLine(  )
    End Sub

    Shared Sub Connect()
      OleDbConnection = New System.Data.OleDb.OleDbConnection()

      OleDbConnection.ConnectionString = _
         "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";" & _
         "User ID=Admin;Data Source=Employee.mdb;Mode=Sha" & _
         "re Deny None;Extended Properties="""";" & _
         "Jet OLEDB:System database="""";Jet OLEDB:Regis" & _
         "try Path="""";Jet OLEDB:Database Password="""";" & _
         "Jet OLEDB:Engine Type=5;Jet OLEDB:Dat" & _
         "abase Locking Mode=1;Jet OLEDB:Global Partial " & _
         "Bulk Ops=2;Jet OLEDB:Global Bulk T" & _
         "ransactions=1;Jet OLEDB:New Database " & _
         "Password="""";Jet OLEDB:Create System Databas" & _
         "e=False;Jet OLEDB:Encrypt Database=False;" & _
         "Jet OLEDB:Don't Copy Locale on Compact=" & _
         "False;Jet OLEDB:Compact Without Replica " & _
         "Repair=False;Jet OLEDB:SFP=False"


      Try
         OleDbConnection.Open()
      Catch ex As Exception
         Console.WriteLine(ex.Message)
      End Try
    End Sub

    Shared Sub Disconnect()
      Try
         OleDbConnection.Close()
      Catch ex As Exception
         Console.WriteLine(ex.Message)
      End Try
    End Sub

End Class

               
               

           
       
Employee.zip( 7 k)
Related examples in the same category
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.