hellow sir,
erorr in visual basic ' fill' is not member of mysqldataadapter how i fill datatable from dataadapter
when i trying to recordcount =dbda.fill(dbdt)
it show error ' fill' is not member of sql_user.mysqldataadapter
need help
Imports MySql.Data.MySqlClient
Public Class sqlcontrol1
Private DBCon As New MySqlConnection
Private DBCmd As MySqlCommand
' DB DATA
Public DBDA As MySqlDataAdapter
Public DBDT As DataTable
' QUERY PARAMETERS
Friend Params As New List(Of sqlParameter)
' QUERY STATISTICS
Public RecordCount As Integer
Public Exception As String
Public Sub New()
End Sub
Public Sub New(ConnectionString As String)
DBCon.ConnectionString = "server=127.0.0.1;userid=root;password=yogababa72;database=movedb;"
End Sub
' EXECUTE QUERY SUB
Public Sub ExecQuery(Query As String)
RecordCount = 0
Exception = ""
Try
DBCon.Open()
' CREATE DB COMMAND
DBCmd = New MySqlCommand(Query, DBCon)
' LOAD PARAMS INTO DB COMMAND
Params.ForEach(Sub(p) DBCmd.Parameters.Add(p))
' CLEAR PARAM LIST
Params.Clear()
' EXECUTE COMMAND & FILL DATASET
DBDT = New DataTable
DBDA = New MySqlDataAdapter(DBCmd)
RecordCount = DBDA.Fill(DBDT)
Catch ex As Exception
End Try
End Sub