Public Class Customerdetails
Inherits System.Windows. Forms.Form
Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As System.EventArg s) Handles Button1.Click
updatecustomerd atabase("Insert INTO Customer (FirstName), VALUES cstr(txtcustome rname.text)")
End Sub
Sub updatecustomerd atabase(ByVal sqlStr As String)
Dim newcustomer As New DataTable
Dim connStr As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source = maindatabase.md b"
Dim dataAdaptor4 As New OleDb.OleDbData Adapter(sqlStr, connStr)
dataAdaptor4.Fi ll(newcustomer)
dataAdaptor4.Di spose()
End Sub
End Class
Inherits System.Windows. Forms.Form
Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As System.EventArg s) Handles Button1.Click
updatecustomerd atabase("Insert INTO Customer (FirstName), VALUES cstr(txtcustome rname.text)")
End Sub
Sub updatecustomerd atabase(ByVal sqlStr As String)
Dim newcustomer As New DataTable
Dim connStr As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source = maindatabase.md b"
Dim dataAdaptor4 As New OleDb.OleDbData Adapter(sqlStr, connStr)
dataAdaptor4.Fi ll(newcustomer)
dataAdaptor4.Di spose()
End Sub
End Class
Comment