I have multiple records in my datareader, but only one record in being added to
my Min_Delivered_Transaction ItemType. How do I create a loop for the DataReader to
add all records?
.
.
myConnection.Open();
System.Data.OleDb.OleDbDataReader myDataReader = com.ExecuteReader();
// create a MIN_Delivered_Transaction item
Item res5 = this.newItem("MIN_Delivered_Transaction");
string newid = getNewID();
res5.setID(newid);
res5 = res5.apply();
while (myDataReader.Read())
{
res5.setProperty("f_dc",myDataReader.GetString(0));
res5.setProperty("f_trans_group",myDataReader.GetString(1));
res5.setProperty("f_part_number",myDataReader.GetString(2));
res5.setProperty("f_part_name",myDataReader.GetString(3));
};
myConnection.Close();
return res5;