I cant use Fill()..

[Mich Austria]

why cant i use fill in my database?? is there any wrong in my code??
Imports System.Data.OleDb


Public Class Form1
Dim Query As String = "Provider=Microsoft.Jet.OleDb.4.0; Data Source = " & Application.StartupPath & "\data1.mdb"
Dim conn As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim adapter As New OleDbDataAdapter
Dim comm As OleDbCommand
Dim buttonClicked As Boolean = False


Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load


conn.Open()
-----I WANT TO PUT FILL() HERE..----------------------------------------------

End Sub

its not yet done.. please tell me whats wrong.. thanks..

 

[jmcilhinney]

What's wrong is that you haven't put Fill there.

 

[Mich Austria]

there is no fill option.. i dont know why..

What's wrong is that you haven't put Fill there.

if i put fill() there. FillErrorEventArgs() <--- this comes up
and i cant only put fill()

got it.. i dont have sub fill()... thanks BTW..

 

[jmcilhinney]

Fill is not a Sub. It's a Function. It's also a member of the data adapter. Just as you are calling Open on the connection, so you call Fill on the data adapter.

 

[lisaa]

Thanks for all of this.......