DataAdapter Fill Dataset

Question

i try to get some Data from a Access Database via OleDB in a DataSet  But the DataSet is empty after the Fill   method  The same statement works and return 1 row when i trigger them manually in D    OleDbConnection connection       new OleDbConnection  Provider Microsoft ACE OLEDB 12 0 Data Source Inventar accdb    DataSet1 DS   new DataSet1    connection Open     OleDbDataAdapter DBAdapter   new OleDbDataAdapter        SELECT tbl Computer     tbl Besitzer         FROM tbl Computer        INNER JOIN tbl Besitzer ON tbl Computer FK Benutzer   tbl Besitzer ID        WHERE    tbl Besitzer Vorname   ma            connection    DBAdapter Fill DS     Thanks in advance   New working code   DataSet ds   new DataSet    OleDbDataAdapter DBAdapter   new OleDbDataAdapter     OleDbConnection connection   new OleDbConnection  Provider Microsoft ACE OLEDB 12 0 Data Source Inventar accdb    string query          SELECT tbl Computer     tbl Besitzer       FROM tbl Computer      INNER JOIN tbl Besitzer ON tbl Computer FK Benutzer   tbl Besitzer ID      WHERE    tbl Besitzer Vorname   ma        connection Open     using  OleDbCommand command   new OleDbCommand query  connection   using  OleDbDataAdapter adapter   new OleDbDataAdapter command         adapter Fill ds      Dictionary lt string  string gt  DictValues   new Dictionary lt string  string gt      for  int i   0  i  lt   ds Tables 0  Rows 0  ItemArray Length - 1  i          MessageBox Show ds Tables 0  Rows 0  ItemArray i      --     ds Tables 0  Rows 0  Table Columns i        DictValues Add ds Tables 0  Rows 0  Table Columns i  ToString    ds Tables 0  Rows 0  ItemArray i  ToString         Now The Right code is posted above  with an Dictonary to access the Data more comfortable  hope anybody find help in this post  Thank you all for get it work

User · Answer

leDbConnection connection    new OleDbConnection  Provider Microsoft ACE OLEDB 12 0 Data Source Inventar accdb    DataSet1 DS   new DataSet1    connection Open     OleDbDataAdapter DBAdapter   new OleDbDataAdapter    SELECT tbl Computer     tbl Besitzer     FROM tbl Computer    INNER JOIN tbl Besitzer ON tbl Computer FK Benutzer   tbl Besitzer ID    WHERE    tbl Besitzer Vorname   ma        connection

User · Answer

DataSet ds   new DataSet     using  OleDbConnection connection   new OleDbConnection connectionString   using  OleDbCommand command   new OleDbCommand query  connection   using  OleDbDataAdapter adapter   new OleDbDataAdapter command         adapter Fill ds      return ds

User · Answer

it works for me  just change  Provider Microsoft Jet OLEDB 4 0  VS2013   OleDbConnection connection   new OleDbConnection   Provider Microsoft Jet OLEDB 4 0 Data Source Z   GENERAL  OFMPTP PD SG MDB    DataSet DS   new DataSet    connection Open     string query     SELECT   from MONTHLYPROD   OleDbDataAdapter DBAdapter   new OleDbDataAdapter    DBAdapter SelectCommand   new OleDbCommand query  connection   DBAdapter Fill DS     Luis Montoya

User · Answer

You need to do this   OleDbConnection connection   new OleDbConnection       Provider Microsoft ACE OLEDB 12 0 Data Source Inventar accdb    DataSet DS   new DataSet    connection Open     string query          SELECT tbl Computer     tbl Besitzer       FROM tbl Computer      INNER JOIN tbl Besitzer ON tbl Computer FK Benutzer   tbl Besitzer ID      WHERE    tbl Besitzer Vorname   ma      OleDbDataAdapter DBAdapter   new OleDbDataAdapter    DBAdapter SelectCommand   new OleDbCommand query  connection    DBAdapter Fill DS     By the way  what is this DataSet1  This should be  DataSet

[c#] DataAdapter.Fill(Dataset)

Examples related to c#

Examples related to ado.net

Examples related to dataset

Examples related to oledb

Examples related to oledbdataadapter