1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:

public override int MakeConnection ()
      {
        conString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
        conString = conString + prmDataSource;
        conString = conString + ";Extended Properties=dBASE IV;User ID=xyz;Password=";
        prmName = "PassFail";
        connection = new OleDbConnection(conString);

        string sqlStr = "Select * From PassFail";
        da = new OleDbDataAdapter(sqlStr, connection);
        da.MissingSchemaAction = MissingSchemaAction.AddWithKey;

        connection.Open();
   
        da.Fill(DS, "PassFail");

        TablesCount = DS.Tables.Count;
        return 0;
      }                    

1:
2:

OleDbCommand cmd1 = new OleDbCommand("Select DISTINCT Testresult, Testmode, Date From Passfail");
            OleDbDataReader dr1 = cmd1.ExecuteReader();